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

quiz attempts made by a deleted user cannot be deleted

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 2.3.1
    • Quiz
    • MOODLE_23_STABLE
    • Hide

      1. Using a user account that you don't mind losing, make some quiz attempts.

      2. Look in the database, and not the associated data in the quiz_attempts, quiz_grades and quiz_overrides tables. Also, in the question engine tables question_usages, question_attempt*

      3. Delete the user and make sure all that data is deleted, but that data belonging to other users is not deleted.

      Show
      1. Using a user account that you don't mind losing, make some quiz attempts. 2. Look in the database, and not the associated data in the quiz_attempts, quiz_grades and quiz_overrides tables. Also, in the question engine tables question_usages, question_attempt* 3. Delete the user and make sure all that data is deleted, but that data belonging to other users is not deleted.

      Here's the scenario:
      1/ a student attempts a quiz
      2/ the student's account is deleted from the system by the admin
      3/ the teacher wants to modify the quiz (add or delete questions)
      4/ in order to "unlock" the quiz, the teacher deletes all attempts that have been made (including the attempt made by the deleted student)
      5/ no attempts are shown in the quiz report, but the quiz remains "locked" and thus cannot be modified; in fact, even though no attempts are shown, on the quiz overview page there is still info saying that there is an attempt

      As a result, the teacher is unable to unlock the quiz and modify it (add or remove questions).

      The workaround is to enter the database, "un-delete" the student's account, re-enrol him in the course, delete his attempt and then delete the account again. However, this requires admin intervention and tampering with the database

            Unassigned Unassigned
            stencel Przemyslaw Stencel
            Sam Hemelryk Sam Hemelryk
            Votes:
            15 Vote for this issue
            Watchers:
            14 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.