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

Make userid,fieldid unique in user_info_data

XMLWordPrintable

    • MySQL
    • MOODLE_26_STABLE
    • MOODLE_27_STABLE
    • 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

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

            danielneis Daniel Neis Araujo
            danielneis Daniel Neis Araujo
            Rex Lorenzo Rex Lorenzo
            Marina Glancy Marina Glancy
            Marina Glancy Marina Glancy
            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.