Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-44658

Make userid,fieldid unique in user_info_data

    XMLWordPrintable

    Details

    • Database:
      MySQL
    • Testing Instructions:
      Hide

      Testing upgrade:

      • Insert duplicate records in mdl_user_info_data for the same userid/fieldid.
      • Run upgrade.
      • Verify that upgrade succeeds and no duplicate entries exists in mdl_user_info_data.
      • Create a user profile field via standard ui
      • Create a script that try to insert records with same userid,fieldid into mdl_user_info_data table and verify that this insertions will fail at database level
      Show
      Testing upgrade: Insert duplicate records in mdl_user_info_data for the same userid/fieldid. Run upgrade. Verify that upgrade succeeds and no duplicate entries exists in mdl_user_info_data. Create a user profile field via standard ui Create a script that try to insert records with same userid,fieldid into mdl_user_info_data table and verify that this insertions will fail at database level
    • Affected Branches:
      MOODLE_26_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE
    • Pull from Repository:
    • Pull Master Branch:

      Description

      Looking at the custom profile fields API and use cases, it seems that the key added by MDL-17201 should be unique.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              danielneis Daniel Neis Araujo
              Reporter:
              danielneis Daniel Neis Araujo
              Peer reviewer:
              Rex Lorenzo
              Integrator:
              Marina Glancy
              Tester:
              Marina Glancy
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Jake Dallimore, Jun Pataleta
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                12/May/14