Forum Upgrade errors ver 3.8.6 to 4.0.5 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 |
الساعة الآن 12:20 AM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir