Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
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
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:
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