Random no permission error when submitting score

[NeverBored]

This is happening very randomly as far as I can tell, different people different games of which have accepted their score before or after. It may only happen with ibp games though I cant say for sure it may just be coincidence since I have 100s of ibp games and only the preinstalled v3 games.

[NeverBored]

No ideas, eh?

[Mario]

Did you try my suggestion here?
http://www.v3arcade.com/forums/showthread.php?t=1741

[NeverBored]

Originally Posted by Mario

Did you try my suggestion here?
http://www.v3arcade.com/forums/showthread.php?t=1741

I'm confused by your solution because the arcade templates have no cache tags by default. Does turning on the no cache option in the vb admin do something more?

[Mario]

Not sure why it works, but it seems like users with IE8 and sometimes IE7 gets this error and as far i can se it have something to do with the new cookie handling in games on the latest arcade.

If you dont want to enable ad no cache, you can force IE to check for new pages every visit that should also solve your problem until a real fix gets released.

Or you can use Firefox i havent got any errors with that one yet.

[imported_Mark.B]

My users have had this problem for years and it's not browser specidic.

I did discover that it is caused by the game ids randomly not getting passed, which actually causes a MySQL error, though because of the way the arcade is coded you get the no permission error instead. I did test this once by commenting out the error call and you do indeed get a MySQL error instead, that's how I know.

I'm not sure if no-cache does fix it but on busy sites that's simply not an option.

[zelnik]

Yup the no-cache definitely fixes it but like you say it really needs an official fix as this can only be a temp fix.

Can we have an official response that this is being dealt with on an upcoming release even if it's not 1.10?

[stump]

Originally Posted by Mario

Or you can use Firefox i havent got any errors with that one yet.

All I use is Firefox and I've got this error today many times over.

[KW802]

For those using FireFox and getting error... by any chance, are you using MySQLi (as opposed to MySQL)?

[stump]

Originally Posted by Kevin

For those using FireFox and getting error... by any chance, are you using MySQLi (as opposed to MySQL)?

No. But it's not limited to Firefox. IE, vista as well.

[imported_Mark.B]

It is browser and OS independent, that much I do know.

As I've said, it's to do with the gameids not being passed into the MySQL string which returns a database error....except that the arcade masks this with a permissions error.

[KW802]

Not necessarily *the* problem, but make sure your session timeout is longer than the amount of time being spent in the game. In other words... if your session timeout in vB is set for 5 minutes and somebody is playing a game for ten minutes, then this problem could also occur.

[NeverBored]

Originally Posted by Kevin

Not necessarily *the* problem, but make sure your session timeout is longer than the amount of time being spent in the game. In other words... if your session timeout in vB is set for 5 minutes and somebody is playing a game for ten minutes, then this problem could also occur.

Hmm, my timeout is 30 minutes

[Brian]

For you guys that have received a database error when this happens, can you post the full error here?

[imported_Mark.B]

These are old so ignore version numbers....these were from a short period when I commented out the relevant vBulletin error in arcade.php to try and debug this problem:

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:
UPDATE arcade_games SET sessioncount=sessioncount+1 WHERE gameid=;
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 '' at line 1
Error Number : 1064
Request Date : Saturday, January 10th 2009 @ 08:52:04 AM
Error Date : Saturday, January 10th 2009 @ 08:52:04 AM
Script : http://www.bowlandcentral.com/forum/arcade.php
Referrer : http://www.bowlandcentral.com/forum/...lay&gameid=511


Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:
UPDATE arcade_games SET sessioncount=sessioncount+1 WHERE gameid=;

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 '' at line 1
Error Number : 1064
Request Date : Thursday, December 25th 2008 @ 01:22:01 AM
Error Date : Thursday, December 25th 2008 @ 01:22:01 AM
Script : http://www.bowlandcentral.com/forum/arcade.php
Referrer : http://www.bowlandcentral.com/forum/...imalrescue.swf


Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE arcade_games SET sessioncount=sessioncount+1 WHERE gameid=;

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 '' at line 1
Error Number : 1064
Request Date : Sunday, November 16th 2008 @ 07:36:53 PM
Error Date : Sunday, November 16th 2008 @ 07:36:53 PM
Script : http://www.bowlandcentral.com/forum/arcade.php
Referrer : http://www.bowlandcentral.com/forum/...ankrobbery.swf

[Brian]

It looks like enabling no cache headers just for a few arcade actions is going to be the way to go here. For those having this issue, you should be able to resolve it by adding a new plugin to the 'init_startup' hook location with the following code:

if (THIS_SCRIPT == 'arcade' AND ($_REQUEST['do'] == 'play' OR $_REQUEST['sessdo'] == 'sessionstart' OR $_REQUEST['sessdo'] == 'burn'))
{
	$vbulletin->options['nocacheheaders'] = 1;
}

[imported_Mark.B]

Thanks...I have implemented this and will monitor things.

[NeverBored]

Originally Posted by Brian

It looks like enabling no cache headers just for a few arcade actions is going to be the way to go here. For those having this issue, you should be able to resolve it by adding a new plugin to the 'init_startup' hook location with the following code:

if (THIS_SCRIPT == 'arcade' AND ($_REQUEST['do'] == 'play' OR $_REQUEST['sessdo'] == 'sessionstart' OR $_REQUEST['sessdo'] == 'burn'))
{
    $vbulletin->options['nocacheheaders'] = 1;
}

Damn, I was excited this morning about this nice little plugin but just had a member get a no permission error.

[stump]

So what else can be done with these errors?

[Mario]

seems to be working fine so far