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

Deleting one block/activity... must delete dependent information...

XMLWordPrintable

    • Any
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Moderate

      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:

      • ratings
      • comments
      • filters
      • role assignments and overrides
      • block instances and positions
      • logs
      • tags?
      • files?

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

      Ciao

        1. comments_block.patch
          0.5 kB
        2. course_deletion_remnants_raw_sql_diff.txt
          371 kB
        3. db_test_results.tar.gz
          2.08 MB
        4. html_block.patch
          0.9 kB
        5. start_to_end_state_db_(test1-6).txt
          139 kB
        6. start_to_end_state_db_with_student_activity.txt
          165 kB
        1.
        		 When deleting one block/activity, dependent comments and files must be deleted Sub-task Closed Dongsheng Cai
        2.
        		 When deleting any context, dependent ratings must be deleted Sub-task Closed Andrew Davis
        3.
        		 course_display table still has record of the course after the course is deleted. Sub-task Closed Aparup Banerjee
        4.
        		 enrol still has records referencing a course after the course is deleted Sub-task Closed Petr Skoda
        5.
        		 question_categories still has records after course deletion Sub-task Closed Tim Hunt
        6.
        		 user_preferences still has records about block instances data after a course delete or a course reset. Sub-task Closed Aparup Banerjee
        7.
        		 comments still has records from course after a course delete or course reset. Sub-task Closed Dongsheng Cai
        8.
        		 assignment_submissions still has records after a course reset. Sub-task Closed Aparup Banerjee
        9.
        		 glossary_alias still has records after course reset. Sub-task Closed Aparup Banerjee
        10.
        		 grade_items still has records after course reset Sub-task Closed Andrew Davis
        11.
        		 quiz_feedback still has records after course reset. Sub-task Closed Tim Hunt
        12.
        		 comments, tag and tag_instance still have records from wiki_page after a course reset. Sub-task Closed Aparup Banerjee
        13.
        		 wiki_locks still has record after a course reset. Sub-task Closed Aparup Banerjee
        14.
        		 Remove course completion data when deleting or reseting a course Sub-task Closed Sam Hemelryk

            nebgor Aparup Banerjee
            stronk7 Eloy Lafuente (stronk7)
            Nobody Nobody
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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