Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3825

SQL Incorrect Syntax

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.1
    • Fix Version/s: 2.3.1
    • Component/s: Course format: Topcoll
    • Labels:
      None
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE

      Description

      When trying to install format, the following appears and cannot continue until I remove the files from server:

      Debug info: SQLState: 42000<br>
      Error Code: 156<br>
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'IDENTITY'.<br>

      ALTER TABLE mdl_format_topcoll_settings ALTER COLUMN id BIGINT NOT NULL IDENTITY(1,1)
      Error code: ddlexecuteerror
      Stack trace:
      line 413 of \lib\dml\moodle_database.php: ddl_change_structure_exception thrown
      line 258 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
      line 679 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
      line 88 of \lib\ddl\database_manager.php: call to sqlsrv_native_moodle_database->change_database_structure()
      line 77 of \lib\ddl\database_manager.php: call to database_manager->execute_sql()
      line 575 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 66 of \course\format\topcoll\db\upgrade.php: call to database_manager->change_field_unsigned()
      line 471 of \lib\upgradelib.php: call to xmldb_format_topcoll_upgrade()
      line 1524 of \lib\upgradelib.php: call to upgrade_plugins()
      line 329 of \admin\index.php: call to upgrade_noncore()

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                9/Jul/12