• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Change all avatars to default

#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?
 

Jake Bunce

XenForo moderator
Staff member
#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.
 

Jake Bunce

XenForo moderator
Staff member
#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.