hi, When I update a version from 4.2.4 to 4.2.5 I have the following error:
Unexpected Text:
how i can fixed it?
Unexpected Text:
PHP Code:
<?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/iaskcoil/public_html/forums/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 blog_text bt JOIN blog bl USING (blogid) LEFT JOIN 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 blog_text bt JOIN blog bl USING (blogid) LEFT JOIN 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> : Saturday, April 28th 2018 @ 12:22:54 PM<br /> <strong>Error Date</strong> : Saturday, April 28th 2018 @ 12:22:54 PM<br /> <strong>Script</strong> : http://www.iask.co.il/forums/install/upgrade.php<br /> <strong>Referrer</strong> : https://www.iask.co.il/forums/install/upgrade.php<br /> <strong>Classname</strong> : vB_Database_MySQLi<br /> <strong>MySQL Version</strong> : 5.6.39-cll-lve<br /> </p>]]></error_html> </errors>