-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
2.1
-
None
-
MOODLE_21_STABLE
-
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 = 26 WHERE u.id IN (7,8,9,10,11,21,22,23,24,25,26,27,28,29,30) ORDER BY lastname ASC
[array (
)]
Stack trace:
line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 794 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1295 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()
- duplicates
-
MDL-27638 Assignment Module Submissions SQL overflow
-
- Closed
-