Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #16  
Old 26 Apr 2007, 11:51
SBDJ SBDJ is offline
 
Join Date: Jul 2004
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

Last edited by SBDJ; 26 Apr 2007 at 14:36. Reason: Automerged Doublepost
  #17  
Old 03 May 2007, 00:48
almightyone almightyone is offline
 
Join Date: Nov 2001
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
  #18  
Old 03 May 2007, 13:31
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
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
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 148.000 downloads!):
ibProArcade 2.7.6+ download here | Click here to enter the ibProArcade-Support-Section
Don't miss the new Google Analytics Integration (GDPR/DSGVO) for vB4.x
  #19  
Old 05 May 2007, 17:58
SBDJ SBDJ is offline
 
Join Date: Jul 2004
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
  #20  
Old 07 May 2007, 05:53
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
?! no spamming please ...
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 148.000 downloads!):
ibProArcade 2.7.6+ download here | Click here to enter the ibProArcade-Support-Section
Don't miss the new Google Analytics Integration (GDPR/DSGVO) for vB4.x
  #21  
Old 07 May 2007, 08:49
sparky5693 sparky5693 is offline
 
Join Date: Feb 2007
sorry... I tried to post a pic, hit some extra buttons.
  #22  
Old 08 May 2007, 10:21
itdevil's Avatar
itdevil itdevil is offline
 
Join Date: Oct 2005
Location: Switzerland [CH]
Real name: Tahir Meer
Originally Posted by qcho View Post
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?
  #23  
Old 09 May 2007, 06:27
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
provide AdminCP+FTP access via PM, create a test-account and tell me how to reproduce this with the test-account
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 148.000 downloads!):
ibProArcade 2.7.6+ download here | Click here to enter the ibProArcade-Support-Section
Don't miss the new Google Analytics Integration (GDPR/DSGVO) for vB4.x
  #24  
Old 10 May 2007, 21:24
sparky5693 sparky5693 is offline
 
Join Date: Feb 2007
I can't seem to find any way to repeat the problem. It seems random on my site.
  #25  
Old 16 May 2007, 09:59
winsoftware winsoftware is offline
 
Join Date: Jul 2006
@mrzeropage: ich habe den fehler bislang nur bekommen, wenn ich das häkchen bei "Angemeldet bleiben" weggenommen hab. das kann allerdings auch zufall sein.
  #26  
Old 14 Jun 2007, 14:34
squidstir squidstir is offline
 
Join Date: Sep 2006
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.
  #27  
Old 15 Jun 2007, 17:04
jasonpeinko jasonpeinko is offline
 
Join Date: Feb 2007
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.
  #28  
Old 19 Jul 2007, 13:58
ringleader's Avatar
ringleader ringleader is offline
 
Join Date: Dec 2006
Real name: Fran
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.

Last edited by ringleader; 19 Jul 2007 at 14:03.
  #29  
Old 19 Jul 2007, 17:04
RvG2's Avatar
RvG2 RvG2 is offline
 
Join Date: Jan 2007
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.
  #30  
Old 22 Jul 2007, 11:10
JJX JJX is offline
 
Join Date: Jul 2007
Is there any solution to this yet, I keep getting the same problem.
 



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:38.

Layout Options | Width: Wide Color: