Since EasySocial laks few options we may need i was thinking about opening a discussion here for grouping together all the useful queries we may use in some cases.
Note: These SQL queries should be run inside phpMyAdmin directly inside the targeted database. Use them at your own risk and ALWAYS backup your database before running a custom query
1. Delete all Easy Social user posts for a specific user id
* replace "jos_" with your own table prefix.
Some other queries i need
2. Delete all EasySocial posts older than X days or months
3. Delete all EasySocial notifications older than x days or months
* it would be useful 2 types of queries one for "older then X days" and another one for "older than x months"
Any tip ? Thanks !
Note: These SQL queries should be run inside phpMyAdmin directly inside the targeted database. Use them at your own risk and ALWAYS backup your database before running a custom query
1. Delete all Easy Social user posts for a specific user id
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"* replace "jos_" with your own table prefix.
Some other queries i need
2. Delete all EasySocial posts older than X days or months
3. Delete all EasySocial notifications older than x days or months
* it would be useful 2 types of queries one for "older then X days" and another one for "older than x months"
Any tip ? Thanks !