Hi,
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
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 = 14 WHERE u.id IN (163,7,2,20,9,10,11,8,123,118) ORDER BY lastname ASC
[array (
)]
- 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:
http://moodle.org/mod/forum/discuss.php?d=167616&parent=735018
http://moodle.org/mod/forum/discuss.php?d=157563&parent=690244
Setting sql_mode to 'NO_UNSIGNED_SUBTRACTION' does not alleviate the problem.
I am running the latest Moodle 2.0.1+ (Build: 20110125) on PHP 5.2.17, MySQL version 5.5.8 in a Windows 2008 R2 (IIS 7.5) environment.
Any help would be greatly appreciated!
Thank you.