mySQL error

Deadly_Spike · 03-22-2007, 09:38 PM

Well on the arcade, whenever I get a high score (and I mean when I've doen exceptionally well) instead of posting my score, I get taken to this error.

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 22nd of March 2007 09:35:17 PM

It usually happens when I get a score higher than 10000 (tested on space invaders and pac man, tetris, and breakout) all that hard work for nothing... A little help would be appreciated.

Simon Harrison · 03-24-2007, 09:50 AM

Cheers Ryan, will get the coder to take a look.

mtha · 03-25-2007, 05:01 AM

if you could, please try again and see how it goes now.

Also, what's your login status at that time, if you check "Remember me" when login, and how long it would take for you to play?

that error happen when you lost your session ...

anyway, let me know how's goes now
thanks

Deadly_Spike · 03-25-2007, 10:51 PM

Ok that fixed the problem. Thanks

Now my highscores will be higher than ever

Sarah · 09-14-2007, 05:09 PM

Yeah, I've noticed

trying desperately to get close at least on the tetris ...