SQL syntax error

[wolf32]

Changed usergroup permissions so guests can play the arcade and I get 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 05th of April 2007 11:20:27 PM

Suggestions???

[MrZeropage]

this bug for guests is fixed for upcoming v2.6.2+

It only appears if guests prevent cookies to be saved

[bolly.beats]

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: Saturday 07th of April 2007 07:36:26 AM

I am the admin and i m getting this msg.

[wolf32]

this bug for guests is fixed for upcoming v2.6.2+

It only appears if guests prevent cookies to be saved

Oh, gotcha. Any idea for a release date?

[MrZeropage]

@bolly.beats:
You get this everytime ?

@wolf32:
"when it's done" ;)
But not that far in the future, just doing some more fixes and then it will be here ...

[winsoftware]

i also found this bug. my registered user told me about this bug too.

[milsirhc]

yea, i played as registered user and I got this error still.. =(

[MrZeropage]

can anybody reproduce this error with registered user ?
If so, please setup an account for me on your forum and send me the login-data via PM and tell me how to reproduce it... thanks

[winsoftware]

i dont know how to reproduce it. it dont get this error, but more and more user are telling me about it.

[DaMaK]

i get the error at work....at home i dont get the error. using same account and i am admin.

[MrZeropage]

Hmmm, what is the difference ?

Browser ?
Cookie-Protection/Blocker ?
Firewall ?


@winsoftware:
can any of those users reproduce the error ?

[winsoftware]

no they can't. they haven't got this error all the time.

[qcho]

same error.

REGISTERED, ADMIN, all users. (GUESTs ARE NOT ALLOWED TO PLAY)

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: Tuesday 24th of April 2007 03:57:46 PM

[MrZeropage]

@qcho:
even admin ? Well, please provide AdminCP+FTP access so I can have a look ...

[sparky5693]

Having this problem on my forum also, but it appears to happen at random.

[SBDJ]

I've also had this problem reported to me on my forum as well; it's not caused by the garbage collector cleaning out the session file before the user has finished the game is it?

The default is only 24 minutes, and this was the case on my server. I've just upped it to two hours for testing, and I've got a user who is always complaining about it so I've asked him to retest :)

OK, user has retested and says it is working now. Obviously I can't be positive about this, but it might be worth a try for those with issues

Two possible solutions;

Firstly server admin can edit php.ini and add...

session.gc_maxlifetime = xxxx

where xxxx is a value in seconds. Then restart the web server. This is obviously server-wide however then.

Or;

The mod code could be edited to do this at runtime. There are complications with doing this, a good article on it here (http://www.captain.at/howto-php-sessions.php).

HTH someone :)

[almightyone]

same problem here from some of my registered users
this is what they sent me
I have past the high score several times and doubled it at least once. When I go to submit score it gives me this error message

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: Tuesday 01st of May 2007 12:49:05 PM

[MrZeropage]

I really need some example where registered users and maybe even moderator/administrator gets that error.

Please contact me via PM and let me have a look on the code, so that I can add some debug-information to find out what the problem is and to finally fix that :)

[SBDJ]

Sorry guys; I just noticed that vBulletin overrides the session time anyway. I've just upped mine in the vb control panel to see if it makes any difference.

MrZeropage; I'll drop you a PM and sort out an account for you on my forum tomorrow so you can have a nosey around. I can also put you in touch with a user who regularly experiences the problem :)

[MrZeropage]

?! no spamming please ...

[sparky5693]

sorry... I tried to post a pic, hit some extra buttons. :)

[itdevil]

same error.

REGISTERED, ADMIN, all users. (GUESTs ARE NOT ALLOWED TO PLAY)

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: Tuesday 24th of April 2007 03:57:46 PM

Some of my Reg. members are receiving this error. What can i do to help in tracking this bug?

[MrZeropage]

provide AdminCP+FTP access via PM, create a test-account and tell me how to reproduce this with the test-account

[sparky5693]

I can't seem to find any way to repeat the problem. It seems random on my site.

[winsoftware]

@mrzeropage: ich habe den fehler bislang nur bekommen, wenn ich das häkchen bei "Angemeldet bleiben" weggenommen hab. das kann allerdings auch zufall sein.

[squidstir]

I had a member that was having this very problem and after messing around for a couple of days I discovered that if you don't check "Remeber me" when you log in then I'd get this error when I tried to save the score. Hasn't happened to him or anyone else since.

[jasonpeinko]

Myself and members have been getting this error also, but is just on one game i recently installed. I have changed the session time and everything but it is still occurring. A few members have gotten around it. But almost all cannot. It is not based on location either, because just after i changed the session time it worked for a while, but not anymore.

[ringleader]

Session timeout is the only logical explanation.

It's trying to make sure the user is logged in, and when it doesn't find a session_id it throws a fit.

Do like squidstir said, and tell them to click 'remember be' when logging in.

[RvG2]

two of my users saying like this:

bugs report on arcade
I encountered this when I played pacman. I suppoesed to get a hi score but when I was finished. this is what appeared..

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

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: Wednesday 18th of July 2007 09:18:15 PM

2. another problem..why is it that I encounter a auto log out evrytime?

================================================== =====

i encountered this too when i played MOON LANDER

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

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:

Your score won't be stored in Database because the Arcade only saves users top score per Game.

and im auto log out....

==========================================

But when I am (admin) is playing these errors are not showing at all... strange.

[JJX]

Is there any solution to this yet, I keep getting the same problem.

[MrZeropage]

Ok, I need somebody to test some alternative arcade.php (v2.6.3+ Dev-Edition) with debug-mode enabled to get an idea what is going wrong ... please apply via PM, thanks

[AdmiralGeek]

mySQL query error: SELECT * FROM vb_forumgames_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: Wednesday 25th 2007f July 2007 01:49:09 PM

same for me, i have just sent you a PM zero

There is no rythm to the error, as i can tell. But it is cookie related. i have set my auto log off to 30 minutes, and i played the game 4minutes beofre the time limit. So i would reckon that certain games are been ignorant towards the cookei!

[okgaz]

This has happened to me on pacman + other ppl seem to have reported it on pacman & moonlander. Has anyone had it happen to a V32 or V33 game or are they ok?