Moodle
  1. Moodle
  2. MDL-32595

Upgrade from 2.2 to 2.3dev has issues with default values

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.3
    • Fix Version/s: 2.3
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Testing Instructions:
      Hide

      Adding instructions here based on description.
      use - MySQL 5.0.26
      1) upgrade from 2.2 to the latest version of 2.3dev (Build: 20120419)
      2) As part of the upgrade \lib\db\upgradelib should not run into several issues.

      Show
      Adding instructions here based on description. use - MySQL 5.0.26 1) upgrade from 2.2 to the latest version of 2.3dev (Build: 20120419) 2) As part of the upgrade \lib\db\upgradelib should not run into several issues.
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w18_MDL-32595_m23_unsignedandlob
    • Rank:
      39517

      Description

      I have upgraded from 2.2 to the latest version of 2.3dev (Build: 20120419)

      As part of the upgrade \lib\db\upgradelib ran into several issues.

      In the function upgrade_mysql_fix_unsigned_columns when a column is unsigned it changes it to signed and tries to set a default value of ''. This failed when the column is of type int. (I removed the default value but ran into issues later as no default has been set)

      Also the function upgrade_mysql_fix_lob_columns is failing for a similar reason when trying to set a default value.

      I am running MySQL 5.0.26

        Activity

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: