How Do I Unfollow Everyone?

[DRE]

At the same time?

 

[Chris D]

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';

 

[DRE]

Thanks Chris!!!

 

[Stormlilly]

Hiya,

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

 

[Chris D]

Exactly the same as my queries above, but you just remove the WHERE clauses.

 

[Stormlilly]

thanks Chris xx

 

[rwm1962]

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

 

[Chris D]

Did you run the second query?

 

[rwm1962]

Aye, I did.

I tried:

UPDATE `xf_user_profile` SET `following`=''

&

UPDATE `xf_user_profile`

 

[Chris D]

UPDATE `xf_user_profile` SET `following`=''

That one is correct.
This one might need:

DELETE FROM `xf_user_follow` WHERE `user_id` > 0

 

[rwm1962]

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

 

[electrogypsy]

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