Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 2.0.1
-
Fix Version/s: 2.0.2
-
Component/s: Database SQL/XMLDB, Installation
-
Labels:
-
Environment:MS-SQL 2008, Windows 2008, IIS 7.5
-
Database:Microsoft SQL
-
Difficulty:Moderate
-
Affected Branches:MOODLE_20_STABLE
-
Fixed Branches:MOODLE_20_STABLE
Description
When trying to upgrad from moodle 2.0 to moodle 2.0.1 I get the error below. I cannot continue with the upgrade it just sends me back to the Plugins Check Page.
DDL sql execution error
More information about this error
Debug info: The statement has been terminated.
ALTER TABLE mdl_scorm ALTER COLUMN forcecompleted SMALLINT NOT NULL
Stack trace:
line 397 of \lib\dml\moodle_database.php: ddl_change_structure_exception thrown
line 255 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
line 604 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
line 88 of \lib\ddl\database_manager.php: call to mssql_native_moodle_database->change_database_structure()
line 75 of \lib\ddl\database_manager.php: call to database_manager->execute_sql()
line 636 of \lib\ddl\database_manager.php: call to database_manager->execute_sql_arr()
line 648 of \lib\ddl\database_manager.php: call to database_manager->change_field_type()
line 491 of \mod\scorm\db\upgrade.php: call to database_manager->change_field_precision()
line 526 of \lib\upgradelib.php: call to xmldb_scorm_upgrade()
line 265 of \lib\upgradelib.php: call to upgrade_plugins_modules()
line 1426 of \lib\upgradelib.php: call to upgrade_plugins()
line 290 of \admin\index.php: call to upgrade_noncore()
Attachments
Issue Links
- has a non-specific relationship to
-
MDL-25792 Fix database discrepancies install-upgrade in the Scorm module
-
- Closed
-