Moodle has a database error and trying to access reports from Quiz:-
Showing graded and ungraded attempts for each user. The one attempt for each user that is graded is highlighted. The grading method for this quiz is Highest grade.
Error reading from database
More information about this error
Debug info: BIGINT UNSIGNED value is out of range in '(`moodle`.`qa`.`timefinish` - `moodle`.`qa`.`timestart`)'
SELECT CONCAT([login to view URL], '#', COALESCE([login to view URL], '0')) AS uniqueid, (CASE WHEN [login to view URL] = (SELECT MAX([login to view URL]) FROM mdl_quiz_attempts qa2 WHERE [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL]) AND [login to view URL] = (SELECT MIN([login to view URL]) FROM mdl_quiz_attempts qa3 WHERE [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL]) THEN 1 ELSE 0 END) AS gradedattempt, [login to view URL] AS attemptuniqueid, [login to view URL] AS attempt, [login to view URL] AS userid, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] - [login to view URL] AS duration , COALESCE((SELECT MAX([login to view URL]) FROM mdl_quiz_question_regrade qqr WHERE [login to view URL] = [login to view URL]),-1) AS regraded FROM mdl_user u LEFT JOIN mdl_quiz_attempts qa ON [login to view URL] = [login to view URL] AND [login to view URL] = ? WHERE [login to view URL] IS NOT NULL AND [login to view URL] = 0 ORDER BY uniqueid ASC LIMIT 0, 30
[array (
0 => '4',
)]
Stack trace:
• line 391 of \lib\dml\[login to view URL]: dml_read_exception thrown
• line 769 of \lib\dml\[login to view URL]: call to moodle_database->query_end()
• line 1354 of \lib\[login to view URL]: call to mysqli_native_moodle_database->get_records_sql()
• line 321 of \mod\quiz\report\overview\[login to view URL]: call to table_sql->query_db()
• line 1375 of \lib\[login to view URL]: call to quiz_report_overview_table->query_db()
• line 391 of \mod\quiz\report\overview\[login to view URL]: call to table_sql->out()
• line 90 of \mod\quiz\[login to view URL]: call to quiz_overview_report->display()