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

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

    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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

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