XF 1.1 Change all avatars to default

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:

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
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.