Quote:
Originally Posted by wikked
Everything installed fine
tested out the first game which played ok...new score showed ok
but then trying to access the arcade again brings up this database error
i can access the games individually but cant get to the arcade home as soon as a score is posted. I have removed and reinstalled and the same error occurred
Help please   :up:
by the way...im running Vb CMPS and had to do the changes to get the scores to be recorded
|
just done another instal today following every instruction to the letter byt again as soon as it posts a score i get the following database error
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 user WHERE userid=1) 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=1 OR user.userid=1
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 user WHERE userid=1) AS user LEFT JOIN avatar AS
mySQL error code:
Date: Saturday 09th of January 2010 12:30:14 PM
|
can anyone shed any light on this as its doing my head in now :down: