The Arcive of Official vBulletin Modifications Site.

Database Error · **Released**: 03-04-2007

Hello,

I have yet to experience this error, but my friend e-mailed me saying he got this error after completeing a game and going to save his score.

"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 04th of March 2007 04:01:05 PM"

He didn't tell me exactly what game, but it is possible that this error would be game specific? Is it possible this is due to the vB 3.6.5 upgrade? Could it be on his machine only, since no one else at my forum has seen it? I appreciate what you guys have to say.

MrZeropage · #2 03-05-2007, 05:26 AM

It seems he does not have a gamesession saved in his userprofile, which means he tries to cheat or did call the game directly (.swf) ?

He should try again ... and make sure to log into the forum and use the arcade-mainpage to start a game

Link00seven · #3 03-06-2007, 01:29 AM

Appearently other people are starting to get it too. Should I reinstall the arcade? Could it be game specific? A possible host issue? What are some things I can try to fix this issue?

Thanks

MrZeropage · #4 03-06-2007, 05:19 AM

I think the games are the problem - what about the standard-games that come along with the arcade ?

You have ibProArcade v2.6.1+ ?

Link00seven · #5 03-06-2007, 09:33 AM

I heard that it happened once on one of the standard games, however it seems that its mostly the games that I've installed since. I reinstalled the arcade and things seem to be working, and let out a notice on my forum to let me know of any errors.

S1OPP · #6 03-07-2007, 08:34 PM

Some of my users is getting this error too. I only have the standard games installed, so far it's happened on Asteroids and Space Invaders.

kylek · #7 03-20-2007, 02:59 AM

And pacman, getting reports from members that get it while submitting high scores to poacman.

hambil · #8 03-20-2007, 03:23 AM

I am getting this error also on a clean install of vb3.6.5 and ibProArcade v2.6.1+

MrZeropage · #9 03-20-2007, 07:30 PM

Please provide AdminCP+FTP access via PM so I can have a closer look on this ...

MrZeropage · #10 03-25-2007, 06:54 PM

Ok, I checked the code and now need somebody who actually has this problem and is able to reproduce it.

Please contact me via AdminCP as I need to find the place in the code where this happens...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04192 seconds Memory Usage 2,279KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!