Hi,
I've just got access to my VPS back, because I asked for a restore after having problems yesterday.
I backed up my vBulletin 3.7 beta 4 - then uploaded the vBulletin 3.7 beta 5 files and ran the upgrade. All went well, until I found a problem with a few forums not showing correctly.
After this I imported re-uploaded the beta 4 files, and imported the backup SQL using SSH due to the database size, which times-out under phpMyAdmin. In theory this should have worked, but this was not the case.
I now have the following errors when accessing vBulletin forums including the index.php:
I can't see how an error relating to vB 3.7 beta 5 is being produced when lastprefixid should be within the database. Also, in the admincp I have a few options like this:
*[human_verification_manager]*
*[social_bookmarking_manager]*
*[add_new_prefix_set]*
Surely, these relate to missing files or am I overlooking something here.
Any help would be appreciated, since I'm stuck now and don't have a clue on how I could possibly fix this problem.
I've just got access to my VPS back, because I asked for a restore after having problems yesterday.
I backed up my vBulletin 3.7 beta 4 - then uploaded the vBulletin 3.7 beta 5 files and ran the upgrade. All went well, until I found a problem with a few forums not showing correctly.
After this I imported re-uploaded the beta 4 files, and imported the backup SQL using SSH due to the database size, which times-out under phpMyAdmin. In theory this should have worked, but this was not the case.
I now have the following errors when accessing vBulletin forums including the index.php:
Code:
Database error in vBulletin 3.7.0 Beta 5: Invalid SQL: SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid , forumread.readtime AS forumread FROM vb3forum AS forum LEFT JOIN vb3forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 4); MySQL Error : Unknown column 'lastprefixid' in 'field list' Error Number : 1054 Date : Saturday, February 16th 2008 @ 05:31:08 PM Script : http://www.mydomain.com/forum/index.php Referrer : http://www.mydomain.com IP Address : xxx.xxx.xxx.xxx Username : xxxxxxxxxxxxx Classname : vB_Database MySQL Version : 4.1.22-standard
*[human_verification_manager]*
*[social_bookmarking_manager]*
*[thread_prefixes]*
*[thread_prefix_manager]**[add_new_prefix_set]*
Surely, these relate to missing files or am I overlooking something here.
Any help would be appreciated, since I'm stuck now and don't have a clue on how I could possibly fix this problem.
Comment