From 3ee5472a8ca197b411c6b9f116ce73e9bf20e13b Mon Sep 17 00:00:00 2001 From: Andreas Fischer Date: Sun, 28 Aug 2016 20:40:10 +0100 Subject: [ticket/14109] Increase MySQL Version for InnoDB FULLTEXT Index to 5.6.8. This is required for proper overall database operation. In previous versions, InnoDB might error on ALTER statements when multiple FULLTEXT Indexes are defined. PHPBB3-14109 --- phpBB/phpbb/search/fulltext_mysql.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'phpBB/phpbb/search') diff --git a/phpBB/phpbb/search/fulltext_mysql.php b/phpBB/phpbb/search/fulltext_mysql.php index 3ddbd85b36..9faf5ca08b 100644 --- a/phpBB/phpbb/search/fulltext_mysql.php +++ b/phpBB/phpbb/search/fulltext_mysql.php @@ -177,8 +177,10 @@ class fulltext_mysql extends \phpbb\search\base $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.4', '>='); + phpbb_version_compare($this->db->sql_server_info(true), '5.6.8', '>='); if (!$fulltext_supported) { -- cgit v1.2.1