Error: Disk full (/tmp/#sql_1e4705_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query: SELECT IF((e.highlightDate >= "2024-06-14 11:27:00" OR e.highlightDate = "0000-00-00 00:00:00") AND e.highlight = "1",1,0) isHighlighted, e.*, tt.startDate, tt.endDate FROM cms_mod_calendar_event e JOIN cms_mod_calendar_event_timetable tt ON e.id = tt.eventID LEFT JOIN cms_mod_calendar_group_event ge ON e.id = ge.eventID LEFT JOIN cms_mod_calendar_group g ON g.id = ge.groupID WHERE g.id IN ("34") AND (g.siteID="30" OR (g.siteID!="30" AND e.isPrivate="0" AND g.isGlobal="1")) AND g.deleted="0" and (tt.startDate >= "2024-06-14 11:27:00" or (tt.endDate >="2024-06-14 11:27:00" and tt.startDate <= "2024-06-14 11:27:00")) AND e.deleted ="0" AND e.hidden="0" group by e.id order by isHighlighted desc, tt.startDate asc limit 3
Location: /data/home/emuweb/www/module/calendarView/calendarView.php:Line 161
Query: SELECT IF((e.highlightDate >= "2024-06-14 11:27:00" OR e.highlightDate = "0000-00-00 00:00:00") AND e.highlight = "1",1,0) isHighlighted, e.*, tt.startDate, tt.endDate FROM cms_mod_calendar_event e JOIN cms_mod_calendar_event_timetable tt ON e.id = tt.eventID LEFT JOIN cms_mod_calendar_group_event ge ON e.id = ge.eventID LEFT JOIN cms_mod_calendar_group g ON g.id = ge.groupID WHERE g.id IN ("34") AND (g.siteID="30" OR (g.siteID!="30" AND e.isPrivate="0" AND g.isGlobal="1")) AND g.deleted="0" and (tt.startDate >= "2024-06-14 11:27:00" or (tt.endDate >="2024-06-14 11:27:00" and tt.startDate <= "2024-06-14 11:27:00")) AND e.deleted ="0" AND e.hidden="0" group by e.id order by isHighlighted desc, tt.startDate asc limit 3
Location: /data/home/emuweb/www/module/calendarView/calendarView.php:Line 161
Error: Disk full (/tmp/#sql_1e4705_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query: SELECT e.*,tt.startDate,tt.endDate, tt.doorsOpen FROM cms_mod_calendar_event e,cms_mod_calendar_event_timetable tt,cms_mod_calendar_group_event ge,cms_mod_calendar_group g WHERE g.id IN ("34") and (tt.startDate < "2022-06-15 14:00:00" OR (tt.startDate = "2022-06-15 14:00:00" AND e.id<"4249")) and tt.eventID = e.id AND ge.eventID = e.id and ge.groupID = g.id AND (g.siteID="30" OR (g.siteID!="30" AND e.isPrivate="0" AND g.isGlobal="1")) AND g.deleted="0" AND e.deleted ="0" and e.hidden="0" AND e.id != "4249" ORDER BY tt.startDate DESC, e.id DESC limit 1
Location: /data/home/emuweb/www/module/calendar/calendarFull.php:Line 68
Query: SELECT e.*,tt.startDate,tt.endDate, tt.doorsOpen FROM cms_mod_calendar_event e,cms_mod_calendar_event_timetable tt,cms_mod_calendar_group_event ge,cms_mod_calendar_group g WHERE g.id IN ("34") and (tt.startDate < "2022-06-15 14:00:00" OR (tt.startDate = "2022-06-15 14:00:00" AND e.id<"4249")) and tt.eventID = e.id AND ge.eventID = e.id and ge.groupID = g.id AND (g.siteID="30" OR (g.siteID!="30" AND e.isPrivate="0" AND g.isGlobal="1")) AND g.deleted="0" AND e.deleted ="0" and e.hidden="0" AND e.id != "4249" ORDER BY tt.startDate DESC, e.id DESC limit 1
Location: /data/home/emuweb/www/module/calendar/calendarFull.php:Line 68
Error: Disk full (/tmp/#sql_1e4705_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query: SELECT e.*,tt.startDate,tt.endDate, tt.doorsOpen FROM cms_mod_calendar_event e,cms_mod_calendar_event_timetable tt,cms_mod_calendar_group_event ge,cms_mod_calendar_group g WHERE g.id IN ("34") and (tt.startDate > "2022-06-15 14:00:00" OR (tt.startDate = "2022-06-15 14:00:00" AND e.id>"4249")) and tt.eventID = e.id AND ge.eventID = e.id and ge.groupID = g.id AND (g.siteID="30" OR (g.siteID!="30" AND e.isPrivate="0" AND g.isGlobal="1")) AND g.deleted="0" AND e.deleted ="0" and e.hidden="0" AND e.id != "4249" ORDER BY tt.startDate ASC, e.id ASC limit 1
Location: /data/home/emuweb/www/module/calendar/calendarFull.php:Line 74
Query: SELECT e.*,tt.startDate,tt.endDate, tt.doorsOpen FROM cms_mod_calendar_event e,cms_mod_calendar_event_timetable tt,cms_mod_calendar_group_event ge,cms_mod_calendar_group g WHERE g.id IN ("34") and (tt.startDate > "2022-06-15 14:00:00" OR (tt.startDate = "2022-06-15 14:00:00" AND e.id>"4249")) and tt.eventID = e.id AND ge.eventID = e.id and ge.groupID = g.id AND (g.siteID="30" OR (g.siteID!="30" AND e.isPrivate="0" AND g.isGlobal="1")) AND g.deleted="0" AND e.deleted ="0" and e.hidden="0" AND e.id != "4249" ORDER BY tt.startDate ASC, e.id ASC limit 1
Location: /data/home/emuweb/www/module/calendar/calendarFull.php:Line 74