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

Bad foreign key definition in table wiki_pages

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.0
    • 2.0
    • Wiki (2.x)
    • None
    • Any
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Easy

      It seems that the wiki_pages table has one foreign key pointing to wiki_subwiki, while the correct table name is wiki_subwikis. Also, ideally, the wiki_subwikis table should be defined in the XML structure before the wiki_pages one, so if creation of schema is performed with foreign keys enabled, it will work (i.e. dependencies must be satisfied by a correct order in install.xml files).

      To detect/reproduce this problem:

      1. Go to Admin -> Development -> XMLDB Editor
      2. Execute the "[ Check foreign keys] " facility.

      Ciao

        1. 22700_patch_latest.txt
          4 kB
          Jason Platts
        2. 22700_patch.txt
          2 kB
          Jason Platts

            skodak Petr Skoda
            stronk7 Eloy Lafuente (stronk7)
            Nobody Nobody (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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