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

typo in quiz table def

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1, 2.2
    • Fix Version/s: 2.1.7, 2.2.4, 2.3.1
    • Component/s: Quiz
    • Labels:
      None
    • Testing Instructions:
      Hide

      1. Go to admin -> development -> XMLDB
      2. Run the check foreign keys script.
      3. Verify the results relating to quiz_attempts -> question_usages makes sense.

      Show
      1. Go to admin -> development -> XMLDB 2. Run the check foreign keys script. 3. Verify the results relating to quiz_attempts -> question_usages makes sense.
    • Affected Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
    • Pull from Repository:
    • Pull Master Branch:
    • Pull Master Diff URL:

      Description

      Checking foreign keys violations I realized a line in mod/quiz/db/install.xml seems wrong :
      <KEY NAME="uniqueid" TYPE="foreign-unique" FIELDS="uniqueid" REFTABLE="question_attempts" REFFIELDS="id" PREVIOUS="userid"/>
      to me it seems that REFFIELDS should be "questionusageid" and not "id", am I wrong ?
      Of course it doesn't really matter and this will not cause any harm
      But what surprise me is that I am surely not the first Moodle user to look at foreign keys violations since Moodle 2.1 is out ???

        Attachments

          Activity

            People

            Assignee:
            timhunt Tim Hunt
            Reporter:
            jmvedrine Jean-Michel Vedrine
            Integrator:
            Dan Poltawski
            Tester:
            Aparup Banerjee
            Participants:
            Component watchers:
            Tim Hunt, Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              9/Jul/12