Forum Upgrade errors ver 3.8.6 to 4.0.5

محروم.كوم · #1 09-09-2010, 04:40 PM

I did a fresh install of ver 3.8.6 to a test site on same server to a seperate database. I had my ISP copy the database from my live forum to the test site. Tried to upgrade to 4.0.5 and got data base errors below. Any ideas and help appreciated.

Peter Maloney
Fishin.com

Database error in vBulletin 3.8.6:

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

FROM vbforum AS forum

LEFT JOIN vbuser AS user ON (user.userid = forum.lastposterid)
LEFT JOIN vbuserlist 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 : Wednesday, September 8th 2010 @ 06:42:21 PM
Error Date : Wednesday, September 8th 2010 @ 06:42:21 PM
Script : http://www.fishin.com/forums2test/index.php
Referrer :
IP Address : 69.64.10.122
Username : Unregistered
Classname : vB_Database
MySQL Version :

Database error in vBulletin 3.8.6:

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

FROM vbforum AS forum

LEFT JOIN vbuser AS user ON (user.userid = forum.lastposterid)
LEFT JOIN vbuserlist 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 : Wednesday, September 8th 2010 @ 06:42:21 PM
Error Date : Wednesday, September 8th 2010 @ 06:42:21 PM
Script : http://www.fishin.com/forums2test/index.php
Referrer :
IP Address : 69.64.10.122
Username : Unregistered
Classname : vB_Database
MySQL Version :

Thanks
Peter __DEFINE_LIKE_SHARE__