I just deleted the fulltext indexes from post and thread and got the following error when undeleting a thread:
Quote:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT thread.threadid, MATCH(thread.title) AGAINST ('Premium Pack ?190') AS score
FROM thread AS thread
WHERE MATCH(thread.title) AGAINST ('Premium Pack ?190')
AND thread.open <> 10
AND thread.threadid <> 528589
LIMIT 5;
MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Date : Wednesday, November 7th 2007 @ 09:50:56 AM
Script : http://www.avforums.com/forums/posti...hread&t=528589
Referrer : http://www.avforums.com/forums/posti...hread&t=528589
IP Address : 82.37.224.75
Username : Stuart Wright
Classname : vB_Database
|
HELP!
(I recreated the index for now)