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

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

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

Kind regards,
John

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!

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

Thanks Johnnnie!

I'll check back later.

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

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

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