having error sometimes in arcade

[PAKIDIL]

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

[JJX]

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

[MrZeropage]

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

[JJX]

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.

[MrZeropage]

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+ ?

[JJX]

Mine is a new install of 2.6.2+

[MrZeropage]

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

[JJX]

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

[MrZeropage]

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

[JJX]

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

[MrZeropage]

*updated the instructions* ;)

[jeff0078]

I just put the arcade up yesterday and someone reported this very issue this morning. Seeing something about 'holdsession.php' I re-downloaded and before I uploaded the file I noticed I already had one in my main forum directory. I uploaded it anyways and noticed the file size was different. Should the problem be fixed now?

[MrZeropage]

I did not change anything, maybe it was some binary upload via FTP... ?

Make sure the file is correct to keep the session alive during play :)

[subzero06]

im getting the same error..

[PAKIDIL]

same here i didnt notice abt hold session.php file where should i upload it in forum folder or it should be in forum/arcade/holdsession.php ?

[MrZeropage]

holdsession.php must be in forum's root (where arcade.php is)

[PAKIDIL]

i upload the file in forum' root ( where arcade.php is ) but its still same getting 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 26th of July 2007 10:16:02 AM

[AdmiralGeek]

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

Error ReturnedmySQL 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: Thursday 26th 2007f July 2007 01:43

me toooo! after the upgrade. And this happens on pacman mostly,

[stangger5]

same here i didnt notice abt hold session.php file where should i upload it in forum folder or it should be in forum/arcade/holdsession.php ?

Put the holdsession.php in the same place as arcade.php...

If you have arcade.php like this..
forum/arcade.php

holdsession.php should be
forum/holdsession.php