having error sometimes in arcade
 

hi i have install it and its working now storing score but some times my members having this type of 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: Sunday 22nd of July 2007 02:40:40 AM

how to resolve it please tell me thanks

Don't think there's a solution yet, see https://vborg.vbsupport.ru/showthread.php?t=144182

to find the problem I need somebody to reproduce this and tell me how to

The problem seems to occur when users don't tick the 'remember me' box, but if the session length is 15 minutes and the game lasts 2 minutes the error still occurs. If the session length was 15 minutes and the game lasts 20 minutes I could understand the error. Basically it seems that if the 'remember me' option isn't ticked the cookie session is ended some time between the game loading and the score being submitted.

you have v2.6.2+ installed ?
you uploaded the new file "holdsession.php" to your forum's root ?
you overwrote ALL files in the update to v2.6.2+ ?

Mine is a new install of 2.6.2+

could you tell me your mailaddress via PM so I can send you an alternative arcade.php which has a debug-mode for this ? So I can find where the problem is...

I didn't have the holdsession.php uploaded, I'll see how it goes now.

I guess this helps alot as this prevents being logged out :D

I just ignored it, because the instructions didn't mention it, I'm new to ibproarcade.

At least now I know what it's for. :)