[Forum] Error in SQL syntax while upgrading to vbulletin 4.2.5

[westernmg]

Hello,
i'm trying to upgrade my vbulletin installation from 4.2.4 to 4.2.5 and cannot complete it.
The upgrader prozess stops with the following error:

<?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 MariaDB server version for the right syntax to use near ' )
            )
            WHERE ipid IS NULL' at line 6 in <b>XXX/vbulletin/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 MariaDB 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 MariaDB 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, July 1st 2017 @ 04:15:30 PM<br />
<strong>Error Date</strong>    : Saturday, July 1st 2017 @ 04:15:30 PM<br />
<strong>Script</strong>        : http://XXX/install/upgrade.php<br />
<strong>Referrer</strong>      : http://XXX/install/upgrade.php<br />
<strong>Classname</strong>     : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 10.0.28-MariaDB<br />
</p>]]></error_html>
</errors>

I have tried running the upgrade with PHP5 and 7, both with the same error.
Could someone help me please?

[westernmg]

Already found the solution here: https://www.vbulletin.com/forum/foru...de-error/page2

I just had to re-enable the blogs.