Closed

Database error in Moodle

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([url removed, login to view], '#', COALESCE([url removed, login to view], '0')) AS uniqueid, (CASE WHEN [url removed, login to view] = (SELECT MAX([url removed, login to view]) FROM mdl_quiz_attempts qa2 WHERE [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = [url removed, login to view]) AND [url removed, login to view] = (SELECT MIN([url removed, login to view]) FROM mdl_quiz_attempts qa3 WHERE [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = [url removed, login to view]) THEN 1 ELSE 0 END) AS gradedattempt, [url removed, login to view] AS attemptuniqueid, [url removed, login to view] AS attempt, [url removed, login to view] AS userid, [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] - [url removed, login to view] AS duration , COALESCE((SELECT MAX([url removed, login to view]) FROM mdl_quiz_question_regrade qqr WHERE [url removed, login to view] = [url removed, login to view]),-1) AS regraded FROM mdl_user u LEFT JOIN mdl_quiz_attempts qa ON [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = ? WHERE [url removed, login to view] IS NOT NULL AND [url removed, login to view] = 0 ORDER BY uniqueid ASC LIMIT 0, 30

[array (

0 => '4',

)]

Stack trace:

• line 391 of \lib\dml\[url removed, login to view]: dml_read_exception thrown

• line 769 of \lib\dml\[url removed, login to view]: call to moodle_database->query_end()

• line 1354 of \lib\[url removed, login to view]: call to mysqli_native_moodle_database->get_records_sql()

• line 321 of \mod\quiz\report\overview\[url removed, login to view]: call to table_sql->query_db()

• line 1375 of \lib\[url removed, login to view]: call to quiz_report_overview_table->query_db()

• line 391 of \mod\quiz\report\overview\[url removed, login to view]: call to table_sql->out()

• line 90 of \mod\quiz\[url removed, login to view]: call to quiz_overview_report->display()

Skills: PHP

See more: moodle error reading database, error reading database moodle, moodle report database error, moodle database error, error reading database moodle attempts, moodle error reading database quiz, error database moodle, database error moodle, bigint unsigned value range `moodle``qa``timefinish` `moodle``qa``timestart`, moodle value range timefinish, this error, min range, attempt moodle error, moodle bigint unsigned value range, error 0, php moodle, moodle], grading, trace stack, max case, call method, userid, access array, trace email, Moodle Quiz

About the Employer:
( 0 reviews ) Australia

Project ID: #1303354

5 freelancers are bidding on average $124 for this job

soner

I can fix this easily. I'm php expert. Please contact if interested.

$180 AUD in 0 days
(120 Reviews)
7.8
sureshdevi

I can fix this error reading database problem in moodle script. Thanks, Suresh

$31 AUD in 1 day
(500 Reviews)
7.2
Mindon

check the PMB please,thanks

$60 AUD in 1 day
(50 Reviews)
5.9
dman2

Moodle expert. Please check my feedbacks :only Moodle! Thank you!

$150 AUD in 5 days
(19 Reviews)
5.4
techyash

Moodle/php experienced

$200 AUD in 2 days
(2 Reviews)
2.8