-
Bug
-
Resolution: Fixed
-
Blocker
-
3.1.0-dev
-
None
-
None
-
MSSQL 2012 (11.0.2100.60)
Attempting to update from 3.0.12 to the latest 3.1.0 gives the following error on MSSQL (ODBC and Native):
Updating database to latest stable release
Database type :: mssqlnative
Previous version :: 3.1.0-dev
snip
Installed Schema: \phpbb\db\migration\data\v310\beta4; Time: 0.01 seconds
Installed Data: \phpbb\db\migration\data\v310\beta4; Time: 0.01 seconds
Installed Schema: \phpbb\db\migration\data\v310\contact_admin_acp_module; Time: 0.00 seconds
Installed Data: \phpbb\db\migration\data\v310\contact_admin_acp_module; Time: 0.08 seconds
Installed Schema: \phpbb\db\migration\data\v310\contact_admin_form; Time: 0.00 secondsSQL ERROR [ mssqlnative ]
SQLSTATE: 22018 code: 206 message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Operand type clash: int is incompatible with text [206]
SQL
INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('contact_admin_info_flags', 7)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 748
CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/mssqlnative.php
LINE: 139
CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/config/db_text.php
LINE: 111
CALL: phpbb\db\driver\mssqlnative->sql_query()FILE: [ROOT]/phpbb/db/migration/data/v310/contact_admin_form.php
LINE: 35
CALL: phpbb\config\db_text->set_array()FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v310\contact_admin_form->contact_admin_info()FILE: [ROOT]/phpbb/db/migrator.php
LINE: 457
CALL: call_user_func_array()FILE: [ROOT]/phpbb/db/migrator.php
LINE: 403
CALL: phpbb\db\migrator->run_step()FILE: [ROOT]/phpbb/db/migrator.php
LINE: 252
CALL: phpbb\db\migrator->process_data_step()FILE: [ROOT]/phpbb/db/migrator.php
LINE: 155
CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/install/database_update.php
LINE: 234
CALL: phpbb\db\migrator->update()