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

Error when resetting course with certificate

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 3.5.6
    • Module: Certificate
    • None
    • 3.1 (Build: 2016052300)
    • MOODLE_35_STABLE

      When resetting a course with a certificate in it and changing the course start date, you get the following error:

      Debug info: Unknown column 'timeopen' in 'where clause'
      UPDATE mdl_certificate
      SET timeopen = timeopen + ?
      WHERE course=? AND timeopen<>0
      [array (
      0 => 31536000,
      1 => 1320,
      )]
      Error code: dmlwriteexception×Stack trace:line 489 of /lib/dml/moodle_database.php: dml_write_exception thrownline 1139 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()line 5227 of /lib/moodlelib.php: call to mysqli_native_moodle_database->execute()line 133 of /mod/certificate/lib.php: call to shift_course_mod_dates()line 5473 of /lib/moodlelib.php: call to certificate_reset_userdata()line 75 of /course/reset.php: call to reset_course_userdata() 

            Unassigned Unassigned
            heather.williams Heather Williams
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

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