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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.7.4, 2.8.2
    • 2.7.3, 2.8
    • 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

      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.

            markn Mark Nelson
            markn Mark Nelson
            Dan Poltawski Dan Poltawski
            David Monllaó David Monllaó
            John Okely John Okely
            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.