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

Delete user with orphaned grade item

XMLWordPrintable

    • MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
    • MOODLE_38_STABLE, MOODLE_39_STABLE
    • MDL-68680-Master
    • Hide
      1. Create a user (s1)
      2. Create a course
      3. Create a quiz with a a true/false question
      4. Enrol the user s1 as student into that course
      5. Login as the student (s1)
      6. Attempt the quiz
      7. Submit the quiz
      8. Access to the gradebook
      9. Make sure the grade is there
      10. Break the DB running the following SQL query:  

        DELETE FROM mdl_grade_items WHERE courseid = {the created courseid} AND itemmodule = 'quiz' 

      11. Login as admin
      12. Delete the user s1
      13. Confirm the deletion finishes without any error
        • Note: if debugging is enabled, the following message will be displayed: "Missing grade item id xxx".

       

      Show
      Create a user (s1) Create a course Create a quiz with a a true/false question Enrol the user s1 as student into that course Login as the student (s1) Attempt the quiz Submit the quiz Access to the gradebook Make sure the grade is there Break the DB running the following SQL query:  DELETE FROM mdl_grade_items WHERE courseid = {the created courseid} AND itemmodule = 'quiz'  Login as admin Delete the user s1 Confirm the deletion finishes without any error Note: if debugging is enabled, the following message will be displayed: "Missing grade item id xxx".  

      Related tracker https://tracker.moodle.org/browse/MDL-51694

      Provide a fix for deleting user with existing orphaned grade item

       

        1. image-2020-09-03-15-27-41-254.png
          148 kB
          Janelle Barcega

            Nguyen Nathan Nguyen
            Nguyen Nathan Nguyen
            Dmitrii Metelkin Dmitrii Metelkin
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Janelle Barcega Janelle Barcega
            Votes:
            4 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours
                3h

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