Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 06 Apr 2007, 21:51
wolf32 wolf32 is offline
 
Join Date: Jan 2007
Real name: Wolf
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???
Comments
  #2  
Old 06 Apr 2007, 22:25
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
this bug for guests is fixed for upcoming v2.6.2+

It only appears if guests prevent cookies to be saved
__________________
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
  #3  
Old 07 Apr 2007, 13:39
bolly.beats's Avatar
bolly.beats bolly.beats is offline
 
Join Date: Aug 2006
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: Saturday 07th of April 2007 07:36:26 AM


I am the admin and i m getting this msg.
  #4  
Old 08 Apr 2007, 02:05
wolf32 wolf32 is offline
 
Join Date: Jan 2007
Real name: Wolf
Originally Posted by MrZeropage View Post
this bug for guests is fixed for upcoming v2.6.2+

It only appears if guests prevent cookies to be saved
Oh, gotcha. Any idea for a release date?
  #5  
Old 08 Apr 2007, 07:21
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
@bolly.beats:
You get this everytime ?

@wolf32:
"when it's done"
But not that far in the future, just doing some more fixes and then it will be here ...
__________________
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
  #6  
Old 12 Apr 2007, 07:39
winsoftware winsoftware is offline
 
Join Date: Jul 2006
i also found this bug. my registered user told me about this bug too.
  #7  
Old 12 Apr 2007, 15:59
milsirhc's Avatar
milsirhc milsirhc is offline
 
Join Date: Jan 2007
yea, i played as registered user and I got this error still.. =(
  #8  
Old 16 Apr 2007, 21:41
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
can anybody reproduce this error with registered user ?
If so, please setup an account for me on your forum and send me the login-data via PM and tell me how to reproduce it... thanks
__________________
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
  #9  
Old 17 Apr 2007, 07:15
winsoftware winsoftware is offline
 
Join Date: Jul 2006
i dont know how to reproduce it. it dont get this error, but more and more user are telling me about it.
  #10  
Old 18 Apr 2007, 13:34
DaMaK DaMaK is offline
 
Join Date: Oct 2006
i get the error at work....at home i dont get the error. using same account and i am admin.
  #11  
Old 18 Apr 2007, 22:33
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
Hmmm, what is the difference ?

Browser ?
Cookie-Protection/Blocker ?
Firewall ?


@winsoftware:
can any of those users reproduce the error ?
__________________
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
  #12  
Old 24 Apr 2007, 12:02
winsoftware winsoftware is offline
 
Join Date: Jul 2006
no they can't. they haven't got this error all the time.
  #13  
Old 24 Apr 2007, 22:02
qcho qcho is offline
 
Join Date: Apr 2007
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
  #14  
Old 25 Apr 2007, 09:10
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
@qcho:
even admin ? Well, please provide AdminCP+FTP access so I can have a look ...
__________________
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
  #15  
Old 26 Apr 2007, 02:05
sparky5693 sparky5693 is offline
 
Join Date: Feb 2007
Having this problem on my forum also, but it appears to happen at random.
 



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

Layout Options | Width: Wide Color: