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

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

    XMLWordPrintable

Details

    • Any
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Moderate

    Description

      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

      Attachments

        1. comments_block.patch
          0.5 kB
          Dongsheng Cai
        2. course_deletion_remnants_raw_sql_diff.txt
          371 kB
          Aparup Banerjee
        3. db_test_results.tar.gz
          2.08 MB
          Aparup Banerjee
        4. html_block.patch
          0.9 kB
          Dongsheng Cai
        5. start_to_end_state_db_(test1-6).txt
          139 kB
          Aparup Banerjee
        6. start_to_end_state_db_with_student_activity.txt
          165 kB
          Aparup Banerjee

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Clockify

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