database error mysql?

[cmb7684]

My server was recently upgraded from omnicron to adama ..im not sure if this is what caused this but since then I have come across this problem when hitting the user cp button in either the vbindex page or forums page in vbulletin. All other buttons work ok. Does anyone have any idea what is wrong and how I can fix it?




Database error in vBulletin 3.0.6:

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 = 1
AND thread.visible = 1
AND lastpost > 1189059102
AND deletionlog.primaryid IS NULL

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

mysql error number: 1054

Date: Thursday 06th of September 2007 02:36:10 AM
Script: http://www.mysite.org/forums/usercp.php?
Referer: http://www.mysite.org/forums/vbindex.php
Username: XXXXXXX
IP Address: XXXXXXX