Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-22448

Workshop log functions produces errors when a module has been updated recently under PostgreSQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 1.9.9
    • 1.9.6, 1.9.7, 1.9.8
    • Workshop
    • None
    • Moodle, debugging on and student account
    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

      The certificate module was updated recently and then a student logged in and got these errors in the Recent Activities Block related to the workshop logs.

      SELECT l.time, l.url, u.firstname, u.lastname, a.workshopid, a.userid, e.name FROM mdl_log l, mdl_workshop e, mdl_workshop_submissions s, mdl_workshop_assessments a, mdl_user u WHERE l.time > 1273549600 AND l.time < 1273720637 AND l.course = 2613 AND l.module = 'workshop' AND l.action = 'agree' AND a.id = l.info AND s.id = a.submissionid AND a.userid = 62 AND u.id = s.userid AND e.id = a.workshopid;
      ERROR: operator does not exist: bigint = character varying at character 306
      HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
      LINE 1: ...dule = 'workshop' AND l.action = 'agree' AND a.id = l.info A...

      Works fine with patch applied to make the where clause "a.id = l.info" cast correctly in PostgreSQL - "a.id = CAST(l.info AS INT)"

            mudrd8mz David Mudrák (@mudrd8mz)
            tlock Tim Lock
            Nobody Nobody (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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