Sorry, unfortunately we are experiencing some problems with the application at the moment. Our team of developers and server administrators are investigating the problem.
We highly appreciate your patience and please accept our apologies for any inconvenience caused.Database_Exception [ HY000 ]: SQLSTATE[HY000]: General error: 207 General SQL Server error: Check messages from the SQL Server [207] (severity 16) [
SELECT
(unique_name + weeks+day_of_week + room + event_type + st_time) AS unique_id,
unique_name,
unitcode,
name,
WeekNo,
ClassDate,
day_of_week,
st_time,
en_time,
event_type,
room,
room_description,
notes,
weeks,
semester_location,
protected,
weekNumbers,
unitcode,
campus,
semester,
durationInMinutes,
modulehk,
instStartDate,
CAST(instStartDate as varchar) as year_start_date ,PlannedSize FROM rdowner.Web_Event_Timetable
WHERE event_type NOT IN ('Campus T','Campus O') AND ( semester LIKE 'S1' OR semester LIKE 'S1N' OR semester LIKE 'AU1' OR semester LIKE 'ST2' OR semester LIKE 'H' OR semester LIKE 'AU3' OR semester LIKE 'UA7' OR semester LIKE 'AU7' OR semester LIKE 'S1E' OR semester LIKE 'S1K' OR semester LIKE 'AW1' OR semester LIKE 'S1S' OR semester LIKE 'S1' OR semester LIKE 'AW5' OR semester LIKE 'TS13E' OR semester LIKE 'TS23E' OR semester LIKE 'TS23' OR semester LIKE 'YU5' OR semester LIKE 'Y' OR semester LIKE 'YU2' OR semester LIKE 'TS13' OR semester LIKE 'ST1' OR semester LIKE 'AW4' OR semester LIKE 'T1' OR semester LIKE 'T2' OR semester LIKE 'YU4' OR semester LIKE 'AW6' OR semester LIKE 'AU4' OR semester LIKE 'AW3')
AND campus LIKE 'MUR' AND protected != 'Y' AND event_type NOT LIKE '%labprep%' AND ( unique_name LIKE 'CHE140%') ORDER BY CASE
WHEN day_of_week = 'Monday' THEN 1
WHEN day_of_week = 'Tuesday' THEN 2
WHEN day_of_week = 'Wednesday' THEN 3
WHEN day_of_week = 'Thursday' THEN 4
WHEN day_of_week = 'Friday' THEN 5
WHEN day_of_week = 'Saturday' THEN 6
WHEN day_of_week = 'Sunday' THEN 7
END , unique_name , st_time , event_type] [
SELECT
(unique_name + weeks+day_of_week + room + event_type + st_time) AS unique_id,
unique_name,
unitcode,
name,
WeekNo,
ClassDate,
day_of_week,
st_time,
en_time,
event_type,
room,
room_description,
notes,
weeks,
semester_location,
protected,
weekNumbers,
unitcode,
campus,
semester,
durationInMinutes,
modulehk,
instStartDate,
CAST(instStartDate as varchar) as year_start_date ,PlannedSize FROM rdowner.Web_Event_Timetable
WHERE event_type NOT IN ('Campus T','Campus O') AND ( semester LIKE 'S1' OR semester LIKE 'S1N' OR semester LIKE 'AU1' OR semester LIKE 'ST2' OR semester LIKE 'H' OR semester LIKE 'AU3' OR semester LIKE 'UA7' OR semester LIKE 'AU7' OR semester LIKE 'S1E' OR semester LIKE 'S1K' OR semester LIKE 'AW1' OR semester LIKE 'S1S' OR semester LIKE 'S1' OR semester LIKE 'AW5' OR semester LIKE 'TS13E' OR semester LIKE 'TS23E' OR semester LIKE 'TS23' OR semester LIKE 'YU5' OR semester LIKE 'Y' OR semester LIKE 'YU2' OR semester LIKE 'TS13' OR semester LIKE 'ST1' OR semester LIKE 'AW4' OR semester LIKE 'T1' OR semester LIKE 'T2' OR semester LIKE 'YU4' OR semester LIKE 'AW6' OR semester LIKE 'AU4' OR semester LIKE 'AW3')
AND campus LIKE 'MUR' AND protected != 'Y' AND event_type NOT LIKE '%labprep%' AND ( unique_name LIKE 'CHE140%') ORDER BY CASE
WHEN day_of_week = 'Monday' THEN 1
WHEN day_of_week = 'Tuesday' THEN 2
WHEN day_of_week = 'Wednesday' THEN 3
WHEN day_of_week = 'Thursday' THEN 4
WHEN day_of_week = 'Friday' THEN 5
WHEN day_of_week = 'Saturday' THEN 6
WHEN day_of_week = 'Sunday' THEN 7
END , unique_name , st_time , event_type ] ~ MODPATH/database/classes/kohana/database/pdo.php [ 157 ]