guest sql error on send score

mySQL query error: SELECT * FROM vb3_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: Monday 26th 2007f March 2007 02:24:37 AM

arcade configuration = guest can play but cant send score

Please any solution fast.

Thank you

[MrZeropage]

this only appears for guests ?

[testebr]

yes only for guest on submit score

[MrZeropage]

I guess this is a v3arcade-game where this appears, right ?

Or is this also on standard-games like simon or snake ?

If you provide FTP+AdminCP access via PM I will try to find the problem and fix it directly on your site ...

[testebr]

Well... I just tested in one game, but I believe many gamers have same problem on guest submit score.

I have a lot v3 arcade games, 500+.

I can't provide FTP+AdminCP because I am using the Arcade in an Lan House with no internet access.

I can fix it if you guide me.

[MrZeropage]

I am sure for 99% that this only is a problem with guests playing v3arcade-games, not with ibproarcade-games.

Could you verify this by testing it with the standard-games coming along with ibProArcade ? I guess they work fine for guests ...

[testebr]

I just tested the game Yeti Sports 8- Jungle Swing (game_yeti8.tar) downloaded from your website (ibpdownloads) today and same problem:

mySQL query error: SELECT * FROM vb3_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 27th 2007f March 2007 10:50:26 PM

Screenshot:

Attachment 62408

Cya

[MrZeropage]

but you played as guest again ?

[testebr]

hmmm, If I block cookies in browser I get the sql error...

with cookies enabled = no problem.

[MrZeropage]

Aaaaah, thanks for that info

Yes, as a guest has no user-table to insert any sessioninformation, I did that using cookies.
I think I will add some check before starting a game if cookies can be saved, and if not don't start the game...