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

DB read error: questionnaire_response.username should be an integer

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.3
    • 2.7.8, 2.8.6, 2.9
    • Module: Questionnaire

      Attempting to access the 'Recent activity' report in a course containing a Questionnaire instance results in the 'Error reading from database' message.

      On investigation this turns out to be caused by a join in questionnaire_get_recent_mod_activity() on user.id = questionnaire_response.username, which have different types. As questionnaire_response.username is actually the Moodle user id it seems this should be an integer rather than a varchar.

            tonybutler Tony Butler
            tonybutler Tony Butler
            Mike Churchward Mike Churchward
            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.