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

DB read error: questionnaire_response.username should be an integer

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.7.8, 2.8.6, 2.9
    • Fix Version/s: 3.3
    • Component/s: Module: Questionnaire
    • Labels:

      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

              Assignee:
              tonybutler Tony Butler
              Reporter:
              tonybutler Tony Butler
              Peer reviewer:
              Mike Churchward
              Participants:
              Component watchers:
              Mike Churchward
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                15/May/17