Error on Group Permissions

[Johnnnie]

MrZeropage there are 2 unread Pms 23nov and 2dec.

As i started with vs. 2.5.7 it is not posseble to set Group Permissions and then ofcourse not possible to play anyway. Get this error:

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

mySQL error: Incorrect integer value: '' for column 'tourney' at row 1
mySQL error code:
Date: Sunday 03rd of December 2006 06:22:51 PM

Now i have update to vs. 2.5.8 still same problem.
I have read other topics related this problem, where is say' that this problem was fixed.........

Sorry on my (very clean)board the fix seems not to work.

Can you help me

[MrZeropage]

please contact me via PM and tell me your mailaddress there, I will send you another try to fix this finally ;)

[Johnnnie]

please contact me via PM and tell me your mailaddress there, I will send you another try to fix this finally ;)

PM sent

Thx.
John

[Johnnnie]

after this there was no solution, send email with full ftp and admincp detals :)

Kind regards,
John

[kap123]

Was this ever resolved?

I just installed 2.5.8 about an hour ago...install seems to all be working correctly except I can't finish the final step which is setting 'Group Permissions'. I get this error (same as above).

------------------------

mySQL query error: UPDATE vb_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: Monday 11th 2006f December 2006 07:27:45 PM

------------------------

I'm not great at reading errors and code, but seems like SQL doesn't like that 'tourney' is passing no value ' '. ??? I've read the other threads on this same error and none of the fixes have worked.

Any help would be greatly appreciated. Thanks!

__________________________________________________ _____________

Found one more error that may be tied to the above error. When I try to create a tournament I get the following:

-------------------------

mySQL query error: INSERT INTO vb_tournaments
(gid,numplayers,datestarted,demare,creat,plibre,nb tries,cost) VALUES
('1','8','1165884796','0','Fuller','7','3','0')

mySQL error: Field 'champion' doesn't have a default value
mySQL error code:
Date: Monday 11th 2006f December 2006 07:53:16 PM

-------------------------

Thanks again!

[Johnnnie]

Was this ever resolved?

I just installed 2.5.8 about an hour ago...install seems to all be working correctly except I can't finish the final step which is setting 'Group Permissions'. I get this error (same as above).

------------------------
Thanks again!

No problem is still there, nothing heard from Mrzeropage i think he's on holliday for some time......:)

[kap123]

Thanks Johnnnie!

I'll check back later.

[MrZeropage]

@Johnnnie:
you have PM :)
I tried to fix both things you mentioned above ...

[kap123]

MrZeropage - it seems I am having the same / similar problem.

If you could shoot me the PM as well or let me know what we need to do it would be much appreciated :)

thx

[MrZeropage]

I wait for feedback now if that helped, don't want to test several things on different installations

[Johnnnie]

I wait for feedback now if that helped, don't want to test several things on different installations

With the new arcade.php you've send me...

When i click the button Group Permissions this error comes:

Parse error: parse error in F:\Forums\GC-Talk\admincp\arcade.php on line 587

[MrZeropage]

re-upload the file please I have no error here :)

[Johnnnie]

re-upload the file please I have no error here :)

Done it again, it's the same..... Please check in my admincp

Done it again, it's the same..... Please check in my admincp

I have got a new fix from MrZeropage, it is now possible to save settings in Group permissions.

Many Thx.
John

[kap123]

Hi guys, I am still getting this error... Actually now I get a new error after trying to upload the revised arcade.php that was sent to Johnnie...

I also re-loaded the original arcade.php and tried again... still getting this error:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\..poker-forum\admincp\arcade.php on line 3872

Any help getting this arcade installed would be much appreciated. At first we only had the same problem as Johnnie, trying to put in the fixes seems to have done something else.

any / all help appreciated.

[Johnnnie]

Hi guys, I am still getting this error... Actually now I get a new error after trying to upload the revised arcade.php that was sent to Johnnie...

I also re-loaded the original arcade.php and tried again... still getting this error:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\..poker-forum\admincp\arcade.php on line 3872

Any help getting this arcade installed would be much appreciated. At first we only had the same problem as Johnnie, trying to put in the fixes seems to have done something else.

any / all help appreciated.

Do you also use MySql 5.x ? i'am waiting for an fix from MrZeropage....

[jiffy]

I need a fix for this too. Same exact problem when I try to edit the usergroup permissions. One board is brand new and the other was upgraded from 2.5.7 and it gets the same error but at least it functions since the permissions are just stuck where they were before the upgrade. Any help would be great.

[jonty]

Similar problem
mySQL error: Incorrect integer value: '' for column 'tourney' at row 1

mySQL 5 is being used (an increasing common problem :( )

[kap123]

Do you also use MySql 5.x ? i'am waiting for an fix from MrZeropage....


Yes: am running WIN 2003 Server, PHP Version 5.1.2, MySQL Server 5.0

Still getting errors... seems i'm not the only one.

[MrZeropage]

ibProArcade v2.5.9+ will fix this, coming soon