-
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 :: mssql_odbc
Previous version :: 3.1.0-b4
Installed Data: \phpbb\db\migration\data\v310\contact_admin_form; Time: 0.22 seconds
Installed Schema: \phpbb\db\migration\data\v310\passwords_convert_p1; Time: 0.03 seconds
SQL ERROR [ mssql_odbc ][Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'phpbb_users.user_password' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. [37000]
SQL
SELECT TOP 1000 user_password, user_id FROM phpbb_users WHERE user_pass_convert = 1 GROUP BY user_id ORDER BY user_id
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/mssql_odbc.php
LINE: 168
CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/db/driver/mssql_odbc.php
LINE: 220
CALL: phpbb\db\driver\mssql_odbc->sql_query()FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 165
CALL: phpbb\db\driver\mssql_odbc->_sql_query_limit()FILE: [ROOT]/phpbb/db/migration/data/v310/passwords_convert_p1.php
LINE: 47
CALL: phpbb\db\driver\driver->sql_query_limit()FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v310\passwords_convert_p1->update_passwords()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()