R rbecking Member Mar 10, 2012 #1 I've converted from vbulletin 3.8 to xenforo, users custom avatars have imported but they look rubbish as small on vb and been stretched. Is it possible to change all users to default avatar?
I've converted from vbulletin 3.8 to xenforo, users custom avatars have imported but they look rubbish as small on vb and been stretched. Is it possible to change all users to default avatar?
Jake Bunce Well-known member Mar 10, 2012 #2 Run this query on your database: Code: UPDATE xf_user SET avatar_date = 0, avatar_width = 0, avatar_height = 0; Then delete the contents of the data/avatars directory on the server. Upvote 0 Downvote
Run this query on your database: Code: UPDATE xf_user SET avatar_date = 0, avatar_width = 0, avatar_height = 0; Then delete the contents of the data/avatars directory on the server.
R rbecking Member Mar 10, 2012 #3 Thanks for this, fairly new to this how do you run query on database? Upvote 0 Downvote
Jake Bunce Well-known member Mar 10, 2012 #4 You can use phpmyadmin which many hosts preinstall for you in your hosting control panel, like CPanel or Plesk. Upvote 0 Downvote
You can use phpmyadmin which many hosts preinstall for you in your hosting control panel, like CPanel or Plesk.
R rbecking Member Mar 10, 2012 #5 when I run the query in phpadmin it says "You have to choose at least one column to display" Upvote 0 Downvote
Jake Bunce Well-known member Mar 10, 2012 #6 In phpmyadmin you need to: 1) Select your database in the left column. 2) Click the SQL tab on the right. Paste the query in there. Upvote 0 Downvote
In phpmyadmin you need to: 1) Select your database in the left column. 2) Click the SQL tab on the right. Paste the query in there.