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

Entries in the assign_user_flags/mapping table are not being deleted.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.7.3, 2.8
    • Fix Version/s: 2.7.4, 2.8.2
    • Component/s: Assignment
    • Labels:
    • Testing Instructions:
      Hide
      Test 1 (BEFORE UPGRADE) on all supported DBs.
      1. Create a bunch of assignments.
      2. Make a few submissions as students.
      3. Mark these submissions as a teacher.
      4. Go to the assign table and make note of the ids of the assignments you created.
      5. Delete all the assignments except for one.
      6. Confirm that the assign_user_flags and assign_user_mapping tables do contain values for the assignments you deleted.
      7. Perform the upgrade.
      8. Confirm that the assign_user_flags and assign_user_mapping tables do not contain any values for the assignments you deleted, but do for the assignment you did not delete.
      Test 2
      1. Create an assignment.
      2. Make a few submissions as students.
      3. Mark these submissions as a teacher.
      4. Go to the assign table and make note of the id of the assignment you created.
      5. Delete the assignment.
      6. Confirm that the assign_user_flags and assign_user_mapping tables do not contain any values for the assignment you deleted.
      Test 3
      1. Create an assignment.
      2. Make a few submissions as students.
      3. Mark these submissions as a teacher.
      4. Visit 'Course administration' > 'Reset'.
      5. Under 'Assignments' check 'Delete all submissions' and then 'Reset course'.
      6. Confirm that the assign_user_flags do not contain any values for the assignment you deleted.
      Show
      Test 1 (BEFORE UPGRADE) on all supported DBs. Create a bunch of assignments. Make a few submissions as students. Mark these submissions as a teacher. Go to the assign table and make note of the ids of the assignments you created. Delete all the assignments except for one. Confirm that the assign_user_flags and assign_user_mapping tables do contain values for the assignments you deleted. Perform the upgrade. Confirm that the assign_user_flags and assign_user_mapping tables do not contain any values for the assignments you deleted, but do for the assignment you did not delete. Test 2 Create an assignment. Make a few submissions as students. Mark these submissions as a teacher. Go to the assign table and make note of the id of the assignment you created. Delete the assignment. Confirm that the assign_user_flags and assign_user_mapping tables do not contain any values for the assignment you deleted. Test 3 Create an assignment. Make a few submissions as students. Mark these submissions as a teacher. Visit 'Course administration' > 'Reset'. Under 'Assignments' check 'Delete all submissions' and then 'Reset course'. Confirm that the assign_user_flags do not contain any values for the assignment you deleted.
    • Affected Branches:
      MOODLE_27_STABLE, MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE, MOODLE_28_STABLE
    • Pull Master Branch:
      MDL-48549_master
    • Sprint:
      Team B Sprint 1

      Description

      1. Create an assignment.
      2. Make a few submissions as students.
      3. Mark these submissions as a teacher.
      4. Delete the assignment.
      5. Notice the assign_user_flags table still has entries for these deleted records.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                12/Jan/15