Forum Search issue since upgrade to v4
 

Hi all,

Just hoping for some direction here - since upgrading to v4.0, we now get a MySQL error whenever a search is done. I've tried repairing the table in question via AdminCP, but haven't had any success.

Having done some research, I'm guessing my fulltext index is shot - I'll admit though that I'm a MySQL newbie, so really not sure where to go from here.

Does anyone have any suggestions? The DB error:

Code:
Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT searchcore.searchgroupid, searchgroup.dateline
FROM vbb_searchcore AS searchcore
JOIN vbb_searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
JOIN vbb_searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)

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 : Friday, May 28th 2010 @ 09:52:22 AM
Error Date : Friday, May 28th 2010 @ 09:52:23 AM