Games permissions help...ibProArcade.

[LILMORA4]

When I try to play a game, I get this.
Board Message
Sorry, an error occurred. If you are unsure on how to use a feature, or don't know why you got this error message, try looking through the help files for more information.

The error returned was:

The administrator has disabled playing games for your usergroup.
So I go into the admin panel and set permissions, and get this.

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned


mySQL query error: UPDATE usergroup SET arcade_access='1',p_require='0',max_play='0',ppd_r equire='0',ibpa_cats='0',tourney='' WHERE usergroupid=1

mySQL error: Incorrect integer value: '' for column 'tourney' at row 1
mySQL error code:
Date: Tuesday 26th 2006f September 2006 02:14:50 PM

Where did I mess up:(

[MrZeropage]

Seems to be a little issue I now fixed for v2.5.7+

try this query as workaround:
UPDATE usergroup SET tourney=1

after this you should be able to setup the correct permissions ...

[LILMORA4]

Seems to be a little issue I now fixed for v2.5.7+

try this query as workaround:
UPDATE usergroup SET tourney=1

after this you should be able to setup the correct permissions ...
Where exactly should I find this? In user groups?

[LILMORA4]

Query doesnt work...

Seems to be a little issue I now fixed for v2.5.7+

try this query as workaround:
UPDATE usergroup SET tourney=1

after this you should be able to setup the correct permissions ...

[MrZeropage]

thought of table_prefix ? ;)

[LILMORA4]

thought of table_prefix ? ;)
No! Have no clue--help me...

[Robru]

This my error, even when I have use this query as workaround:
UPDATE usergroup SET tourney=1


mySQL query error: UPDATE usergroup SET arcade_access='1',p_require='0',max_play='0',ppd_r equire='0',ibpa_cats='0',tourney='' WHERE usergroupid=1

mySQL error: Incorrect integer value: '' for column 'tourney' at row 1
mySQL error code:
Date: Saturday 07th 2006f October 2006 05:29:38 PM

What's the solution?

[LILMORA4]

I'm still waiting as well^^

[MrZeropage]

the query just solves the problem for the moment, the correct fix is included in v2.5.7+

seems like sometimes it does not pass the correct value to the query in v2.5.6+ ...

[LILMORA4]

Is the 2.5.7 version avaliable?

[Robru]

I have with v2.5.7+ the same error with the permissions:

mySQL query error: UPDATE usergroup SET arcade_access='0',p_require='0',max_play='0',ppd_r equire='0',ibpa_cats='0',tourney='' WHERE usergroupid=1

mySQL error: Incorrect integer value: '' for column 'tourney' at row 1
mySQL error code:
Date: Sunday 29th 2006f October 2006 10:34:24 PM

[LILMORA4]

I have with v2.5.7+ the same error with the permissions:

mySQL query error: UPDATE usergroup SET arcade_access='0',p_require='0',max_play='0',ppd_r equire='0',ibpa_cats='0',tourney='' WHERE usergroupid=1

mySQL error: Incorrect integer value: '' for column 'tourney' at row 1
mySQL error code:
Date: Sunday 29th 2006f October 2006 10:34:24 PM
edit.....2.5.7 works just fine it will solve the above problem.

[MrZeropage]

@Robru:
make sure that /admincp/arcade.php is actual version, then the error is fixed. Maybe re-upload it ...

[jiffy]

I've got this same problem on a fresh install of 2.5.8 on 3.6.4. Any news on a fix?

[AuroraStorm]

I'm waiting for an answer too...

[Madmp3zz]

I'm running vb 3.5.5 with ibProArcade 2.5.8+ and still getting this error.

mySQL query error: UPDATE usergroup SET arcade_access='1',p_require='0',max_play='0',ppd_r equire='0',ibpa_cats='0',tourney='' WHERE usergroupid=1

mySQL error: Incorrect integer value: '' for column 'tourney' at row 1
mySQL error code:
Date: Friday 22nd 2006f December 2006 05:46:22 PM

[jiffy]

Any update on this? I've got a forum that I need to make some permission changes on and I'm stuck until this is fixed.