Switched hosts and now my forums are SCREWED!!

[Crazy Pete]

Ok I really need someone's help with this. I just moved my forums to a new host and restored the old database. Everything worked flawlessly on my old host, and all appeared well at first on this new one, but now when I try to view a thread, I get this horrendous error that I have NO idea how to fix!!

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT

thread.threadid,thread.lastposter,thread.title,thr ead.postusername,thread.replycount,thread.

lastpost,thread.postuserid,
thread.dateline,forum.title AS

ftitle,forum.forumid,forum.parentlist
FROM thread
LEFT JOIN forum ON (thread.forumid=forum.forumid)
WHERE thread.threadid<>949 AND thread.forumid IN( 5,3,4,6,7,14,8,12,13,15,11,10,18,21,9,19,16,17 )
AND MATCH(thread.title) AGAINST ('pittsburgh show cancelled')
AND thread.open<>10
AND thread.visible=1
ORDER BY dateline DESC
LIMIT 4
mysql error: Can't find FULLTEXT index matching the column list

mysql error number: 1191

Date: Saturday 03rd of May 2003 01:04:36 AM
Script: http://www.expectedmiracles.com/foru...p?threadid=949
Referer: http://www.expectedmiracles.com/foru....php?forumid=7
Repair Report: This type of error cannot be automatically repaired.


PLEASE!! Someone help! I have no idea what went wrong. Thaks for any advice!