Affects Version/s: 2.4
Fix Version/s: None
Component/s: Module: Certificate
I have updated Moodle to Version 2012120300.02 and Certificate to version 2012121101.
The certificates that already exist in the system stopped working since the upgrade to 2.4. When I try to enter into the certificate, I have the following error:
Error reading the database
Debug info: Unknown column 'c.deleted' in 'where clause'
SELECT MAX(c.timecompleted) as timecompleted
FROM mdl_course_completions c
WHERE c.userid = ?
AND c.course = ?
AND c.deleted IS NULL
0 => '4',
1 => '2',
Error code: dmlreadexception
•line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
•line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
•line 1382 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
•line 1144 of /mod/certificate/lib.php: call to moodle_database->get_record_sql()
•line 97 of /mod/certificate/type/letter_embedded/certificate.php: call to certificate_get_date()
•line 91 of /mod/certificate/view.php: call to require()
If I create a new certificate, it seems to work well.If I try to copy from one already made before 2.4 it does not work either. I can edit the parameters of the certificate but when I try to display it the database error.
I can see the certificate and certificate_issues database in phpmyadmin.