[shadowla05]

Ok so i sucessfully updated to vb4 woot woot every thing waz fine untill i updated this Mod,now all i get is this. please help i hope this is simple to fix but i think this might of happen cuz i forgot to set YES under AdminCP -> vBulletin Options -> vBulletin Options -> Plugin/Hook System as i had it set to NO while i did the vb4 update.

and i keep getting this Database error

Database error in vBulletin 4.0.1:

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='6072'
ORDER BY attach DESC
LIMIT 1;

MySQL Error : Unknown column 'a.postid' in 'on clause'
Error Number : 1054
Request Date : Monday, February 15th 2010 @ 12:24:10 AM
Error Date : Monday, February 15th 2010 @ 12:24:10 AM
Script : http://mysite.com/index.html/
Referrer : http://mysite.com/index.html/
IP Address : xxx.x.xx.xxx
Username :
Classname : vB_Database
MySQL Version :


http://i45.tinypic.com/33fc9x2.jpg