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

2.2.11 Upgrade to 2.5.6 fails at mdl_user password


      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()

            skodak Petr Skoda (Inactive)
            ericrross Eric Ross
            Dan Poltawski Dan Poltawski
            Sam Hemelryk Sam Hemelryk
            Andrew Lyons Andrew Lyons
            1 Vote for this issue
            5 Start watching this issue


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