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

Error when user views course certificate: Multiple records found, only one record expected

XMLWordPrintable

    • MOODLE_311_STABLE
    • MOODLE_310_STABLE, MOODLE_311_STABLE

      A large installation has a small percentage (~1%) of Students who are reporting errors when clicking into the Course Certificate activity in a course; these same Students are able to view their certificates (by clicking the My certificates link in the Student's profile).

      Teachers are not receiving the error, and are (correctly) seeing the list of issued certificates when clicking on the Course Certificate activity in a course.

       

      Actual behavior

      The user clicks on the course certificate activity and gets an error message (example to follow): "Multiple records found, only one record expected."

       

      Expected behavior

      The user clicks on the course certificate activity and is shown the course certificate.

       

      Example error message

      Multiple records found, only one record expected.
      More information about this error
       
      Debug info: SELECT code FROM {tool_certificate_issues} WHERE userid = ? AND templateid = ? AND courseid = ? AND component = ?
      [array (
      0 => '3122',
      1 => '1',
      2 => '18',
      3 => 'mod_coursecertificate',
      )]
      Error code: multiplerecordsfound
       
      Stack trace:
      line 1681 of /lib/dml/moodle_database.php: dml_multiple_records_exception thrown
      line 1744 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      line 1725 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      line 1704 of /lib/dml/moodle_database.php: call to moodle_database->get_field_select()
      line 143 of /mod/coursecertificate/classes/output/view_page.php: call to moodle_database->get_field()
      line 37 of /mod/coursecertificate/view.php: call to mod_coursecertificate\output\view_page->__construct() 

            marina Marina Glancy
            matt.rice@moodle.com Matt Rice
            Mikel Martín Corrales Mikel Martín Corrales
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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