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

View Certificates: ORA-00918: column ambiguously defined

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 2.4
    • Module: Certificate
    • None

      More at https://moodle.org/mod/forum/discuss.php?d=217767#p948224:

      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 ci.certificateid = :o_certificateid
      ORDER BY firstname || ' ' || lastname )
      WHERE rownum <= :o_oracle_num_rows
      [array (
      'o_certificateid' => '142',
      'o_oracle_num_rows' => 30,
      )]
      Error code: dmlreadexception
       
      Stack trace:
          line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
          line 274 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
          line 1101 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
          line 729 of /mod/certificate/lib.php: call to oci_native_moodle_database->get_records_sql()
          line 92 of /mod/certificate/report.php: call to certificate_get_issues()

            markn Mark Nelson
            matteo Matteo Scaramuccia
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

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