Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: SteveZand on April 29, 2020, 02:37:42 AM

Title: Index: cannot be created because the max message length
Post by: SteveZand on April 29, 2020, 02:37:42 AM
Fulltext index
Index: cannot be created because the max message length is above 65,535 or table type is not MyISAM


After searching for this error on the forum, I found this solution:

https://www.simplemachines.org/community/index.php?topic=50893.msg360181#msg360181

Do it manually:

ALTER TABLE smf_messages
ADD FULLTEXT body (body)


Is this all I have to do to let the forum use full indexed text search or are there some other steps I should execute?
Title: Re: Index: cannot be created because the max message length
Post by: Deaks on May 24, 2020, 03:41:51 PM
SteveZand, did it work?  I have  closed the topic for now if it hasnt worked let us know and we can try and help.