Upgrade error 4.2.3 to 4.2.4

[lacidious]

Same issue here. I am running barkinghard.com/forums/version.php Current PHP version: 5.6.29

Had hostgator upgrade it specifically for this upgrade.

Still get: Parse error: syntax error, unexpected '=', expecting ')' in /home3/tbpp/public_html/forums/includes/functions_misc.php on line 759

[Mark.B]

Originally Posted by lacidious

Same issue here. I am running barkinghard.com/forums/version.php Current PHP version: 5.6.29

Had hostgator upgrade it specifically for this upgrade.

Still get: Parse error: syntax error, unexpected '=', expecting ')' in /home3/tbpp/public_html/forums/includes/functions_misc.php on line 759

Again, this means the php version isn't what you think it is.

Can you still log into the admincp? What php version is reported there? As that is the only information that really matters.

[lacidious]

Server Type Linux Users to Moderate 15 [View]
Web Server Apache (cgi-fcgi) Threads to Moderate 0 [View]
PHP 5.6.29 Posts to Moderate 0 [View]
PHP Max Post Size 64.00 MB Attachments to Moderate 0 [View]
PHP Maximum Upload Size 64.00 MB Events to Moderate 0 [View]
PHP Memory Limit 256.00 MB Number of Queued E-Mails 0
MySQL Version 5.5.51-38.2
MySQL Packet Size 16.00 MB


Thanks for your help!

--------------- Added [DATE]1491065136[/DATE] at [TIME]1491065136[/TIME] ---------------

Ugh I was hoping I could turn my forum back on and it would work, but apparently this error took the entire forum down. Please advise, biggest month of the year for my forum.

[Paul M]

The only advice we can give is speak to your host.

That error is specific to older versions of PHP, and will not occur on 5.6.

[loua_oz]

Just logged in to here after failed upgrade and saw this post.

In March, tried to upgrade 4.2.3 P2 to 4.2.4 and did not work.
Today, tried to upgrade 4.2.3 P2 to 4.2.5 and same.

Hosting shows PHP 5.6.30.

VB Admin shows PHP 5.4.45.

For MySQL both (hosting and VB Admin panel) show 5.6.33

[Paul M]

Originally Posted by loua_oz

VB Admin shows PHP 5.4.45.

For MySQL both (hosting and VB Admin panel) show 5.6.33

Then your forum is running on php 5.4.
Its as simple as that, so contact your host.

[loua_oz]

Originally Posted by Paul M

Then your forum is running on php 5.4.
Its as simple as that, so contact your host.

What should I tell them? Someone from VB told me that you, the hosting site, are lying about versions of PHP?

--------------- Added [DATE]1494506710[/DATE] at [TIME]1494506710[/TIME] ---------------

How could I dispute what my hosting site says:

PHP Version 5.6.30

--------------- Added [DATE]1494550190[/DATE] at [TIME]1494550190[/TIME] ---------------

Has anyone actually upgraded to 4.2.4 or 4.2.5?What was their provider and VB Panel showing as versions of PHP?

[XXP]

Please help.
On update to 4.2.5 from 4.2.2, getting SQL error.
As suggested in this thread: checked that Blogs are enabled (yes), and returned to the vB control panel to check status:
It now reports that we are at vb 4.2.5 (partially as the upgrade halts halfway), and it confirms PHP 7.1.12

Thanks very much.

Here's the error message:

Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<br />
<b>Warning</b>: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' )
)
WHERE ipid IS NULL' at line 6 in <b>/home/xxxxxadm/public_html/bb/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 cr_blog_text bt
JOIN cr_blog bl USING (blogid)
LEFT JOIN cr_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;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' )
)
WHERE ipid IS NULL' at line 6]]></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 cr_blog_text bt
JOIN cr_blog bl USING (blogid)
LEFT JOIN cr_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;<p>
<p>
<strong>MySQL Error</strong> : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' )
)
WHERE ipid IS NULL' at line 6<br />
<strong>Error Number</strong> : 1064<br />
<strong>Request Date</strong> : Monday, December 18th 2017 @ 03:21:34 PM<br />
<strong>Error Date</strong> : Monday, December 18th 2017 @ 03:21:35 PM<br />
<strong>Script</strong> : http://www.xxxxx.com/bb/install/upgrade.php<br />
<strong>Referrer</strong> : http://www.xxxxx.com/bb/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 5.5.58-cll<br />
</p>]]></error_html>
</errors>

[Mark.B]

That's not even close to being the 'same error' - it is always best to start a new thread rather than piggybacking someone else's.

Anyway, in this case, you need to ensure the blog product is enabled in the admincp, then run the upgrade again.

[Stingray27]

Originally Posted by XXP

As suggested in this thread: checked that Blogs are enabled (yes)

The error says otherwise, it only occurs if you try to upgrade with the blogs disabled.