Allow Aria Engine for MySQL Fulltext Indexing

General discussion of development ideas and the approaches taken in the 3.x branch of phpBB. The current feature release of phpBB 3 is 3.3/Proteus.
Forum rules
Please do not post support questions regarding installing, updating, or upgrading phpBB 3.3.x. If you need support for phpBB 3.3.x please visit the 3.3.x Support Forum on phpbb.com.

If you have questions regarding writing extensions please post in Extension Writers Discussion to receive proper guidance from our staff and community.
Post Reply
Frank Rizzo
Registered User
Posts: 17
Joined: Mon Nov 30, 2015 2:45 pm

Allow Aria Engine for MySQL Fulltext Indexing

Post by 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?
User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 1862
Joined: Thu Mar 02, 2006 4:29 pm
Location: Earth
Contact:

Re: Allow Aria Engine for MySQL Fulltext Indexing

Post by 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.
Image
Frank Rizzo
Registered User
Posts: 17
Joined: Mon Nov 30, 2015 2:45 pm

Re: Allow Aria Engine for MySQL Fulltext Indexing

Post by 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' ||
User avatar
3Di
Registered User
Posts: 864
Joined: Tue Nov 01, 2005 9:50 pm
Location: Milano (I) Frankfurt (D)
Contact:

Re: Allow Aria Engine for MySQL Fulltext Indexing

Post by 3Di »

Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫
Post Reply