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>