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

MySQL Fulltext search index creating still fails on InnoDB

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.1.11-RC1, 3.2.0
    • 3.2.0-RC2
    • 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

      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:

      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

            Marc Marc
            digitaltoast digitaltoast
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: