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

Resetting dashboards does not actually delete block instances on oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Waiting for peer review
    • Minor
    • Resolution: Unresolved
    • 3.10.6, 3.11.1, 4.0
    • None
    • Dashboard (My home)

    Description

      Resetting dashboards does not fully on oracle - it deletes the records in my_pages table but does not delete block instances, leaving them orphaned

      We found it in Workplace by writing proper unittest for tenant dashboard reset and then they failed. We realised that the tests for resetting user dashboard in LMS are not testing functionality (only events), so they did not detect this problem.

      There is no method to cast int to char in our DML, the code uses $DB->sql_concat("''", 'p.id') that apparently does not work in oracle

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              marina Marina Glancy
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h