Debug info: ERROR: value "2148605999" is out of range for type integer
CONTEXT: unnamed portal parameter $5 = '...'
SELECT e.*, c.fullname AS coursefullname, c.shortname AS courseshortname
FROM mdl_event e
INNER JOIN (SELECT ev.modulename,
ev.instance,
ev.eventtype,
MIN(ev.priority) as priority
FROM (SELECT modulename, instance, eventtype, priority
FROM mdl_event ev
WHERE (ev.userid = $1 AND ev.courseid = 0 AND ev.groupid = 0 AND ev.categoryid = 0) UNION SELECT modulename, instance, eventtype, priority
FROM mdl_event ev
WHERE ((ev.groupid = 0 AND ev.courseid = $2 AND ev.categoryid = 0)) AND (timestart >= $3 OR timestart + timeduration > $4) AND timestart <= $5) ev
GROUP BY ev.modulename, ev.instance, ev.eventtype) fe
ON e.modulename = fe.modulename
AND e.instance = fe.instance
AND e.eventtype = fe.eventtype
AND (e.priority = fe.priority OR (e.priority IS NULL AND fe.priority IS NULL))
LEFT JOIN mdl_modules m
ON e.modulename = m.name
LEFT JOIN mdl_course c
ON c.id = e.courseid
WHERE (m.visible = 1 OR m.visible IS NULL) AND (timestart >= $6 OR timestart + timeduration > $7) AND timestart <= $8 AND ((e.userid = $9 AND e.courseid = 0 AND e.groupid = 0 AND e.categoryid = 0) OR (e.groupid = 0 AND e.courseid = $10)) AND (e.visible = 1)
ORDER BY COALESCE(e.timesort, e.timestart) ASC, e.id ASC
-- line 349 of /calendar/classes/local/event/strategies/raw_event_retrieval_strategy.php: call to pgsql_native_moodle_database->get_records_sql()
-- line 51 of /calendar/classes/local/event/strategies/raw_event_retrieval_strategy.php: call to core_calendar\local\event\strategies\raw_event_retrieval_strategy->get_raw_events_legacy_implementation()
-- line 164 of /calendar/classes/local/event/data_access/event_vault.php: call to core_calendar\local\event\strategies\raw_event_retrieval_strategy->get_raw_events()
-- line 94 of /calendar/classes/local/api.php: call to core_calendar\local\event\data_access\event_vault->get_events()
-- line 3524 of /calendar/lib.php: call to core_calendar\local\api::get_events()
-- line 164 of /calendar/view.php: call to calendar_get_view()
[array (
0 => '38',
1 => '1',
2 => 2145927600,
3 => 2145927600,
4 => 2148605999,
5 => 2145927600,
6 => 2145927600,
7 => 2148605999,
8 => '38',
9 => '1',
)]
Error code: dmlreadexception
CONTEXT: unnamed portal parameter $5 = '...'
SELECT e.*, c.fullname AS coursefullname, c.shortname AS courseshortname
FROM mdl_event e
INNER JOIN (SELECT ev.modulename,
ev.instance,
ev.eventtype,
MIN(ev.priority) as priority
FROM (SELECT modulename, instance, eventtype, priority
FROM mdl_event ev
WHERE (ev.userid = $1 AND ev.courseid = 0 AND ev.groupid = 0 AND ev.categoryid = 0) UNION SELECT modulename, instance, eventtype, priority
FROM mdl_event ev
WHERE ((ev.groupid = 0 AND ev.courseid = $2 AND ev.categoryid = 0)) AND (timestart >= $3 OR timestart + timeduration > $4) AND timestart <= $5) ev
GROUP BY ev.modulename, ev.instance, ev.eventtype) fe
ON e.modulename = fe.modulename
AND e.instance = fe.instance
AND e.eventtype = fe.eventtype
AND (e.priority = fe.priority OR (e.priority IS NULL AND fe.priority IS NULL))
LEFT JOIN mdl_modules m
ON e.modulename = m.name
LEFT JOIN mdl_course c
ON c.id = e.courseid
WHERE (m.visible = 1 OR m.visible IS NULL) AND (timestart >= $6 OR timestart + timeduration > $7) AND timestart <= $8 AND ((e.userid = $9 AND e.courseid = 0 AND e.groupid = 0 AND e.categoryid = 0) OR (e.groupid = 0 AND e.courseid = $10)) AND (e.visible = 1)
ORDER BY COALESCE(e.timesort, e.timestart) ASC, e.id ASC
-- line 349 of /calendar/classes/local/event/strategies/raw_event_retrieval_strategy.php: call to pgsql_native_moodle_database->get_records_sql()
-- line 51 of /calendar/classes/local/event/strategies/raw_event_retrieval_strategy.php: call to core_calendar\local\event\strategies\raw_event_retrieval_strategy->get_raw_events_legacy_implementation()
-- line 164 of /calendar/classes/local/event/data_access/event_vault.php: call to core_calendar\local\event\strategies\raw_event_retrieval_strategy->get_raw_events()
-- line 94 of /calendar/classes/local/api.php: call to core_calendar\local\event\data_access\event_vault->get_events()
-- line 3524 of /calendar/lib.php: call to core_calendar\local\api::get_events()
-- line 164 of /calendar/view.php: call to calendar_get_view()
[array (
0 => '38',
1 => '1',
2 => 2145927600,
3 => 2145927600,
4 => 2148605999,
5 => 2145927600,
6 => 2145927600,
7 => 2148605999,
8 => '38',
9 => '1',
)]
Error code: dmlreadexception
Stack trace:
- line 497 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
- line 358 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
- line 1044 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
- line 349 of /calendar/classes/local/event/strategies/raw_event_retrieval_strategy.php: call to pgsql_native_moodle_database->get_records_sql()
- line 51 of /calendar/classes/local/event/strategies/raw_event_retrieval_strategy.php: call to core_calendar\local\event\strategies\raw_event_retrieval_strategy->get_raw_events_legacy_implementation()
- line 164 of /calendar/classes/local/event/data_access/event_vault.php: call to core_calendar\local\event\strategies\raw_event_retrieval_strategy->get_raw_events()
- line 94 of /calendar/classes/local/api.php: call to core_calendar\local\event\data_access\event_vault->get_events()
- line 3524 of /calendar/lib.php: call to core_calendar\local\api::get_events()
- line 164 of /calendar/view.php: call to calendar_get_view()