Can't find FULLTEXT index matching the column list

[vigape]

Hello

I move my DB from one server to a new server.
Now I receive a lot of errors with search script. I find at vbulletin.com and try to solve it, go into AdminCP under vBulletin Options -> Search Type and switch to the vBulletin search and then back to the Fulltext search, but the problem follows.

I try to delete de indexes and make a
ALTER TABLE vb_post ADD FULLTEXT INDEX (title,pagetext)
ALTER TABLE vb_thread ADD FULLTEXT INDEX (title)

But the problem follows

I need help, please.

A sample of error:

Database error in vBulletin 3.8.1:

Invalid SQL:

                                                SELECT
                                                DISTINCT thread.threadid, thread.forumid, post.userid
                                                FROM vb_thread AS thread

                                                INNER JOIN vb_post AS post ON(thread.threadid = post.threadid )
                                               WHERE MATCH(post.title, post.pagetext) AGAINST ('moon') AND thread.forumid NOT IN (0,79,82,59,30,13) AND post.visible = 1
                                                LIMIT 300;

MySQL Error   : Can't find FULLTEXT index matching the column list
Error Number  : 1191

And a pic of the indexes of vb_thread db.

Any help?

[Wayne Luke]

Switch your search type to vBulletin Built-in search and than switch it back to Fulltext. You can do this under vBulletin Options -> Search Type.

[vigape]

Switch your search type to vBulletin Built-in search and than switch it back to Fulltext. You can do this under vBulletin Options -> Search Type.

I try it and not solve the problem:

I try to solve it, go into AdminCP under vBulletin Options -> Search Type and switch to the vBulletin search and then back to the Fulltext search, but the problem follows.

[Wayne Luke]

Then you will need to manually run the queries above.

[vigape]

Then you will need to manually run the queries above.

I try and not solve the problem

I try to delete de indexes and make a
ALTER TABLE vb_post ADD FULLTEXT INDEX (title,pagetext)
ALTER TABLE vb_thread ADD FULLTEXT INDEX (title)

[Wayne Luke]

What was the output when you ran the queries. The error says the indexes created by those queries do not exist in your database. The only way to resolve this is to create the indexes.

[vigape]

The error does not happen in all the searches, I have not been able to see any, but the gathered thing in log (vberror.log) is like this:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT
DISTINCT thread.threadid, thread.forumid, post.userid
FROM vb_thread AS thread

INNER JOIN vb_post AS post ON(thread.threadid = post.threadid )
WHERE MATCH(post.title, post.pagetext) AGAINST ('irc') AND thread.forumid NOT IN (0,79,82,59,30,13) AND post.visible = 1
LIMIT 300;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Tuesday, September 22nd 2009 @ 09:56:52 PM
Error Date : Tuesday, September 22nd 2009 @ 09:56:55 PM
Script : http://********/search.php?do=process
Referrer : http://*********/search.php?do=process
IP Address : 80.*******
Username : ******
Classname : vB_Database
MySQL Version :
=====================================================


The indexes was created and exist sure

[Wayne Luke]

And the errors are still occurring? Or are these old errors that occurred before you re-added the indexes?

[vigape]

still occurring now

[hydn]

Got this fixed?

[vigape]

Not fixed

[vigape]

I fix it.

I run the query: ALTER TABLE `vb_post` ENABLE KEYS and works for me.

it seems that there was an error in the load that caused that keys did not activate