Allow Aria Engine for MySQL Fulltext Indexing

[Frank Rizzo]

I'm using MariaDB with the default engine set to aria.

Aria is an enhanced version of MyISAM and allows Fulltext indexing. Aria (storage engine)

Unfortunately phpbb (using 3.3) will not allow the creation of MySQL Fulltext index as it fails with this message:

MySQL fulltext indexes can only be used with MyISAM or InnoDB tables

Could phpbb be modified to detect and allow aria for Fulltext searches?

[DavidIQ]

I don't see why not. It might just work by simply changing the check for that error and excluding Aria. Just make a ticket for it in the tracker and if you've experimented with getting it working add some details there.

[Frank Rizzo]

OK, ticket created.

I fixed this by editing /phpbb/search/fulltext_mysql.php and adding a check for the Aria engine

~line 176

Code: Select all

		$fulltext_supported =
			$engine === 'Aria' ||
			$engine === 'MyISAM' ||

[3Di]

https://github.com/phpbb/phpbb/pull/5930