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

Invalid foreign keys in competencies

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1
    • Fix Version/s: 3.1
    • Component/s: Competencies
    • Labels:
    • Testing Instructions:
      Hide
      Test 1
      1. Perform a fresh install.
      2. Check that the following DB tables 'competency_coursecomp', 'competency_templatecomp' and 'competency_modulecomp' have a competencyid index.
      Test 2
      1. Perform an upgrade (on a site before this patch).
      2. Check that the following DB tables 'competency_coursecomp', 'competency_templatecomp' and 'competency_modulecomp' have a competencyid index.
      Test 3
      1. Visit 'Site administration' > 'Development' > 'XMLDB editor'.
      2. Perform all the checks listed at the top of the page.
      3. Ensure all are good.
      Show
      Test 1 Perform a fresh install. Check that the following DB tables 'competency_coursecomp', 'competency_templatecomp' and 'competency_modulecomp' have a competencyid index. Test 2 Perform an upgrade (on a site before this patch). Check that the following DB tables 'competency_coursecomp', 'competency_templatecomp' and 'competency_modulecomp' have a competencyid index. Test 3 Visit 'Site administration' > 'Development' > 'XMLDB editor'. Perform all the checks listed at the top of the page. Ensure all are good.
    • Affected Branches:
      MOODLE_31_STABLE
    • Fixed Branches:
      MOODLE_31_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-53919_master

      Description

      XMLDB is reporting these (real) errors:

      Foreign key competencyid on table competency_coursecomp points to a non-existent table competency_competency.
      Foreign key competencyid on table competency_templatecomp points to a non-existent table competency_competency.
      Foreign key competencyidkey on table competency_modulecomp points to a non-existent table competency_competency

      The table name is just competency.

        Attachments

          Activity

            People

            Assignee:
            markn Mark Nelson
            Reporter:
            damyon Damyon Wiese
            Peer reviewer:
            Frédéric Massart
            Integrator:
            Dan Poltawski
            Tester:
            Andrew Nicols
            Participants:
            Component watchers:
            Damyon Wiese, Jean-Philippe Gaudreau, Steve Massicotte, Serge Gauthier, Issam Taboubi, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              23/May/16