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