how to fix ??? Can't find FULLTEXT index matching the column list

[prevb]

how to fix ??? Can't find FULLTEXT index matching the column list
pls help me
thanks

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('fsdfsdfsdf') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)

WHERE MATCH(searchgroup_text.title) AGAINST ('fsdfsdfsdf') AND
searchgroup.contenttypeid = 2


HAVING score > 4
LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Thursday, June 24th 2010 @ 02:45:39 PM
Error Date : Thursday, June 24th 2010 @ 02:45:39 PM
Script : http://ss1.vn/newthread.php?do=postthread&f=56
Referrer : http://ss1.vn/newthread.php?do=newthread&f=56
IP Address : 113.22.48.60
Username : admin
Classname : vB_Database
MySQL Version : 5.0.45-community-nt

[omanmoon.net]

I have same problem
can ant one help?

[giraffesyo]

Means your FULLTEXT index's in the mysql database have been damaged.

go to Admin CP -> vBulletin Options -> Search Type and change search type to vbulletin then back to full text and see if it fixes.

If it wont execute the queries automatically it will tell you what two queries you need to run on your database.

[omanmoon.net]

Hello

Still same problem and i cant use search

Database error in vBulletin 4.0.5:

Invalid SQL:

SELECT searchcore.searchgroupid, MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('test') AS score
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)

WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('test') LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Wednesday, September 22nd 2010 @ 04:47:20 AM
Error Date : Wednesday, September 22nd 2010 @ 04:47:20 AM
Script : http://www.###/vb/search.php?do=process
Referrer : http://www.####t/vb/search.php
IP Address : #####
Username : ####
Classname : vB_Database
MySQL Version : 5.1.50