Advertisement:

Author Topic: Index: cannot be created because the max message length  (Read 178 times)

Offline SteveZand

  • Semi-Newbie
  • *
  • Posts: 15
Index: cannot be created because the max message length
« on: April 29, 2020, 02:37:42 AM »
Code: [Select]
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:

Code: [Select]
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?

Offline Deaks

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 22,515
  • Gender: Male
    • SMFReview on Facebook
    • pouvik on GitHub
    • @@smfreview on Twitter
    • SMFReview
Re: Index: cannot be created because the max message length
« Reply #1 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.