[HELP] mySQL query error

[teach1st]

I upgraded my arcade from 2.6.3 to 2.7.0 in vb 3.8.4

Now I get this error when clicking the link to the arcade:

mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM user WHERE userid=1165) AS user LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=1165 OR user.userid=1165

Thanks for any help!

[teach1st]

OK, I'm fixed. I found the fix here: https://vborg.vbsupport.ru/showthread.php?t=229565

Thanks for a great product.

[MrZeropage]

for everybody else facing this problem:

using ibProArcade v2.7.0+ or newer open /arcade/functions/dbclass.php and find
$force_oldsql = false;set this to TRUE if this error occures, then it will work fine (no error anymore), but will also have less performance