[FIXED for 7.2] Can't delete a user's avatar in the control panel

Print Thread

Hop To

#184355 05/17/2007 11:53 AM

Joined: Feb 2007

Posts: 57

Shane

journeyman

Shane

journeyman

Joined: Feb 2007

Posts: 57

After importing from UBB Classic, some people had invalid avatars (I don't know why). Trying to remove these using the Member Management section of the control panel returned the following error:

Code

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

RnJpZW5kc2hpcCB3aXRoIHRoZSB3b3JsZCBpcyBob3N0aWxpdH
kgdG93YXJkcyBHb2QuICBKYW1lcyA0OjQ=

Re: Can't delete a user's avatar in the control panel Shane #184364 05/17/2007 12:33 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	It looks like your mysql server is running in strict mode. I'm still cleaning things up so it doesn't bark about these errors, but you can take your mysql server out of strict mode by running the following SQL command: SET GLOBAL SQL_MODE='';

Re: Can't delete a user's avatar in the control panel Rick #184367 05/17/2007 12:38 PM
Joined: Feb 2007 Posts: 57 Shane journeyman
Shane journeyman Joined: Feb 2007 Posts: 57	That's probably why it wouldn't import forums without categories assigned to them. Thanks! RnJpZW5kc2hpcCB3aXRoIHRoZSB3b3JsZCBpcyBob3N0aWxpdH kgdG93YXJkcyBHb2QuICBKYW1lcyA0OjQ=

Re: Can't delete a user's avatar in the control panel Shane #184368 05/17/2007 12:43 PM
Joined: Feb 2007 Posts: 57 Shane journeyman
Shane journeyman Joined: Feb 2007 Posts: 57	It doesn't work. I executed the SQL command on the server (the MySQL Command Line Client); it accepted it without a problem. But the error persists. RnJpZW5kc2hpcCB3aXRoIHRoZSB3b3JsZCBpcyBob3N0aWxpdH kgdG93YXJkcyBHb2QuICBKYW1lcyA0OjQ=

Re: Can't delete a user's avatar in the control panel Shane #185222 05/30/2007 5:03 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	This is something I'm patching up for 7.2. So instead of inserting a blank which some installs of MySQL won't accept, it will insert a 0. This is a quick fix by editing admin/changeuser.php. Line 171 of that file has these 2 lines: $imagewidth = ""; $imageheight = ""; Change those, to this: $imagewidth = "0"; $imageheight = "0";

Link Copied to Clipboard

UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Fixed Bugs [FIXED for 7.2] Can't delete a user's avatar in the control panel