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

Summary of Violated Foreign Key Constraints from 700+ Moodles

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Environment:
      MySQL, 1.9.3
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      I have run the report testing for violated foreign key constraints on all our 730+ production moodles.

      I've collated all the violated constrains using (http://cvs.moodle.org/contrib/tools/devtools/xmldb_refintegreport.php) and then aggregated all the data from all the moodles and produced a summary report which is attached.

      As you can see the grade-book is the major offender here.

      This data is from quite a wide cross section of sites, from heavy users upgraded from external hosts on < Moodle 1.4, to brand new installs on 1.9.3. (All are now on 1.9.3).

      230ish didn't have any violated constraints at all

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  1 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated: