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, 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