chikuru
03-15-2018, 06:46 AM
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..
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>
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..
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>