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.