Just an FYI - here is the error message I received:
Warning: mysqli::query(): (22003/1690): BIGINT UNSIGNED value is out of range in '(`moodledb`.`s`.`timemarked` - `moodledb`.`s`.`timemodified`)' in C:\inetpub\wwwroot\lib\dml\mysqli_native_moodle_database.php on line 789
Debug info: BIGINT UNSIGNED value is out of range in '(`moodledb`.`s`.`timemarked` - `moodledb`.`s`.`timemodified`)'
SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
s.id AS submissionid, s.grade, s.submissioncomment,
s.timemodified, s.timemarked,
COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0) AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid
AND s.assignment = 2 WHERE u.id IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119) ORDER BY lastname ASC
[array (
)]
Stack trace:
- line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
- line 790 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1303 of \mod\assignment\lib.php: call to mysqli_native_moodle_database->get_records_sql()
- line 642 of \mod\assignment\lib.php: call to assignment_base->display_submissions()
- line 57 of \mod\assignment\submissions.php: call to assignment_base->submissions()
