Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-12712

Password conversion migration fails on MSSQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-dev
    • Fix Version/s: 3.1.0-RC1
    • Component/s: None
    • Labels:
      None
    • Environment:
      MSSQL 2012 (11.0.2100.60)

      Description

      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()

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: