Can't find FULLTEXT index matching the column list

[SorentoUltimate]

Hi when the RSS Cron Run i recieve a Database Error
Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT thread.threadid, MATCH(thread.title) AGAINST ('Πωλήσεις Απριλίου: Πτώση 18,1%') AS score
FROM thread AS thread

WHERE MATCH(thread.title) AGAINST ('Πωλήσεις Απριλίου: Πτώση 18,1%')
AND thread.open <> 10


LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Saturday, May 7th 2011 @ 05:00:10 PM
Error Date : Saturday, May 7th 2011 @ 05:00:31 PM

That Start happen after i backup my database and restore to a new one.

I Check threads table and the FULLTEXT Index exist with name title and Field title.

Please i need your help to solve the problem.

[kh99]

Could it have something to do with character set settings? If you imported it to a new database maybe the settings were different.

[SorentoUltimate]

Originally Posted by kh99

Could it have something to do with character set settings? If you imported it to a new database maybe the settings were different.

No the proble are not Character set.

The two Databases have the same Character set and Collation !!!!

Also the two databases are under the same MySQL Server.

[N1GTO4]

Look in the table structure for the effected database. Go to the bottom of the structure page and see if the table is disabled, that is what was wrong with my site.

I fixed it by making a blank fresh install of vbulletin in another password protected folder and importing the data only from the trobled tabled to the fresh clean table of the same name. I then dropped the troubled table and imported the good one with the imported data back to the public sites database.

There may be an easier way but this worked for me and got everything back to normal.