Debug info: BIGINT UNSIGNED value is out of range in '(`xpx_training`.`qa`.`timefinish` - `xpx_training`.`qa`.`timestart`)'
SELECT CONCAT(u.id, '#', COALESCE(qa.attempt, 0)) AS uniqueid, (CASE WHEN qa.sumgrades = (SELECT MAX(qa2.sumgrades) FROM mdl_quiz_attempts qa2 WHERE qa2.quiz = qa.quiz AND qa2.userid = qa.userid) AND qa.timestart = (SELECT MIN(qa3.timestart) FROM mdl_quiz_attempts qa3 WHERE qa3.quiz = qa.quiz AND qa3.userid = qa.userid AND qa3.sumgrades = qa.sumgrades) THEN 1 ELSE 0 END) AS gradedattempt, qa.uniqueid AS attemptuniqueid, qa.id AS attempt, u.id AS userid, u.idnumber, u.firstname, u.lastname, u.picture, u.imagealt, u.email, qa.sumgrades, qa.timefinish, qa.timestart, qa.timefinish - qa.timestart AS duration , COALESCE((SELECT MAX(qqr.regraded) FROM mdl_quiz_question_regrade qqr WHERE qqr.attemptid = qa.uniqueid),-1) AS regraded FROM mdl_user u LEFT JOIN mdl_quiz_attempts qa ON qa.userid = u.id AND qa.quiz = ? WHERE qa.id IS NOT NULL AND qa.preview = 0 ORDER BY uniqueid ASC LIMIT 0, 30
[array (
0 => '20',
)]
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 1354 of /lib/tablelib.php: call to mysqli_native_moodle_database->get_records_sql()
line 323 of /mod/quiz/report/overview/overview_table.php: call to table_sql->query_db()
line 1375 of /lib/tablelib.php: call to quiz_report_overview_table->query_db()
line 391 of /mod/quiz/report/overview/report.php: call to table_sql->out()
line 90 of /mod/quiz/report.php: call to quiz_overview_report->display()