In file C:\xampp\htdocs\eclass\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 MySQL server version for the right syntax to use near 'OR user_id = 0) AND date_format('2025-3-14',"%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 tc.id, CONCAT(c.title,': ',tc.title), tc.start_date start, date_format(tc.start_date,'%Y-%m-%d') startdate, '00:00' duration, date_format(date_add(tc.start_date, interval 1 hour), '%Y-%m-%d %H:%i') `end`, tc.description content, 'course' event_group, 'event-info' class, 'teleconference' event_type, c.code course FROM tc_session tc JOIN course_user cu ON tc.course_id=cu.course_id JOIN course c ON cu.course_id=c.id WHERE cu.user_id =? AND tc.active='1' AND date_format(?,"%Y-%m") = date_format(tc.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