LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0);
MySQL Error : Unknown column 'forum.lastposterid' in 'field list'
Error Number : 1054
Request Date : Thursday, November 11th 2010 @ 06:06:04 AM
Error Date : Thursday, November 11th 2010 @ 06:06:04 AM
Script : http://xx.xx.xx.xx/~xxxx/
Referrer : http://xx.xx.xx.xx/~xxxx/
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :
And another thing .. my forum was 4.0.3 and now it is giving error of 3.8.0 .. weird .
i had 3.8.0 almost year and a half ago then i upgraded it to 3.8.2 and then i upgraded to 4.0.3 and stayed on 4.0.3 for almost 8 months now .. and my backup is of 1 month old ... i dont know why it is showing 3.8.0 ..
this is something so wired . please someone help fix this issue.