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

After Moodle upgrade to 2.4, certificates stop working

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.4
    • Fix Version/s: None
    • Component/s: Module: Certificate
    • Labels:
      None
    • Affected Branches:
      MOODLE_24_STABLE

      Description

      I have updated Moodle to Version 2012120300.02 and Certificate to version 2012121101.

      The certificates that already exist in the system stopped working since the upgrade to 2.4. When I try to enter into the certificate, I have the following error:

      Error reading the database

      Debug info: Unknown column 'c.deleted' in 'where clause'
      SELECT MAX(c.timecompleted) as timecompleted
      FROM mdl_course_completions c
      WHERE c.userid = ?
      AND c.course = ?
      AND c.deleted IS NULL
      [array (
      0 => '4',
      1 => '2',
      )]
      Error code: dmlreadexception
      Stack trace:
      •line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
      •line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      •line 1382 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      •line 1144 of /mod/certificate/lib.php: call to moodle_database->get_record_sql()
      •line 97 of /mod/certificate/type/letter_embedded/certificate.php: call to certificate_get_date()
      •line 91 of /mod/certificate/view.php: call to require()

      If I create a new certificate, it seems to work well.If I try to copy from one already made before 2.4 it does not work either. I can edit the parameters of the certificate but when I try to display it the database error.

      I can see the certificate and certificate_issues database in phpmyadmin.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markn Mark Nelson
              Reporter:
              euittien Erik Uittien
              Participants:
              Component watchers:
              Mark Nelson
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: