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

Contact form migration fails on MSSQL

    Details

    • Type: Bug
    • Status: Unverified Fix
    • 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 :: 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 seconds

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

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development