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

Checklist: "could not determine data type of parameter $1" error with PostgreSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.5.6, 2.6.3, 2.7
    • Fix Version/s: None
    • Component/s: Package: Checklist
    • Labels:

      Description

      This error seems to relate to an issue PostgreSQL has with prepared statements where there's a parameter with an unspecified data type in a "SELECT ? AS whatever" statement, and is triggered (under the right conditions - see below) when hiding or showing a checklist item in the 'Edit checklist' tab. As far as I can tell only PostgreSQL is affected, although I haven't tested this.

      The error only occurs under a very specific set of conditions which seem to include linking the checklist to other course modules which themselves have completion tracking enabled, and also restricting the checklist access to members of a specific grouping. I really struggled to reproduce this in my dev environment, to the point where just I ended up restoring a backup of the affected course from our production instance. I can attach this backup if necessary to reproduce.

      The fix simply removes the troublesome first parameter, which as it turns out doesn't seem to be needed anyway.

        Attachments

          Activity

            People

            • Assignee:
              tonybutler Tony Butler
              Reporter:
              tonybutler Tony Butler
              Peer reviewer:
              Davo Smith
              Participants:
              Component watchers:
              Davo Smith
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: