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!
OK, I'm fixed. I found the fix here: http://www.vbulletin.org/forum/showthread.php?t=229565
Thanks for a great product.
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