The Arcive of Official vBulletin Modifications Site.

Error when Updating "Your Settings" In the arcade · **Released**: 02-23-2007

I am receving an error when I attempt to update My Settings in the arcade. It is a MySQL Error;

mySQL query error: UPDATE user SET user_sort='0',user_order='0',user_g_pp='0',user_s_ pp='0',def_g_cat='',game_skin= '',arcade_pmactive='1' WHERE userid=1

mySQL error: Incorrect integer value: '' for column 'def_g_cat' at row 1
mySQL error code:
Date: Friday 23rd 2007f February 2007 01:12:55 PM

That is the error I receive.

Any Suggestions?
Thanks!

This occurs when updating ANY settings...

MrZeropage · #2 02-24-2007, 05:09 AM

Thank you, fixed this (and anther) bug for v2.6.0+

Strange that nobody mentioned this before

Evoix_mr2006 · #3 02-24-2007, 10:11 PM

Just realized that I get this error when attempting to create a tournament...

mySQL query error: INSERT INTO tournaments
(gid,numplayers,datestarted,demare,creat,plibre,nb tries,cost) VALUES
('1','2','1172361745','0','EvoIX_MR2006','1','2',' 0')

mySQL error: Field 'champion' doesn't have a default value
mySQL error code:
Date: Saturday 24th 2007f February 2007 06:02:25 PM

Any Idea why this may be occuring? Is this another programming issue?

Any help is appreicated,
Thanks!

MrZeropage · #4 02-25-2007, 02:26 PM

this is fixed in upcoming v2.6.0+

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03610 seconds Memory Usage 2,223KB Queries Executed 19 (?)
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 (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (3)postbit (4)postbit_onlinestatus (4)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_postinfo_query fetch_postinfo 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 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!