Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-17623 Summary of Violated Foreign Key Constraints from 700+ Moodles
  3. MDL-17628

Work out why the gradebook is creating so many foreign key violations

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 1.9.3
    • Gradebook
    • None
    • MOODLE_19_STABLE

      From Dan's data:

      Moodles Affected Average Percentage rows affected Table Key Total Violated Rows Total Rows
      325 25.6 grade_items_history courseid 16896 106381
      220 31.9 grade_grades_history usermodified 130823 1009017
      202 36.5 grade_grades usermodified 88713 450475
      168 12.7 grade_items_history categoryid 11137 94977

      Work out where these are coming from, and see if we can devise an automated clean-up on upgrade.

            Unassigned Unassigned
            timhunt Tim Hunt
            Votes:
            0 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.