FullText search - set up manually

[hjmaier]

Hello,

I am switching over to MySQL full text search. I started the switch over the Admin CP and got an error (timeout).

Well, I expected that. I can build the full text search manually.

Currently this SQL command is running:


ALTER TABLE MF_VB3_post ADD FULLTEXT INDEX title( title, pagetext )

I guess as the 2nd step I have to do is:


ALTER TABLE MF_VB3_thread ADD FULLTEXT INDEX title( title )


is that right?

And when this is done? What to do next? I guess I have to set something in the database directly to tell vBulletin to use the FullText search.

Best regards
hj

[Wayne Luke]

If you look the setting should already be set for fulltext as it is done before the queries are attempted. If not then I'll figure out the query for you.

[hjmaier]

Ah, yes. It is all fine. Sorry for being so impatient :)

Best regards
hj