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

How Do I Unfollow Everyone?

Discussion in 'XenForo Questions and Support' started by DRE, May 14, 2013.

  1. DRE

    DRE Well-Known Member

    At the same time?
  2. Chris D

    Chris D XenForo Developer Staff Member

    Yeah the query is:

    DELETE FROM `xf_user_follow` WHERE `user_id`='1';
    Replace 1 with your user_id.

    But you will also need to do this query:

    UPDATE `xf_user_profile` SET `following`='' WHERE `user_id`='1';
    14DH01, Sheratan and DRE like this.
  3. DRE

    DRE Well-Known Member

    Thanks Chris!!!
  4. Stormlilly

    Stormlilly Member


    How would I go about clearing the follow and / or unfollow for all members?
  5. Chris D

    Chris D XenForo Developer Staff Member

    Exactly the same as my queries above, but you just remove the WHERE clauses.
    Stormlilly likes this.
  6. Stormlilly

    Stormlilly Member

    thanks Chris xx
  7. rwm1962

    rwm1962 Active Member

    I've just tried this for all users without the 'where' clause & the followers remained.

    I just did it via phpmyadmin. Is that the right place to do it? Anything else I need to do?

    (for info - post import into XF a lot of my users are followed or are following. We don't have a 'follow' system on our old platform so this may confuse a few members so I want all clearing out while I decide if it's a feature we're going to use or remove via add-on.)
  8. Chris D

    Chris D XenForo Developer Staff Member

    Did you run the second query?
  9. rwm1962

    rwm1962 Active Member

    Aye, I did.

    I tried:
    UPDATE `xf_user_profile` SET `following`=''
    UPDATE `xf_user_profile` 
  10. Chris D

    Chris D XenForo Developer Staff Member

    That one is correct.
    This one might need:
  11. rwm1962

    rwm1962 Active Member

    Thanks for the update. Unfortunately I still have followers listed:

  12. electrogypsy

    electrogypsy Active Member

    i would like to remove all followers for all users as well. can someone post the sql query that works for this? thanks!

Share This Page