Upgrade from 4.2.0 PL1 to 4.2.5 with large database.
The site in question is http://www.politics.ie and it does have vBSEO installed although the intention is to remove that eventually.
I ran the upgrade via SSH.
See error at Step 7 of Upgrading to 4.2.5 Beta 2:
Then:
So it appears that the main forum upgrade completed.
But then it attempts to update the blog ((not actually being used; disabled):
>>>> So I'm guessing the CMS (which is being used) did not get upgraded?
Full output of Upgrade
The site in question is http://www.politics.ie and it does have vBSEO installed although the intention is to remove that eventually.
At present, your forum has more than 12,078,974 posts. If you encounter timeouts during the install process, there is a console version of the upgrade available to you. In order to perform a console upgrade, perform the following steps:
Login to your server via SSH
Change your directory to the install directory of your forums, example:
cd /forums/install
Execute the upgrade script, example:
php -f upgrade.php
Contact vBulletin Customer Support if you are still unsure of how to continue.
Login to your server via SSH
Change your directory to the install directory of your forums, example:
cd /forums/install
Execute the upgrade script, example:
php -f upgrade.php
Contact vBulletin Customer Support if you are still unsure of how to continue.
See error at Step 7 of Upgrading to 4.2.5 Beta 2:
Code:
[B]Step 7 - Upgrade Aborted : Unable to find Type : vBForum_IPAddress <<< Note error here but upgrade continued[/B]
Code:
[B]Upgrading to 4.2.5 ---------------------------------- Upgrade Complete[/B]
So it appears that the main forum upgrade completed.
But then it attempts to update the blog ((not actually being used; disabled):
Code:
[B]Step 18 - Database error in vBulletin 4.2.5:[/B] Invalid SQL: SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid FROM blog_text bt JOIN blog bl USING (blogid) LEFT JOIN ipdata ip ON ( bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid AND bt.userid = ip.userid AND ip.contenttypeid IN (, ) ) WHERE ipid IS NULL; MySQL Error : You have an error in your SQL syntax; check the manual that correspondsto your MySQL server version for the right syntax to use near ' ) ) WHERE ipid IS NULL' at line 6 Error Number : 1064 Request Date : Tuesday, September 11th 2018 @ 03:04:31 PM Error Date : Tuesday, September 11th 2018 @ 04:48:57 PM Script : http:// Referrer : IP Address : IPADDRESS Username : Classname : vB_Database_MySQLi MySQL Version : 5.6.40 Server : User Agent :
Full output of Upgrade
Code:
Upgrading to 4.2.4 Beta 1 ---------------------------------- Step 6 - Altering post Table (1 of 1) Upgrade Complete Upgrading to 4.2.4 Beta 2 ---------------------------------- Upgrade Complete Upgrading to 4.2.4 Beta 3 ---------------------------------- Step 1 - Altering moderator Table (1 of 1) Step 2 - Altering passwordhistory Table (1 of 2) Altering passwordhistory Table (2 of 2) Step 3 - Altering user Table (1 of 4) Altering user Table (2 of 4) Step 4 - Altering user Table (3 of 4) Altering user Table (4 of 4) Step 5 - Disable or Remove Old Products Upgrade Complete Upgrading to 4.2.4 Release Candidate 1 ---------------------------------- Upgrade Complete Upgrading to 4.2.4 Release Candidate 2 ---------------------------------- Upgrade Complete Upgrading to 4.2.4 Release Candidate 3 ---------------------------------- Step 1 - Updating Read Marking Option Upgrade Complete Upgrading to 4.2.4 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Alpha 1 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Alpha 2 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Alpha 3 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Beta 1 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Beta 2 ---------------------------------- Step 1 - Altering session Table (1 of 1) Step 2 - Altering threadrate Table (1 of 1) Step 3 - Altering apiclient Table (1 of 1) Step 4 - Altering apilog Table (1 of 1) Step 5 - Altering searchlog Table (1 of 1) Step 6 - Updating contenttype table (1 of 1) [B]Step 7 - Upgrade Aborted : Unable to find Type : vBForum_IPAddress <<< Note error here but upgrade continued[/B] Step 8 - Altering ipdata Table (1 of 2) Altering ipdata Table (2 of 2) Step 9 - Updating postlog table Altering postlog table Altering postlog table Step 10 - ^C [root@vm2 install]# php -f upgrad.php Could not open input file: upgrad.php [root@vm2 install]# php -f upgrade.php Upgrading to 4.2.5 Beta 2 ---------------------------------- Step 10 - Altering searchcore Table (1 of 2) Altering searchcore Table (2 of 2) Step 11 - Updating adminmessage table Step 12 - Skipping step, not needed Step 13 - Updating groupmessage table Step 14 - Updating picturecomment table Step 15 - Updating visitormessage table Step 16 - Skipping step, not needed Upgrade Complete Upgrading to 4.2.5 Beta 3 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Beta 4 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Release Candidate 1 ---------------------------------- Upgrade Complete Upgrading to 4.2.5 Release Candidate 2 ---------------------------------- Upgrade Complete [B]Upgrading to 4.2.5 ---------------------------------- Upgrade Complete[/B]
Code:
Processing Blog ---------------------------------- Step 1 - Skipping step, not needed Step 2 - Skipping step, not needed Step 3 - Skipping step, not needed Step 4 - Skipping step, not needed Step 5 - Skipping step, not needed Step 6 - Skipping step, not needed Step 7 - Skipping step, not needed Step 8 - Skipping step, not needed Step 9 - Skipping step, not needed Step 10 - Skipping step, not needed Step 11 - Skipping step, not needed Step 12 - Skipping step, not needed Step 13 - Skipping step, not needed Step 14 - Skipping step, not needed Step 15 - Skipping step, not needed Step 16 - Skipping step, not needed Step 17 - Skipping step, not needed [B]Step 18 - Database error in vBulletin 4.2.5:[/B] Invalid SQL: SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid FROM blog_text bt JOIN blog bl USING (blogid) LEFT JOIN ipdata ip ON ( bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid AND bt.userid = ip.userid AND ip.contenttypeid IN (, ) ) WHERE ipid IS NULL; MySQL Error : You have an error in your SQL syntax; check the manual that correspondsto your MySQL server version for the right syntax to use near ' ) ) WHERE ipid IS NULL' at line 6 Error Number : 1064 Request Date : Tuesday, September 11th 2018 @ 03:04:31 PM Error Date : Tuesday, September 11th 2018 @ 04:48:57 PM Script : http:// Referrer : IP Address : IPADDRESS Username : Classname : vB_Database_MySQLi MySQL Version : 5.6.40 Server : User Agent : [root@vm2 install]#
Comment