Fulltext index: cannot be created because the max message length is above 65,535

[Ivan Minic]

I made test upgrade from 1.05 to 1.1
First problem i spoted...

Space used by forum messages in the database: 485,301 KB
Space used to index messages in the database: 32,116 KB
Fulltext index: cannot be created because the max message length is above 65,535 or table type is not MyISAM.

[[Unknown]]

If your table type is not MyISAM, you'll need to convert the table to MyISAM:

ALTER TABLE smf_messages
TYPE = MyISAM;

If it's about the message length, you'll need to go to Admin -> Posts and Topics and lower the maximum message length as described.  In other words, the body column on messages needs to be text not mediumtext, or MySQL won't be able to create a FULLTEXT index.

-[Unknown]

[Ivan Minic]

The problem is the fact that it is MyISAM and it is smaller than 65535... it is 60000... and even when i made it 30000 it still gave same error

[[Unknown]]

Okay, what does this query give?

SHOW CREATE TABLE smf_messages;

What is phpMyAdmin?

-[Unknown]

[Enc0der]

I'll answer for him as I have the same issue..

SQL query:
SHOW CREATE TABLE messages
[ Edit ] [ Create PHP Code ] [ Refresh ]



Full Texts
Table    Create Table
messages    [BLOB - 1.0 KB]

(I don't use a prefix)


btw,
I'm having this error (even though MyISAM + 65535) and have the last search-method selected ("Fulltext search - match complete words") because I suppose it's the fastest for large forums (1 million+ messages....). should I stick with that method ?