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

\phpbb\db\migration\data\v310\mysql_fulltext_drop tries to drop non existent indexes

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 3.1.3-RC1, 3.2.0-a1
    • Component/s: None
    • Labels:
      None

      Description

      Via https://tracker.phpbb.com/browse/PHPBB3-13221

      Updating database to latest stable release

      Database type :: mysqli
      Previous version :: 3.1.0-dev
      Installing Schema: \phpbb\db\migration\data\v310\mysql_fulltext_drop.
      SQL ERROR [ mysqli ]

      Can't DROP 'post_subject'; check that column/key exists [1091]

      SQL

      DROP INDEX post_subject ON bb304_posts

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/phpBB/db/driver/driver.php
      LINE: 855
      CALL: trigger_error()

      FILE: [ROOT]/phpBB/db/driver/mysqli.php
      LINE: 194
      CALL: phpbb\db\driver\driver->sql_error()

      FILE: [ROOT]/phpBB/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()

      FILE: [ROOT]/phpBB/db/tools.php
      LINE: 1428
      CALL: phpbb\db\driver\factory->sql_query()

      FILE: [ROOT]/phpBB/db/tools.php
      LINE: 1960
      CALL: phpbb\db\tools->_sql_run_sql()

      FILE: [ROOT]/phpBB/db/tools.php
      LINE: 837
      CALL: phpbb\db\tools->sql_index_drop()

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: phpbb\db\tools->perform_schema_changes()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 510
      CALL: call_user_func_array()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 456
      CALL: phpbb\db\migrator->run_step()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 277
      CALL: phpbb\db\migrator->process_data_step()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 234
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 234
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 234
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 234
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 234
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 174
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/install/database_update.php
      LINE: 206
      CALL: phpbb\db\migrator->update()

        Activity

        Hide
        bog_tom bog_tom added a comment -

        The upgrade flow was 3.0.11 -> 3.1 RC6 -> 3.1.0.

        It failed at each step.

        Show
        bog_tom bog_tom added a comment - The upgrade flow was 3.0.11 -> 3.1 RC6 -> 3.1.0. It failed at each step.
        Hide
        bantu Andreas Fischer added a comment -

        A workaround to this is to create a MySQL Fulltext Index (not a good idea for large board, though) or to remove the following code block. https://github.com/phpbb/phpbb/blob/release-3.1.0/phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php#L42-L48

        Show
        bantu Andreas Fischer added a comment - A workaround to this is to create a MySQL Fulltext Index (not a good idea for large board, though) or to remove the following code block. https://github.com/phpbb/phpbb/blob/release-3.1.0/phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php#L42-L48
        Hide
        nickvergessen Joas Schilling added a comment -

        Should check the existance of the indexes in effectively installed

        Show
        nickvergessen Joas Schilling added a comment - Should check the existance of the indexes in effectively installed
        Show
        Oyabun1 Oyabun1 added a comment - Same problem reported here: https://www.phpbb.com/community/viewtopic.php?f=466&t=2281956 , yet the indexes do exist: https://www.phpbb.com/community/viewtopic.php?p=13851701#p13851701

          People

          • Assignee:
            nickvergessen Joas Schilling
            Reporter:
            bantu Andreas Fischer
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development