UPDATE ubbt_USER_PROFILE SET USER_EXTRA_FIELD_1 = '10 so far' , USER_EXTRA_FIELD_2 = 'myuser', USER_EXTRA_FIELD_3 = 'here and there' , USER_EXTRA_FIELD_4 = 'my own' , USER_EXTRA_FIELD_5 = '' , USER_CUSTOM_TITLE = '' , USER_NAME_COLOR = '' , USER_REAL_EMAIL = 'myemail@myemail.com' , USER_DISPLAY_EMAIL = 'myemail@myemail.com' , USER_LOCATION = 'usually in the kitchen' , USER_OCCUPATION = 'full time mom' , USER_HOBBIES = 'just about everything' , USER_HOMEPAGE = '' , USER_SIGNATURE = 'x' , USER_DEFAULT_SIGNATURE = 'x' , USER_ICQ = '' , USER_YAHOO = '' , USER_MSN = '' , USER_AIM = '' , USER_PUBLIC_BIRTHDAY = 0 , USER_TIME_FORMAT = 'd/m/y | h:i A' , USER_TIME_OFFSET = '0' , USER_TOPIC_VIEW_TYPE = 'flat' , USER_TOPICS_PER_PAGE = '10' , USER_POSTS_PER_TOPIC = '10' , USER_SHOW_SIGNATURES = 'yes' , USER_VISIBLE_ONLINE_STATUS = 'yes' , USER_ACCEPT_PM = 'yes' , USER_NOTIFY_ON_PM = 'On' , USER_FLOOD_CONTROL_OVERRIDE = '-1' , USER_AVATAR = '',USER_AVATAR_WIDTH= '' ,USER_AVATAR_HEIGHT= '' WHERE USER_ID = '3'
Incorrect integer value: '' for column 'USER_AVATAR_WIDTH' at row 1