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

2.2.11 Upgrade to 2.5.6 fails at mdl_user password

    XMLWordPrintable

    Details

      Description

      Want to upgrade to 2.7 but my 2.1.10 was too old so upgraded to 2.2.11 without error. Ran the 2.7 latest upgrade and failed with mdl_user error so went back to 2.5.6 but it also fails.

      Upgrading Moodle database from version 2.2.11 (Build: 20130708) (2012123000.00) to 2.5.6+ (Build: 20140529) (2013051406.03)

      The process passes all of the checks then fails with DDL sql execution error.

      The mdl_user table looks clean and I don't see enough debug information to go any further.

      I am using manual, email, and mnet (to mahara) auth.
      Accounts are all policy approved
      No accounts are deleted
      No accounts are suspended
      mnethostid number matches auth
      idnumber fields are blank or NULL

      Debug info: Data truncated for column 'password' at row 16
      ALTER TABLE mdl_user MODIFY COLUMN password VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' after username
      Error code: ddlexecuteerror
      Stack trace:
      line 431 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      line 842 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
      line 77 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
      line 588 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
      line 600 of /lib/ddl/database_manager.php: call to database_manager->change_field_type()
      line 1595 of /lib/db/upgrade.php: call to database_manager->change_field_precision()
      line 1557 of /lib/upgradelib.php: call to xmldb_main_upgrade()
      line 345 of /admin/index.php: call to upgrade_core()

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                14/Jul/14