By Mel on Monday, 01 April 2019
Posted in General
Replies 1
Likes 0
Views 521
Votes 0
Hi,

I want to delete a pile of events and groups (particularly past events) as have over 7k but it isn't so easy to do in the backend (yet).

So my plan is to use an SQL query for now to search for i.e. past events over 7 days old and delete them. However i have gone through all the tables and cannot find anything like group posts or event posts (or something that suggests the records).

Are you able to tell me which tables they are?

I have posted a features request to have some kind of method to purge/delete past events after x number of days.

Unfortunately we can't sort on past events (yet) in backend otherwise could do that manually every so often.

Any advice would be greatly appreciated.

Mel
Hi Mel,

Firstly, I would not really recommend to delete data directly from database as an event/groups has been sync with various places. Basically the event/group can be find in the table #__social_clusters table where you can sort by cluster_type event/group
·
Tuesday, 02 April 2019 10:16
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post