Antonio Durán wrote: Hola, gracias por el reporte de error.
He comprobado el código y parece que han cambiado el nombre de una columna en la tabla, por lo que es necesario modificar el módulo de Joomdle para que funcione.
Si quieres arreglarlo, puedes cambiar la consulta que hay en la función my_certificates en moodle/auth/joomdle.auth.php por esta otra:
Code:
$certs = $DB->get_records_sql("SELECT c.name, c.id, ci.timecreated as certdate
FROM {$CFG->prefix}certificate c
LEFT JOIN {$CFG->prefix}certificate_issues ci ON c.id = ci.certificateid
WHERE ci.userid = $user_id
AND c.course in ($ids_str)
ORDER BY ci.timecreated DESC");
I have the same problem but I can't find this line in auth.php within moodle/auth/joomdle - am I looking in the wrong place?
If I replace the $certs query which was this:
Code:
$certs = array ();
foreach ($cursos as $curso)
{
$conditions = array ('id' => $curso->id);
$course = $DB->get_record ('course', $conditions);
if (! $certificates = get_all_instances_in_course("certificate", $course))
continue;
foreach ($certificates as $certificate)
{
// Hide not received certificates
$conditions = array ('certificateid' => $certificate->id, 'userid' => $user->id);
$certrecord = $DB->get_record ('certificate_issues', $conditions);
if(!$certrecord)
continue;
$cert['name'] = $certificate->name;
$cert['id'] = $certificate->coursemodule;
$certs[] = $cert;
}
}
return $certs;
I get the following debug message:
XML-RPC Error (95042507): Error reading from database | DEBUG INFO: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.course in () ORDER BY ci.timecreated DESC' at line 5 SELECT c.name, c.id, ci.timecreated as certdate FROM hcmi_certificate c LEFT JOIN hcmi_certificate_issues ci ON c.id = ci.certificateid WHERE ci.userid = AND c.course in () ORDER BY ci.timecreated DESC [array ( )] | ERRORCODE: dmlreadexception
Ruth
