Error on Group Permissions

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]

Originally Posted by MrZeropage

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]

Originally Posted by 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).

------------------------
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