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

Moodle 2.0 to 2.0.1+ upgrade error on SCORM

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.0.2
    • Labels:
    • Environment:
      MS-SQL 2008, Windows 2008, IIS 7.5

      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

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              fweiss Fred Weiss
              Tester:
              David Mudrák (@mudrd8mz) David Mudrák (@mudrd8mz)
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                21/Feb/11