Find Jobs
Hire Freelancers

Database error in Moodle

$30-250 AUD

已关闭
已发布超过 12 年前

$30-250 AUD

货到付款
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()
项目 ID: 1303354

关于此项目

4提案
远程项目
活跃12 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
4威客以平均价$140 AUD来参与此工作竞价
用户头像
I can fix this easily. I'm php expert. Please contact if interested.
$180 AUD 在0天之内
5.0 (135条评论)
8.8
8.8
用户头像
I can fix this error reading database problem in moodle script. Thanks, Suresh
$31 AUD 在1天之内
5.0 (1163条评论)
8.0
8.0
用户头像
Moodle expert. Please check my feedbacks :only Moodle! Thank you!
$150 AUD 在5天之内
5.0 (79条评论)
6.5
6.5
用户头像
Moodle/php experienced
$200 AUD 在2天之内
5.0 (2条评论)
2.8
2.8

关于客户

AUSTRALIA的国旗
Woodvale, Australia
5.0
1
付款方式已验证
会员自11月 21, 2011起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。