[MDL-68680] Delete user with orphaned grade item - Moodle Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 3.5.12, 3.6.10, 3.7.6, 3.8.3, 3.9
Fix Version/s: 3.8.5, 3.9.2
Component/s: Gradebook
Labels:
- CatalystIT
- ci
- partner
- triaged

Affected Branches:
MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
Fixed Branches:
MOODLE_38_STABLE, MOODLE_39_STABLE
Pull from Repository:
https://github.com/tuanngocnguyen/moodle
Pull 3.9 Branch:
~~MDL-68680~~-MOODLE_39_STABLE
Pull 3.9 Diff URL:
https://github.com/moodle/moodle/compare/MOODLE_39_STABLE...tuanngocnguyen:MDL-68680-MOODLE_39_STABLE
Pull Master Branch:
~~MDL-68680~~-Master
Pull Master Diff URL:
https://github.com/moodle/moodle/compare/master...tuanngocnguyen:MDL-68680-Master
Testing Instructions:
Hide

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".
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".

Description

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

Provide a fix for deleting user with existing orphaned grade item

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

image-2020-09-03-15-27-41-254.png
148 kB
03/Sep/20 3:27 PM

Issue Links

has a non-specific relationship to

MDL-67720 Error thrown whist trying to delete users who have invalid course id in their grades

Open

has been marked as being related by

MDL-51694 Deleting user causes exception when a grade_grades row has no corresponding grade_items row

Closed

Activity

People

Assignee:: Nathan Nguyen

Reporter:: Nathan Nguyen

Peer reviewer:: Dmitrii Metelkin

Integrator:: Sara Arjona (@sarjona)

Tester:: Janelle Barcega

Participants:: CiBoT, Dmitrii Metelkin, Helen Foster, Janelle Barcega, Nathan Nguyen, Sara Arjona (@sarjona)

Component watchers:: Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie

Votes:: 4 Vote for this issue

Watchers:: 12 Start watching this issue

Dates

Created:: 12/May/20 1:11 PM

Updated:: 03/Sep/20 11:45 PM

Resolved:: 03/Sep/20 11:45 PM

Fix Release Date:: 14/Sep/20

Time Tracking

Estimated:

Remaining:

Logged: