Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
PHP 7.4, MariaDB 10.4, phpBB 3.3
Description
MySQL Fulltext index creation is currently only available for MyISAM and Innodb engines.
The Aria engine from MariaDB is a replacement for MyISAM and allows Fulltext indexes. Please modify fulltext_mysql.php to check for and allow the Aria engine.
$fulltext_supported =
|
|
|
$engine === 'Aria' || |
|
|
$engine === 'MyISAM' || |
// FULLTEXT is supported on InnoDB since MySQL 5.6.4 according to |
// http://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html |
// We also require https://bugs.mysql.com/bug.php?id=67004 to be |
// fixed for proper overall operation. Hence we require 5.6.8. |
$engine === 'InnoDB' && |
phpbb_version_compare($this->db->sql_server_info(true), '5.6.8', '>='); |