When trying to view students' submitted assignments at /mod/assignment/submissions.php?id=***, I get the following error:
Warning: mysqli::query(): (22003/1690): BIGINT UNSIGNED value is out of range in '(`moodle`.`s`.`timemarked` - `moodle`.`s`.`timemodified`)' in C:\inetpub\vhosts\***.com\lib\dml\mysqli_native_moodle_database.php on line 774
s.id AS submissionid, s.grade, s.submissioncomment,
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 = 14 WHERE u.id IN (163,7,2,20,9,10,11,8,123,118) ORDER BY lastname ASC
- line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
- line 775 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()
I am however able to download all the assignments as a zip file using the link at the top of the page.
I found the following threads about this error, but neither helped:
Any help would be greatly appreciated!