Upgrading from 4.2.4 to 4.2.5 stuck on blog step 18

[RedVee]

Hi.

My hosting company upgraded from PHP 5.6 to PHP 7.2
I got them to go back to PHP 7.1 but they won't go further back than this.
I read up on upgrading vB, and I enabled blogs and CMS.
I did everything else by the book and ran the upgrade script.
Everything was going fine until it reached step 18 of the blog upgrade, when it aborted.
I don't use the blogs - would uninstalling them and re-running the upgrade fix this?
All help gratefully received.


Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?> <br /> <b>Warning</b>: mysqli_query(): (42S02/1146): Table 'redvee.vbblog_text' doesn't exist in <b>/var/www/vhosts/redvee.net/subdomains/forums/httpdocs/includes/class_core.php</b> on line <b>1386</b><br /> <?xml version="1.0" encoding="windows-1252"?> <errors> <error><![CDATA[<p>Database Error</p> Invalid SQL: SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid FROM vbblog_text bt JOIN vbblog bl USING (blogid) LEFT JOIN vbipdata ip ON ( bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid AND bt.userid = ip.userid AND ip.contenttypeid IN (15, 16) ) WHERE ipid IS NULL; Table 'redvee.vbblog_text' doesn't exist]]></error> <error_html><![CDATA[<p>Database error in vBulletin 4.2.5</p> <p>Invalid SQL: SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid FROM vbblog_text bt JOIN vbblog bl USING (blogid) LEFT JOIN vbipdata ip ON ( bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid AND bt.userid = ip.userid AND ip.contenttypeid IN (15, 16) ) WHERE ipid IS NULL;<p> <p> <strong>MySQL Error</strong> : Table 'redvee.vbblog_text' doesn't exist<br /> <strong>Error Number</strong> : 1146<br /> <strong>Request Date</strong> : Monday, August 30th 2021 @ 02:34:47 PM<br /> <strong>Error Date</strong> : Monday, August 30th 2021 @ 02:34:48 PM<br /> <strong>Script</strong> : http://forums.redvee.net/install/upgrade.php<br /> <strong>Referrer</strong> : http://forums.redvee.net/install/upgrade.php<br /> <strong>Classname</strong> : vB_Database_MySQLi<br /> <strong>MySQL Version</strong> : 10.1.41-MariaDB<br /> </p>]]></error_html> </errors>

[RedVee]

Figuring I had nothing to lose, I disabled the blogs and CMS, which is how I normally have them.

Ran the upgrade script, started and aborted at step 18.

Figuring I REALLY had nothing to lose, I uninstalled them.

Ran the upgrade script, started at step 18 and continued to completion.

Once complete, just for ****s n giggles, I ran it again. It started at blogs step 1 and ran through to completion.

I now have a fully working vB4.2.5

Praise be to Sir Tim

[RedVee]

More things of note: it fully rebuilt and re-installed the blogs and CMS. If i enable them, BOOM, Table 'redvee.vbblog_text' doesn't exist errors return. So the issue isn't fully fixed but given I never use the things anymore, they can stay disabled.

[Wayne Luke]

You will need to have the Blog and CMS installed and enabled to upgrade the Publishing Suite. The upgrade will not proceed when they are missing or disabled. Once you finished the upgrade, you can disable them again.

[RedVee]

That’s where i disagree. The upgrade would not proceed until i uninstalled the blog and CMS. Then it proceeded and it created a fresh blog and CMS installation.

[Wayne Luke]

Then something was broken in the previous installation that I have no information about.