database error, missing column?

[onealien]

moving db to new server as i upgrade to vb4 from 3.8.6...when i moved to 'forum' db i get this error of a missing column...any suggestions?

Database error in vBulletin 4.1.9:

Invalid SQL:

SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible

FROM forum AS forum

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 = 2461);

MySQL Error : Unknown column 'forum.lastposterid' in 'field list'
Error Number : 1054

Classname : vB_Database
MySQL Version : 5.0.91-log

assistance appreciated....