Find Jobs
Hire Freelancers

Database error in Moodle

$30-250 AUD

Cerrado
Publicado hace más de 12 años

$30-250 AUD

Pagado a la entrega
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 del proyecto: 1303354

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
4 freelancers están ofertando un promedio de $140 AUD por este trabajo
Avatar del usuario
I can fix this easily. I'm php expert. Please contact if interested.
$180 AUD en 0 día
5,0 (135 comentarios)
8,8
8,8
Avatar del usuario
I can fix this error reading database problem in moodle script. Thanks, Suresh
$31 AUD en 1 día
5,0 (1163 comentarios)
8,0
8,0
Avatar del usuario
Moodle expert. Please check my feedbacks :only Moodle! Thank you!
$150 AUD en 5 días
5,0 (79 comentarios)
6,5
6,5
Avatar del usuario
Moodle/php experienced
$200 AUD en 2 días
5,0 (2 comentarios)
2,8
2,8

Sobre este cliente

Bandera de AUSTRALIA
Woodvale, Australia
5,0
1
Forma de pago verificada
Miembro desde nov 21, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.