-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
3.1.4
-
None
-
2016121300
-
MOODLE_31_STABLE
I am currently upgrading from Moodle 2.7.18 to 3.1.4 and am attempting to upgrade mod_hsuforum from version 2.4.0 to 3.1.3. I get the following error:
{{-->mod_hsuforum
Default exception handler: DDL sql execution error Debug: Unknown column 'displaywordcount' in 'mdl_hsuforum'
ALTER TABLE mdl_hsuforum ADD showsubstantive TINYINT(1) NOT NULL DEFAULT 0 AFTER displaywordcount
Error code: ddlexecuteerror
- line 485 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 919 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
- line 545 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
- line 106 of /mod/hsuforum/db/upgrade.php: call to database_manager->add_field()
- line 726 of /lib/upgradelib.php: call to xmldb_hsuforum_upgrade()
- line 432 of /lib/upgradelib.php: call to upgrade_plugins_modules()
- line 1742 of /lib/upgradelib.php: call to upgrade_plugins()
- line 181 of /admin/cli/upgrade.php: call to upgrade_noncore()
!!! DDL sql execution error !!!
!! Unknown column 'displaywordcount' in 'mdl_hsuforum'
ALTER TABLE mdl_hsuforum ADD showsubstantive TINYINT(1) NOT NULL DEFAULT 0 AFTER displaywordcount
Error code: ddlexecuteerror !!
!! Stack trace: * line 485 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 919 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
- line 545 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
- line 106 of /mod/hsuforum/db/upgrade.php: call to database_manager->add_field()
- line 726 of /lib/upgradelib.php: call to xmldb_hsuforum_upgrade()
- line 432 of /lib/upgradelib.php: call to upgrade_plugins_modules()
- line 1742 of /lib/upgradelib.php: call to upgrade_plugins()
- line 181 of /admin/cli/upgrade.php: call to upgrade_noncore()
!!
}}
The upgrade gets as far as version 2014051203 before throwing this error.
When was the 'displaywordcount' field introduced? It is not in the "install.xml" for version 2012112901, but there is no line in upgrade.php for 2016121300 that creates it either