SQL syntax error

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]

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.

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 ...