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

DB read error: questionnaire_response.username should be an integer

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              tonybutler Tony Butler
              tonybutler Tony Butler
              Mike Churchward Mike Churchward
              Mike Churchward
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                15/May/17