In file /unitswww1/unitswww15/thess/iek-sindou/gieksind/public_html/openeclass/main/personal_calendar/calendar_events.class.php on line 272 : Unable to execute statement:"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR user_id = 0) AND date_format('2024-12-17',"%Y-%m") = date_format(adm.start,"' at line 1", sqlstate:"1064", errornum:"42000", statement:"SELECT id, title, start, date_format(start,'%Y-%m-%d') startdate, duration, date_format(start + time(duration), '%Y-%m-%d %H:%i') `end`, content, 'personal' event_group, 'event-special' class, 'personal' event_type, null as course FROM personal_calendar pc WHERE user_id = ? AND date_format(?,"%Y-%m") = date_format(pc.start,"%Y-%m") UNION SELECT id, title, start, date_format(start, '%Y-%m-%d') startdate, duration, date_format(start + time(duration), '%Y-%m-%d %H:%i') `end`, content, 'admin' event_group, 'event-success' class, 'admin' event_type, null as course FROM admin_calendar adm WHERE (visibility_level>= OR user_id = ?) AND date_format(?,"%Y-%m") = date_format(adm.start,"%Y-%m") UNION SELECT ag.id, CONCAT(c.title,': ',ag.title), ag.start, date_format(ag.start,'%Y-%m-%d') startdate, ag.duration, date_format(ag.start + time(ag.duration), '%Y-%m-%d %H:%i') `end`, content, 'course' event_group, 'event-info' class, 'agenda' event_type, c.code course FROM agenda ag JOIN course_user cu ON ag.course_id=cu.course_id JOIN course c ON cu.course_id=c.id WHERE cu.user_id =? AND (ag.visible = 1 OR cu.status = 1) AND ag.visible = 1 AND date_format(?,"%Y-%m") = date_format(ag.start,"%Y-%m") UNION SELECT bbb.id, CONCAT(c.title,': ',bbb.title), bbb.start_date start, date_format(bbb.start_date,'%Y-%m-%d') startdate, '00:00' duration, date_format(date_add(bbb.start_date, interval 1 hour), '%Y-%m-%d %H:%i') `end`, bbb.description content, 'course' event_group, 'event-info' class, 'teleconference' event_type, c.code course FROM bbb_session bbb JOIN course_user cu ON bbb.course_id=cu.course_id JOIN course c ON cu.course_id=c.id WHERE cu.user_id =? AND bbb.active='1' AND date_format(?,"%Y-%m") = date_format(bbb.start_date,"%Y-%m") UNION SELECT ass.id, CONCAT(c.title,': ',ass.title), ass.deadline start, date_format(ass.deadline,'%Y-%m-%d') startdate, '00:00' duration, date_format(date_add(ass.deadline, interval 1 hour), '%Y-%m-%d %H:%i') `end`, concat(ass.description,'','(deadline: ',deadline,')') content, 'deadline' event_group, 'event-important' class, 'assignment' event_type, c.code course FROM assignment ass JOIN course_user cu ON ass.course_id=cu.course_id JOIN course c ON cu.course_id=c.id LEFT JOIN assignment_to_specific ass_sp ON ass.id=ass_sp.assignment_id WHERE cu.user_id =? AND (assign_to_specific = '0' OR ass_sp.user_id = ? OR cu.status = 1) AND ass.active = 1 AND date_format(?,"%Y-%m") = date_format(ass.deadline,"%Y-%m") UNION SELECT ex.id, CONCAT(c.title,': ',ex.title), ex.end_date start, date_format(ex.end_date,'%Y-%m-%d') startdate, '00:00' duration, date_format(ex.end_date + time('00:00'), '%Y-%m-%d %H:%i') `end`, concat(ex.description,'','(deadline: ',end_date,')') content, 'deadline' event_group, 'event-important' class, 'exercise' event_type, c.code course FROM exercise ex JOIN course_user cu ON ex.course_id=cu.course_id JOIN course c ON cu.course_id=c.id WHERE cu.user_id =? AND (ex.public = 1 OR cu.status = 1) AND ex.active = 1 AND date_format(?,"%Y-%m") = date_format(ex.end_date,"%Y-%m") ORDER BY start, event_type", elapsed:0.00597