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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.7.3, 2.8
    • 2.7.4, 2.8.2
    • Assignment
    • MOODLE_27_STABLE, MOODLE_28_STABLE
    • MOODLE_27_STABLE, MOODLE_28_STABLE
    • MDL-48549_master
    • 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.
    • 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

            markn Mark Nelson
            markn Mark Nelson
            Dan Poltawski Dan Poltawski
            David Monllaó David Monllaó
            John Okely John Okely
            Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              12/Jan/15