Following an import from vB is there any easy way (or an SQL query) I can run to remove every user's followed and followers from their profiles please?
UPDATE xf_user_profile SET following = ''; TRUNCATE TABLE xf_user_follow;
DELETE FROM `xf_user_follow` WHERE `user_id` = 1 OR `follow_user_id` = 1
Yorick's query will work for the normalized data. But with selective removals like this you will need to rebuild the denormalized data in xf_user_profile.following which can't be done with a simple query. A custom script is required.How do I remove all followers and following for a particular user (which passed away)?