DataBase Error HELP!!!

[shadowla05]

Ok i waz doing the vb upgrade from 3.8.3 to vb4 and every thing went fine and b4 doing the upgrade i disable all mods and plugins i had. so i did the upgrade script and and the end when it takes to the admin cp i get a DataBase Error. then i keep getting email with different codes like this two here.

Invalid SQL:
SELECT t.threadid as tid, t.title as title,t.replycount as rcount, p.pagetext as pagetext,a.attachmentid as attach,f.forumid as forumid,f.title as forum from thread as t
LEFT JOIN post as p on(t.firstpostid=p.postid)
LEFT JOIN attachment as a on(a.postid=p.postid)
LEFT JOIN forum as f on(t.forumid=f.forumid)
where t.threadid='5686'
ORDER BY attach DESC
LIMIT 1;

MySQL Error : Unknown column 'a.postid' in 'on clause'
Error Number : 1054
Request Date : Monday, January 4th 2010 @ 06:36:05 PM
Error Date : Monday, January 4th 2010 @ 06:36:05 PM
Script : http://psprelese-forums.com/index.html/ajax.php
Referrer : http://psprelese-forums.com/index.html/downloads.php
IP Address : 69.122.191.40
Username :
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT t.threadid as tid, t.title as title,t.replycount as rcount, p.pagetext as pagetext,a.attachmentid as attach,f.forumid as forumid,f.title as forum from thread as t
LEFT JOIN post as p on(t.firstpostid=p.postid)
LEFT JOIN attachment as a on(a.postid=p.postid)
LEFT JOIN forum as f on(t.forumid=f.forumid)
where t.threadid='5686'
ORDER BY attach DESC
LIMIT 1;

MySQL Error : Unknown column 'a.postid' in 'on clause'
Error Number : 1054
Request Date : Monday, January 4th 2010 @ 06:33:04 PM
Error Date : Monday, January 4th 2010 @ 06:33:04 PM
Script : http://psprelese-forums.com/index.html/forum.php
Referrer :
IP Address : 74.160.160.183
Username :
Classname : vB_Database
MySQL Version :

Please help me fix this i need my board open ASAP thanx.

[Lynne]

That is leftover from a modification, or an old vB3.8 file, as there is no postid field in the attachment table in vB4.