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

Several foreign key fields defined in the install script have incorrect data types

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a bug
    • Minor
    • None
    • 2.0
    • Database SQL/XMLDB
    • None
    • MySQL 5.1.33
    • MySQL
    • MOODLE_20_STABLE
    • Easy

    Description

      When $foreign_keys=true in sql_generator.php the resulting SQL for installing Moodle fails in part (i.e. there are other problems beside this one) because several of the foreign key fields do not have the same datatype as the fields they reference.

      TABLE `question`, FIELD `category` - should be UNSIGNED
      TABLE `portfolio_tempdata`, FIELD `instance` - should be UNSIGNED
      TABLE `chat_messages`, FIELD `chatid` - should be UNSIGNED
      TABLE `chat_messages_current`, FIELD `chatid` - should be UNSIGNED
      TABLE `chat_users`, FIELD `chatid` - should be UNSIGNED and INT(10)
      TABLE `scorm_scoes_track`, FIELD `scormid` - should be UNSIGNED

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              evan.irving-pease Evan Irving-Pease
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

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