The upgrade hangs even if I refresh the page.
I already searched and tried the different solutions but nothing worked.
I cant also login to the forum and adminCP. After the interstitial page "Thank you for logging in....", it just return to the previous page and didnt log in..
Code:
Action Required
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/**********/public_html/forum/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 vb_blog_text bt
JOIN vb_blog bl USING (blogid)
LEFT JOIN vb_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 vb_blog_text bt
JOIN vb_blog bl USING (blogid)
LEFT JOIN vb_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> : Thursday, March 15th 2018 @ 06:48:31 AM<br />
<strong>Error Date</strong> : Thursday, March 15th 2018 @ 06:48:31 AM<br />
<strong>Script</strong> : http://www.**********.com/forum/install/upgrade.php<br />
<strong>Referrer</strong> : http://www.**********.com/forum/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 5.6.38<br />
</p>]]></error_html>
</errors>
03-15-2018, 06:46 AM
vb 4.2.5 Upgrade error
Linear Mode
