[MDL-22051] Deleting one block/activity... must delete dependent information... - Moodle Tracker

XML

Word

Printable

While trying backup I've detected some orphan records in DB here and there.

Each time one context (block, activity, course) is deleted... dependent information should be deleted too. This includes:

Please, revise all the block/activity/course deletions... we are leaving a lot of (mainly context based information) 100% orphaned.

Ciao

comments_block.patch
17/May/10 7:21 PM
0.5 kB
Dongsheng Cai
course_deletion_remnants_raw_sql_diff.txt
07/Sep/10 8:03 PM
371 kB
Aparup Banerjee
db_test_results.tar.gz
09/Sep/10 10:16 PM
2.08 MB
Aparup Banerjee
html_block.patch
17/May/10 7:18 PM
0.9 kB
Dongsheng Cai
start_to_end_state_db_(test1-6).txt
08/Sep/10 11:56 PM
139 kB
Aparup Banerjee
start_to_end_state_db_with_student_activity.txt
08/Sep/10 11:56 PM
165 kB
Aparup Banerjee

1.	When deleting one block/activity, dependent comments and files must be deleted	Closed	Dongsheng Cai
2.	When deleting any context, dependent ratings must be deleted	Closed	Andrew Davis
3.	course_display table still has record of the course after the course is deleted.	Closed	Aparup Banerjee
4.	enrol still has records referencing a course after the course is deleted	Closed	Petr Skoda
5.	question_categories still has records after course deletion	Closed	Tim Hunt
6.	user_preferences still has records about block instances data after a course delete or a course reset.	Closed	Aparup Banerjee
7.	comments still has records from course after a course delete or course reset.	Closed	Dongsheng Cai
8.	assignment_submissions still has records after a course reset.	Closed	Aparup Banerjee
9.	glossary_alias still has records after course reset.	Closed	Aparup Banerjee
10.	grade_items still has records after course reset	Closed	Andrew Davis
11.	quiz_feedback still has records after course reset.	Closed	Tim Hunt
12.	comments, tag and tag_instance still have records from wiki_page after a course reset.	Closed	Aparup Banerjee
13.	wiki_locks still has record after a course reset.	Closed	Aparup Banerjee
14.	Remove course completion data when deleting or reseting a course	Closed	Sam Hemelryk

Participants:: Aparup Banerjee, Dongsheng Cai, Eloy Lafuente (stronk7), Martin Dougiamas, Petr Skoda

Component watchers:: Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona), Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo