-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 3.2.10-RC1, 3.3.1-RC1
-
Component/s: Search
-
Environment:PHP 7.4, MariaDB 10.4, phpBB 3.3
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', '>='); |