Find Jobs
Hire Freelancers

Database error in Moodle

$30-250 AUD

Closed
Posted over 12 years ago

$30-250 AUD

Paid on delivery
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()
Project ID: 1303354

About the project

4 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $140 AUD for this job
User Avatar
I can fix this easily. I'm php expert. Please contact if interested.
$180 AUD in 0 day
5.0 (135 reviews)
8.8
8.8
User Avatar
I can fix this error reading database problem in moodle script. Thanks, Suresh
$31 AUD in 1 day
5.0 (1163 reviews)
8.0
8.0
User Avatar
Moodle expert. Please check my feedbacks :only Moodle! Thank you!
$150 AUD in 5 days
5.0 (79 reviews)
6.5
6.5
User Avatar
Moodle/php experienced
$200 AUD in 2 days
5.0 (2 reviews)
2.8
2.8

About the client

Flag of AUSTRALIA
Woodvale, Australia
5.0
1
Payment method verified
Member since Nov 21, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.