| Doom Stone |
06-29-2009 08:16 PM |
[HELP] High Scores causes Database Error
Hello,
I've been having the following issue with the arcade.
Quote:
I installed the arcade and checked that it was working, it was, I then ran the converter and uninstalled v3arcade. I then deleted the v3arcade files.
I now get this error when accessing the arcade:
Note: User 1824 was the current arcade champion.
Quote:
mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM dbuser WHERE userid=1824) AS user LEFT JOIN dbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN dbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=1824 OR user.userid=1824
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 dbuser WHERE userid=1824) AS user LEFT JOIN dbava
mySQL error code:
Date: Friday 26th of June 2009 01:25:08 PM
|
Update:
I wasn't able to find a workaround for this unfortunately, so I have uninstalled everything and started over.
Installed v3, installed v3 games, installed ibpro, converted games to ibpro.
Being no scores, there was no issue this time.
However there is now the same error when scores are added, not sure where i've gone wrong here.
Vbulletin 3.8.0
V3arcade 1.1.1
|
Any help would be greatly appreciated as I can't seem to figure out whats causing the database error to appear once high scores have been registered.
Also, when I access different parts of the arcade it still works, however accesing the forumhome/arcade.php page the error occurs. |
More Information