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

Discussion in 'XenForo Questions and Support' started by rbecking, Mar 10, 2012.

  1. rbecking

    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?
     
  2. Jake Bunce

    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.
     
    BamaStangGuy likes this.
  3. rbecking

    rbecking Member

    Thanks for this, fairly new to this how do you run query on database?
     
  4. Jake Bunce

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

    rbecking Member

    when I run the query in phpadmin it says "You have to choose at least one column to display"
     
  6. Jake Bunce

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

    rbecking Member

    Cheers, all sorted. thanks for your help.
     

Share This Page