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

Old responses may have the string "Anonymous" in the questionnaire_response.username field

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.3
    • Fix Version/s: 3.3.1
    • Component/s: Module: Questionnaire
    • Labels:
      None

      Description

      For 3.3, the field username in the questionnaire_response field is being changed to an integer from a varchar, and renamed to userid to better reflect the reality of the data it represents. Generally this field always contains an integer value, but in some cases, very old data may contain the string "Anonymous". Correct the upgrade steps for this version to include migrating this string to the correct userid value from the questionnaire_attempts table.

        Attachments

          Activity

            People

            • Assignee:
              mchurch Mike Churchward
              Reporter:
              mchurch Mike Churchward
              Participants:
              Component watchers:
              Mike Churchward
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Jul/17