Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-12712

Password conversion migration fails on MSSQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.1.0-RC1
    • 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()

            Marc Marc
            Noxwizard Patrick Webster
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: