Advanced search in "message text only" crashes with SQL error when using Mysql fulltext search index

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Xymox2017
Registered User
Posts: 37
Joined: Tue Mar 07, 2017 3:06 pm

Advanced search in "message text only" crashes with SQL error when using Mysql fulltext search index

Post by Xymox2017 » Mon May 15, 2017 5:21 am

I come across this issue on my phpBB 3.2 board.
Exactly the same as described here:

viewtopic.php?f=466&t=2421931

JIRA issue:
https://tracker.phpbb.com/browse/PHPBB3-15224

My board uses : MySQL(i) 5.7.10

The bug seems not to be resolved in phpBB 3.1.10.
The same status on 3.2?

User avatar
AmigoJack
Registered User
Posts: 5589
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Advanced search in "message text only" crashes with SQL error when using Mysql fulltext search index

Post by AmigoJack » Mon May 15, 2017 8:53 am

Without knowing what caused the missing MySQL FULLTEXT index you can fix this manually by executing i.e.

Code: Select all

ALTER TABLE phpbb_posts ADD FULLTEXT( post_text );
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

Xymox2017
Registered User
Posts: 37
Joined: Tue Mar 07, 2017 3:06 pm

Re: Advanced search in "message text only" crashes with SQL error when using Mysql fulltext search index

Post by Xymox2017 » Mon May 15, 2017 11:36 am

Great, that fixed the issue.
Thanks.

Post Reply

Return to “[3.2.x] Support Forum”