Affects Version/s: 2.2.6
Fix Version/s: 2.2.8
Pull from Repository:
I am building an upgrade path from our legacy moodle 1.9 instances to moodle 2.4. My upgrade system works well when I upgrade from 1.9 to 2.2 using the CLI systems, but I get a problem that Google has no answer for when I try to then leap-frog from 2.2 to 2.4.
Here is the error:
Debug info: Out of range value for column 'sortorder' at row 106
ALTER TABLE `mdl_course` MODIFY COLUMN `sortorder` bigint(10) signed NOT NULL DEFAULT '0'
Error code: ddlexecuteerror
line 432 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 860 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 139 of /lib/db/upgradelib.php: call to mysqli_native_moodle_database->change_database_structure()
line 232 of /lib/db/upgrade.php: call to upgrade_mysql_fix_unsigned_columns()
line 1493 of /lib/upgradelib.php: call to xmldb_main_upgrade()
line 284 of /admin/index.php: call to upgrade_core()
I don't often post, so please give me feedback as to more information that I can give on the subject. I don't want to brain-dump everything about the instance for fear of getting tl;dr from everyone who could help me, so I want to know what's relevant.
These are the exact packages I am using.