1stsAz
07-08-2009, 10:46 PM
Hey,
Love the mod but I am having a MySQL error. The first time I had this error, I uninstalled the mod and then reinstalled it and it fixed the problem; until I played a game and got the first high score. As soon as I did that and I clicked on "play again", I got this error:
mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM vb_user WHERE userid=77) AS user LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=77 OR user.userid=77
mySQL error: 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 'SELECT * FROM vb_user WHERE userid=77) AS user LEFT JOIN vb_ava
mySQL error code:
Date: Wednesday 08th 2009f July 2009 07:42:46 PM
I don't know what that means or how to fix it. Userid=77 is me.
Also, I downloaded some games from ibarcade website but I notice some are secure. What does this mean?
EDIT: Doh, I have the same error as Doom Stone in this thread (https://vborg.vbsupport.ru/showthread.php?t=217449).
EDIT 2: I'm a dolt. The solution was posted by here (https://vborg.vbsupport.ru/showthread.php?t=201392).
Now the avatars aren't working but I'll keep searching in these forums as I'm sure there is an answer in here somewhere! :)
Love the mod but I am having a MySQL error. The first time I had this error, I uninstalled the mod and then reinstalled it and it fixed the problem; until I played a game and got the first high score. As soon as I did that and I clicked on "play again", I got this error:
mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM vb_user WHERE userid=77) AS user LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=77 OR user.userid=77
mySQL error: 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 'SELECT * FROM vb_user WHERE userid=77) AS user LEFT JOIN vb_ava
mySQL error code:
Date: Wednesday 08th 2009f July 2009 07:42:46 PM
I don't know what that means or how to fix it. Userid=77 is me.
Also, I downloaded some games from ibarcade website but I notice some are secure. What does this mean?
EDIT: Doh, I have the same error as Doom Stone in this thread (https://vborg.vbsupport.ru/showthread.php?t=217449).
EDIT 2: I'm a dolt. The solution was posted by here (https://vborg.vbsupport.ru/showthread.php?t=201392).
Now the avatars aren't working but I'll keep searching in these forums as I'm sure there is an answer in here somewhere! :)