This is the error I get
Any help would be appreciated and this is on a dev site
Code:
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/mainnu/www/pf.main.nu/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> : Thursday, May 9th 2019 @ 07:11:18 PM<br /> <strong>Error Date</strong> : Thursday, May 9th 2019 @ 07:11:19 PM<br /> <strong>Script</strong> : http://pf.main.nu/install/upgrade.php<br /> <strong>Referrer</strong> : http://pf.main.nu/install/upgrade.php<br /> <strong>Classname</strong> : vB_Database_MySQLi<br /> <strong>MySQL Version</strong> : 5.6.43<br /> </p>]]></error_html> </errors>
Any help would be appreciated and this is on a dev site
Comment