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

MySQL Fulltext search index creating still fails on InnoDB

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.2.0-RC2
    • Fix Version/s: 3.1.11-RC1, 3.2.0
    • Labels:
    • Environment:
      php: 7.1.0-5+deb.sury.org~xenial+1
      Database server:MySQL(i) 10.1.20-MariaDB-1~xenial
      Board version:3.2.0-RC2
      Linux 4.4.0-57-generic #78-Ubuntu x86_64

      Description

      InnoDB is the default storage engine for MySQL, and everyone should be using it.

      However, when creating a MySQL Fulltext search index, it fails with the following:

      SQL ERROR [ mysqli ]
      
      InnoDB presently supports one FULLTEXT index creation at a time [1795]
      
      SQL
      
      ALTER TABLE phpbb3_posts MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL, ADD FULLTEXT (post_subject), MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTEXT post_content (post_text, post_subject)
      

      The solution is simply to break the statement down into two statements - if I run this manually, it works:

      Unable to find source-code formatter for language: mysql. Available languages are: actionscript, html, java, javascript, none, sql, xhtml, xml
      ALTER TABLE phpbb3_posts MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL, ADD FULLTEXT (post_subject);
      ALTER TABLE phpbb3_posts MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTEXT post_content (post_text, post_subject);
      

      (This was posted way back in 2014,relating to phpBB 3.0.12 when creating a fulltext native)
      https://www.phpbb.com/community/viewtopic.php?p=14587976#p14587976

        Attachments

          Activity

            People

            • Assignee:
              Marc Marc
              Reporter:
              digitaltoast digitaltoast
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: