Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-4722

Column ambiguously defined for report query in new plugin version (2013102300)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.5.2
    • Module: Certificate
    • 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

            markn Mark Nelson
            icefresh Mike
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.