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
            Amaia Anabitarte, Bas Brands, Carlos Escobedo, Laurent David, Raquel Ortega, Sabina Abellan, Sara Arjona (@sarjona), Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo, Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              24/Nov/10