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

quiz attempts made by a deleted user cannot be deleted

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.3.1
    • Fix Version/s: STABLE backlog
    • Component/s: Quiz
    • Labels:
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_23_STABLE
    • Pull from Repository:
    • Pull Master Branch:

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              stencel Przemyslaw Stencel
              Integrator:
              Sam Hemelryk Sam Hemelryk
              Participants:
              Component watchers:
              Tim Hunt, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              15 Vote for this issue
              Watchers:
              13 Start watching this issue

                Dates

                Created:
                Updated: