mysql error

[Pure Adapt]

mySQL query error: SELECT * FROM games_session WHERE sessid= LIMIT 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 'LIMIT 1' at line 1
mySQL error code:
Date: Thursday 29th of March 2007 12:49:05 PM

Any ideas? It seems to only happen on one or two games, I'm going to try to repair the database and see what happens. Thanks.

[MrZeropage]

can you reproduce it as logged-in user ?

then I need instructions on how to provoke that error ...

[Pure Adapt]

yep, that's where I'm having the problems, it seems to give me an error under my name when a new high score is achieved, I can usually consistently beat the current high score which is where I get the error.

Thanks for the prompt reply.

Could it be that I don't have the arcade in my top navigation bar, but as a link in a subforum? I thought I entered in the code the proper way but I could be wrong. Check it out, its called the Game Room, last forum visible on the forum home page.

www.detailuniversity.com/forums/

Thanks,

George

[MrZeropage]

the link has nothing to do with it...

So this really does appear only when beating the actual highscore ?
Does the score get saved anyway ?

I see you only use the default games that come along with the arcade, so if you tell me exactly when this happens I will try to fix it.

If you provide AdminCP+FTP access I can try to find the problem and fix it directly on your site...

[Pure Adapt]

PM'ing info...