XF 1.1 Change all avatars to default

rbecking

Member
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
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
You can use phpmyadmin which many hosts preinstall for you in your hosting control panel, like CPanel or Plesk.
 

Jake Bunce

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