Switched hosts and now my forums are SCREWED!!
 

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!

did you switch your domain over to your new host as well? some links on your forum might be trying to gain access to a page with the old domain.

No, that's not the problem.

I suggest you contact your host and see what they have to say about it. Also, what is the MySQL version on the new server, and what was the version on the old server?

Well I fixed the problem. My old host was running MySQL 3.23, and now I'm running 4.012 on the new host. What fixed the problem was upgrading to vB 2.3.0. It kinda sucks because I have to rehack all my files again :(, but I figured I had intended on upgrading at some point, so now's a good a time as any I suppose.

Upgrading to the latest version of vB never sucks, unless you enjoy being hacked.

2.3.0 was a security update?

Most of the vB updates are. Also Jelsoft doesn't publicize every security hole fixed in an update.

Its too much of a hassle to upgrade a hacked board, even with that tutorial.

Well I finally did manage to update it all. Took me about 9 hours to readd all the things I had added before.

I also found out what the initial problem was, and it had to do with the vB3 Similar Threads hack that I installed. Apparently I had forgotten this step: ALTER TABLE `thread` ADD FULLTEXT(`title`);

I skipped it this time, thinking it was already there, and I had been checking threads out here and there to make sure things were good. Well, I got to this hack, made all the file changes, reloaded a thread and BAM! Got that same error. This time I went back to the beginning of it, ran that query and everything worked wonders.

So basically I could've saved myself 9 hours if I had done that originally, but hey...at least I'm updated now. :) Plus it happened while our DNS is still in the process of switching over so I guess it worked out.

Each to his own, but all I'm saying is that laziness may come back and bite you in the a** eventually.