Database errors after moving to new server

[Ken Iovino]

We just moved the site to a new beefier server.

I was getting this error in the thread table, a repair fixed it.
Warning: 2 clients are using or haven't closed the table properly

This is the data I get after running this code DESCRIBE threads;

threadid  	int(10) unsigned  	NO  	PRI  	   	auto_increment

This is the error i get when trying to get into the usercp.

Database error in vBulletin 3.0.7:

Invalid SQL: 
	SELECT thread.threadid, thread.forumid
	FROM thread AS thread, subscribethread AS subscribethread
	LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
	WHERE subscribethread.threadid = thread.threadid
	AND subscribethread.userid = 109188
	AND thread.visible = 1
	AND lastpost > 1187732539
	AND deletionlog.primaryid IS NULL

mysql error: Unknown column 'thread.threadid' in 'on clause'

mysql error number: 1054

PHP - 4.4.3, MySQL - 4.0.27, vBulletin 3.0.7

Any ideas or suggestions?

[Steve Machol]

The first error is from corrupt tables. Try repairing the tables in phpMyAdmin first.

[Ken Iovino]

I was getting this error in the thread table, a repair fixed it.

Any ideas why the thread.threadid column is showing up as unknown? If this was the case, then threads would not be showing up at all, but this only happens when going to the usercp.

[Steve Machol]

Sorry but I don't have a 3.0.7 db structure to compare this to and I don't even know if that is a standard vB query or one from an hack. My guess is that this is due to a modification you made.

Have you installed any hacks? If not, then why haven't you upgraded?

[Lynne]

Try this in your code (note the parenthesis in the FROM part of the statement):

SELECT thread.threadid, thread.forumid
    FROM (thread AS thread, subscribethread AS subscribethread)
    LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
    WHERE subscribethread.threadid = thread.threadid
    AND subscribethread.userid = 109188
    AND thread.visible = 1
    AND lastpost > 1187732539
    AND deletionlog.primaryid IS NULL