Hi vBulletin Support,
We have been having issues with upgrading vBulletin from 4.0.8 to 5.0.5 Patch Level 6. We have recently purchased v5 and fairly disappointed the upgrade process doesn't work. I have followed all the instructions. Our forum site literrally is now a broken page. During the upgrade we also got multiple MySQL errors. I was lucky to have a backup of the entire website files and MySQL database and rolled back...
Our server is running Windows 2003, IIS 6, with MySQL Server 5.1.51, PHP 5.3.3. forum site is called, lets say vbforums
I did exactly what is in the readme. I tried a number of different ways but I get the same results. We do not have modifications or plug-ins as far as I know
When upgrading from vBulletin 3 or vBulletin 4
These are the steps I've done
1) My website folder is /vbforums, I deleted all files and folders except customavatars, customgroupicons, customprofilepics, signaturepics (Also tried with a completely empty folder same results)
2) In /vbforums, I renamed config.php.bkp to config.php
3) I manually edited the /vbforums/core/includes/config.php, (because the configuration wizard didn't work as it complains about install.php unable to delete and stops there)
4) Ran http://vbforums/core/install/upgrade.php
5) After this I get the the prompt window and upgrade button, entered member customer no.
6) The the nightmare happens....
Database error in vBulletin 4.0.8:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_activitystream AS phrasegroup_activitystream,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 2 LIMIT 1;
MySQL Error : Unknown column 'language.phrasegroup_activitystream' in 'field list'
Error Number : 1054
Request Date : Monday, September 15th 2014 @ 11:02:17 AM
Error Date : Monday, September 15th 2014 @ 11:02:17 AM
Script : http://vbforums/forum.php
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :
Database error in vBulletin 4.0.8:
Invalid SQL:
SELECT * FROM groupintopic
WHERE `userid` = 1;
MySQL Error : Table 'vbforums.groupintopic' doesn't exist
Error Number : 1146
Request Date : Monday, September 15th 2014 @ 12:19:09 PM
Error Date : Monday, September 15th 2014 @ 12:19:10 PM
Script : http:///core/install/upgrade.php
Referrer :
IP Address :
Username :
Classname : vB_Database_MySQL
MySQL Version : 5.1.51-community
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT COUNT(*) AS postcount
FROM node;
MySQL Error : Table 'vbforums.node' doesn't exist
Error Number : 1146
Request Date : Monday, September 15th 2014 @ 11:55:10 AM
Error Date : Monday, September 15th 2014 @ 11:55:10 AM
Script : http:///core/install/upgrade.php
Referrer : http://vbforums/core/install/upgrade.php
IP Address :
Username :
Classname : vB_Database_MySQL
After some research I discovered this thread http://www.vbulletin.com/forum/forum...o-5-0-5-solved, which addresses "MySQL Error : Table 'vbforums.node' doesn't exist", editing /core/install/includes/class_upgrade_ajax.php
This means your script is not even correct, how can you expect customers to know this?
For: MySQL Error : Unknown column 'language.phrasegroup_activitystream' in 'field list', I deleted all files under includes/XML under 4.0.8, the error message disappeared.It also disappeared if I upgrade with empty folder of course. Unsure if this is the proper fix, it was from here http://www.vbulletin.com/forum/forum...atabase-errors
However, MySQL Error : Table 'vbforums.groupintopic' doesn't exist, remains a problem no matter what I tried, I'm unsure if this can be safely ignored.
When the upgrade completes, our forum page is totally broken no images, random links and out of whack....see attachment. It doesn't matter if I have existing files OR start from a clean directory.
I've tried upgrading to 4.2.2 patch 1 first then to 5.0.5 still the same problem. If I upgrade from 4.0.8 to 4.2.2 patch1, I have 0 issues with the above fixes. I expected the product to work out of the box. Same error.
From 4.2.2 patch 1 to 5.05 Patch Level 6 Upgrade with empty folder
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT * FROM groupintopic
WHERE `userid` = 1;
MySQL Error : Table 'vbforums.groupintopic' doesn't exist
Error Number : 1146
Request Date : Monday, September 15th 2014 @ 12:02:02 PM
Error Date : Monday, September 15th 2014 @ 12:02:02 PM
Script : http:///core/install/upgrade.php
Referrer : http://vbforums/core/install/upgrade.php
IP Address :
Username :
Classname : vB_Database_MySQL
MySQL Version : 5.1.51-community
Also I discovered when you restore the MySQL database if you don't drop the schema, the tables that's been added by 5.05 upgrade, will remain eg. /videos/.
I restored the database to 4.0.8, then attempt to run the upgrade again for 5.05 patch 6, it will complain /videos/ exist also gives me the error
"Action Required
Unexpected Text:
<?xml version="1.0" encoding="UTF-8"?>"
Then upgrade then stops.
Over the last 4 days I've been trying all different methods (doesn't matter we upgrade to 4.2.2 patch 1 first, empty folder, existing folder) but the forum page is still broken no matter what. I'm extremely frustrated and also discovered that the manager purchased vBulletin 5 under his name, but he is not the technical person to really talk to for support. For submitting tickets that means it will go to his email, this is not ideal. I don't know how to submit a ticket with an alternative contact email as there's only one contact under my manager's name!
We requested my contact to be added, [SID-1296106-2a8628c0], but still haven't heard back. Hence this post. I can only register for premium forum support.
We really need some help on this, else we totally lost faith with vBulletin.
Someone should give us a call and walkthrough the ENTIRE correct process to fix this up. I'm not keen to do this on our production forums, I don't mind creating a test environment.
Also tell us later what we need to the latest 5.1.3 upgrade.
Thank you.
We have been having issues with upgrading vBulletin from 4.0.8 to 5.0.5 Patch Level 6. We have recently purchased v5 and fairly disappointed the upgrade process doesn't work. I have followed all the instructions. Our forum site literrally is now a broken page. During the upgrade we also got multiple MySQL errors. I was lucky to have a backup of the entire website files and MySQL database and rolled back...
Our server is running Windows 2003, IIS 6, with MySQL Server 5.1.51, PHP 5.3.3. forum site is called, lets say vbforums
I did exactly what is in the readme. I tried a number of different ways but I get the same results. We do not have modifications or plug-ins as far as I know
When upgrading from vBulletin 3 or vBulletin 4
- It is best to upload the files into a new directory.
- Copy the /upload/ your new html folder. For simplicity's sake, I'm going to assumed it's been renamed and refer to it as /vb5/.
- Rename /vb5/config.php.bkp to config.php.
- You can ignore all other values for a basic setup.
- Rename /vb5/core/includes/config.php.new to config.php and edit it like you would for vB4. (Change the database credentials & database name.). This is similar to how you installed/upgraded vBulletin 3 and 4.
These are the steps I've done
1) My website folder is /vbforums, I deleted all files and folders except customavatars, customgroupicons, customprofilepics, signaturepics (Also tried with a completely empty folder same results)
2) In /vbforums, I renamed config.php.bkp to config.php
3) I manually edited the /vbforums/core/includes/config.php, (because the configuration wizard didn't work as it complains about install.php unable to delete and stops there)
4) Ran http://vbforums/core/install/upgrade.php
5) After this I get the the prompt window and upgrade button, entered member customer no.
6) The the nightmare happens....
Database error in vBulletin 4.0.8:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_activitystream AS phrasegroup_activitystream,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 2 LIMIT 1;
MySQL Error : Unknown column 'language.phrasegroup_activitystream' in 'field list'
Error Number : 1054
Request Date : Monday, September 15th 2014 @ 11:02:17 AM
Error Date : Monday, September 15th 2014 @ 11:02:17 AM
Script : http://vbforums/forum.php
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :
Database error in vBulletin 4.0.8:
Invalid SQL:
SELECT * FROM groupintopic
WHERE `userid` = 1;
MySQL Error : Table 'vbforums.groupintopic' doesn't exist
Error Number : 1146
Request Date : Monday, September 15th 2014 @ 12:19:09 PM
Error Date : Monday, September 15th 2014 @ 12:19:10 PM
Script : http:///core/install/upgrade.php
Referrer :
IP Address :
Username :
Classname : vB_Database_MySQL
MySQL Version : 5.1.51-community
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT COUNT(*) AS postcount
FROM node;
MySQL Error : Table 'vbforums.node' doesn't exist
Error Number : 1146
Request Date : Monday, September 15th 2014 @ 11:55:10 AM
Error Date : Monday, September 15th 2014 @ 11:55:10 AM
Script : http:///core/install/upgrade.php
Referrer : http://vbforums/core/install/upgrade.php
IP Address :
Username :
Classname : vB_Database_MySQL
After some research I discovered this thread http://www.vbulletin.com/forum/forum...o-5-0-5-solved, which addresses "MySQL Error : Table 'vbforums.node' doesn't exist", editing /core/install/includes/class_upgrade_ajax.php
This means your script is not even correct, how can you expect customers to know this?
For: MySQL Error : Unknown column 'language.phrasegroup_activitystream' in 'field list', I deleted all files under includes/XML under 4.0.8, the error message disappeared.It also disappeared if I upgrade with empty folder of course. Unsure if this is the proper fix, it was from here http://www.vbulletin.com/forum/forum...atabase-errors
However, MySQL Error : Table 'vbforums.groupintopic' doesn't exist, remains a problem no matter what I tried, I'm unsure if this can be safely ignored.
When the upgrade completes, our forum page is totally broken no images, random links and out of whack....see attachment. It doesn't matter if I have existing files OR start from a clean directory.
I've tried upgrading to 4.2.2 patch 1 first then to 5.0.5 still the same problem. If I upgrade from 4.0.8 to 4.2.2 patch1, I have 0 issues with the above fixes. I expected the product to work out of the box. Same error.
From 4.2.2 patch 1 to 5.05 Patch Level 6 Upgrade with empty folder
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT * FROM groupintopic
WHERE `userid` = 1;
MySQL Error : Table 'vbforums.groupintopic' doesn't exist
Error Number : 1146
Request Date : Monday, September 15th 2014 @ 12:02:02 PM
Error Date : Monday, September 15th 2014 @ 12:02:02 PM
Script : http:///core/install/upgrade.php
Referrer : http://vbforums/core/install/upgrade.php
IP Address :
Username :
Classname : vB_Database_MySQL
MySQL Version : 5.1.51-community
Also I discovered when you restore the MySQL database if you don't drop the schema, the tables that's been added by 5.05 upgrade, will remain eg. /videos/.
I restored the database to 4.0.8, then attempt to run the upgrade again for 5.05 patch 6, it will complain /videos/ exist also gives me the error
"Action Required
Unexpected Text:
<?xml version="1.0" encoding="UTF-8"?>"
Then upgrade then stops.
Over the last 4 days I've been trying all different methods (doesn't matter we upgrade to 4.2.2 patch 1 first, empty folder, existing folder) but the forum page is still broken no matter what. I'm extremely frustrated and also discovered that the manager purchased vBulletin 5 under his name, but he is not the technical person to really talk to for support. For submitting tickets that means it will go to his email, this is not ideal. I don't know how to submit a ticket with an alternative contact email as there's only one contact under my manager's name!
We requested my contact to be added, [SID-1296106-2a8628c0], but still haven't heard back. Hence this post. I can only register for premium forum support.
We really need some help on this, else we totally lost faith with vBulletin.
Someone should give us a call and walkthrough the ENTIRE correct process to fix this up. I'm not keen to do this on our production forums, I don't mind creating a test environment.
Also tell us later what we need to the latest 5.1.3 upgrade.
Thank you.
Comment