The Arcive of Official vBulletin Modifications Site.

Error on Group Permissions · **Released**: 12-04-2006

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 · #2 12-04-2006, 08:01 PM

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

Johnnnie · #3 12-04-2006, 09:43 PM

Quote:

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 · #4 12-07-2006, 02:16 AM

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

Kind regards,
John

kap123 · #5 12-11-2006, 10:36 PM

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 · #6 12-12-2006, 09:53 AM

Quote:

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 · #7 12-12-2006, 01:06 PM

Thanks Johnnnie!

I'll check back later.

MrZeropage · #8 12-13-2006, 08:08 AM

@Johnnnie:
you have PM

I tried to fix both things you mentioned above ...

kap123 · #9 12-13-2006, 01:40 PM

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 · #10 12-13-2006, 03:55 PM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07496 seconds Memory Usage 2,288KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!