A user had a copyrighted image in their avatar, so I edited their profile and hit the 'no avatar' button. It said -
UPDATE ubbt_USER_PROFILE SET USER_EXTRA_FIELD_1 = '' , USER_EXTRA_FIELD_2 = '', USER_EXTRA_FIELD_3 = '' , USER_EXTRA_FIELD_4 = '' , USER_EXTRA_FIELD_5 = '' , USER_CUSTOM_TITLE = '' , USER_NAME_COLOR = '' , USER_REAL_EMAIL = 'user@domain.com' , USER_DISPLAY_EMAIL = 'user@domain.com' , USER_LOCATION = 'Pittsburgh, PA' , USER_OCCUPATION = 'Gamer' , USER_HOBBIES = '' , USER_HOMEPAGE = '' , USER_SIGNATURE = '' , USER_DEFAULT_SIGNATURE = '' , USER_ICQ = '' , USER_YAHOO = '' , USER_MSN = '' , USER_AIM = 'Rumi x Kon' , USER_PUBLIC_BIRTHDAY = 1 , USER_TIME_FORMAT = 'm/d/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 = 4090
Out of range value adjusted for column 'USER_AVATAR_WIDTH' at row 1
This is on my lisashea.com forum which I just upgraded a few days ago.
