DB query to delete stream items for specific user
By Mist on Wednesday, 12 March 2014
Posted in Tips & Tricks (Not Supported)
Likes 0
Views 1.1K
Votes 0
Can you guys help me out with a database query that i can run inside phpmyadmin in order to delete the EasySocial stream items for a specific user id ?

We are in development process and we generated a lot of stream items with a specific user and we want to purge those items all-at-once.
Having to delete them manually takes ages since we are dealing with couple of hundreds of items.

Thanks in advance for any tip !
Hello Mist,

You will need to run the following sql queries to delete the user's posts 



delete from jos_social_stream where actor_id="REPLACE_WITH_USER_ID" and actor_type="user"

delete from jos_social_stream_item where actor_id="REPLACE_WITH_USER_ID" and actor_type="user"
Mark
·
Thursday, 13 March 2014 01:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Working great. Thanks Mark !

Just a quick tip for anybody else wanted to do the same thing and is using the query Mark provided.
Replace "jos_" with your own table prefix. Wanted to just let you know so you don't run into troubles.
Mist
·
Thursday, 13 March 2014 06:49
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome
Mark
·
Thursday, 13 March 2014 10:37
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post