So I'm trying to upgrade to 4.2.5 but the upgrade script keeps crapping out:
Database error in vBulletin 4.2.5:
Invalid SQL:
SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
FROM vbblog_text bt
JOIN vbblog bl USING (blogid)
LEFT JOIN vbipdata ip ON (
bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid
AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
)
WHERE ipid IS NULL;
MySQL Error : 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 Number : 1064
Suggestions most welcome!
Database error in vBulletin 4.2.5:
Invalid SQL:
SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
FROM vbblog_text bt
JOIN vbblog bl USING (blogid)
LEFT JOIN vbipdata ip ON (
bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid
AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
)
WHERE ipid IS NULL;
MySQL Error : 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 Number : 1064
Suggestions most welcome!
Comment