-
Bug
-
Resolution: Fixed
-
Minor
-
2.5.6
-
MOODLE_25_STABLE
-
MOODLE_26_STABLE, MOODLE_27_STABLE
-
wip_
MDL-46126_m28_passnulls -
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()