-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
2.5.2
-
None
-
2013102300
-
MOODLE_25_STABLE
After upgrading to the latest version of mod_certificate, we experience the following Oracle database error when viewing the report:
Error reading from database
More information about this error
Debug info: ORA-00918: column ambiguously defined
SELECT *
FROM (SELECT u.*, ci.code, ci.timecreated
FROM m_user u
INNER JOIN m_certificate_issues ci
ON u.id = ci.userid
WHERE u.deleted = 0
AND ci.certificateid = :o_certificateid
AND NOT u.id IN (:o_cert8,:o_cert9,:o_cert10,:o_cert11,:o_cert12,:o_cert13,:o_cert14)
ORDER BY MOODLELIB.UNDO_MEGA_HACK(MOODLELIB.TRICONCAT(firstname, 'OCISP', lastname)) )
WHERE rownum <= :o_oracle_num_rows
[array (
'o_certificateid' => '395',
'o_cert8' => 511,
'o_cert9' => 430,
'o_cert10' => 282,
'o_cert11' => 427,
'o_cert12' => 22,
'o_cert13' => 6,
'o_cert14' => 81,
'o_oracle_num_rows' => 30,
)]
Error code: dmlreadexception
Stack trace:
line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 280 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
line 1131 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
line 744 of /mod/certificate/lib.php: call to oci_native_moodle_database->get_records_sql()
line 102 of /mod/certificate/report.php: call to certificate_get_issues()
This is caused by the column "timecreated" which exists in the m_user table and in the m_certificate_issues table
- is duplicated by
-
CONTRIB-4067 View Certificates: ORA-00918: column ambiguously defined
-
- Closed
-