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

Missing Unique Key/Index in groupings_groups (groupingid, groupid)

    XMLWordPrintable

    Details

    • Database:
      Any
    • Testing Instructions:
      Hide

      Set up

      1. Create a course.
      2. Create some groups and create some groupings.
      3. Add groups to groupings.
      4. Back up the course.

      Restore into this course

      1. Restore the course making sure to "Merge the backup course into this course" (Destination section of restore).
      2. Complete the restore and open up your database.
      3. Check the groupings_groups table and make sure that there are no entries with the same combination of grouping id and grouid.

      Restore as a new course

      1. Restore the course making sure to "Restore as a new course" (Destination section of restore).
      2. Complete the restore and open up your database.
      3. Check the groupings_groups table and make sure that there are no entries with the same combination of grouping id and grouid.
      Show
      Set up Create a course. Create some groups and create some groupings. Add groups to groupings. Back up the course. Restore into this course Restore the course making sure to "Merge the backup course into this course" (Destination section of restore). Complete the restore and open up your database. Check the groupings_groups table and make sure that there are no entries with the same combination of grouping id and grouid . Restore as a new course Restore the course making sure to "Restore as a new course" (Destination section of restore). Complete the restore and open up your database. Check the groupings_groups table and make sure that there are no entries with the same combination of grouping id and grouid .
    • Affected Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE, MOODLE_24_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      wip-MDL-30797-master

      Description

      There shouldn't be more than one row in groupings_groups with specific groupingid, groupid

        Attachments

          Activity

            People

            Assignee:
            abgreeve Adrian Greeve
            Reporter:
            asafo Asaf Ohaion
            Peer reviewer:
            Frédéric Massart
            Integrator:
            Dan Poltawski
            Tester:
            Andrew Davis
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              11/Mar/13