Hello Romagromov,

Unfortunately there is no tools or settings to clean up old message from easysocial conversation. However you can perform the operation manually via your database by running the delete operation from #_social_conversations_message where conversation_id = the message id and created > 1 year or older. Other than that unfortunately it is not possible with the current system.

Hope you understand

how looks this sql request?

Hello,

The SQL will be like this:
delete from #__social_conversations_message where created <= DATE_SUB(now(), INTERVAL 365 DAY);

But I'm afraid by deleting this will affect other associate table. But you can try though.

I want to bump this topic again because after migrating to ES this tool is would be really needed.

Hello Guido,

Not sure what do you mean. Do you mean you want to reset your migrated data? Wouldn't that remove your existing data?

No but after migration I have also tons of messages that were written long time ago by not active users anymore. It would be very nice to clean messages that are e.g. older than a year. Is the query above still enough or could it break something?

Yes, it will delete any messages older than 365 days ago but do take note that it might affect other tables as well.