Hi Fidel Carrera,
To be honestly said, deleting old conversation is quite tedious to be done as it related to a few of table in database
Lets start a simple step to understands this:
1. When a conversation was created it involve these 4 table
( #_social_conversations_message, #_social_conversations, #_social_conversations_message_maps, #_social_conversations_participants)
2. Let we make an example to delete 1(one) conversation first. as user create an message in #_social_conversation will create/generate a row of data (refer img 1) with an conversation_id (for this example - 7) and some other data like message that has been typed, when it created and created_by(user that send the conversation)
3. In #_social_conversations table as well will create a row of data (refer img 2)
4. In #_social_conversations_message_maps will generate 2 row of data ( one for sender and receiver) with same conversation_id as no.2 (refer img 3)
5. And in #_social_conversations_participants it will also create 2 row of data (sender and receiver) (refer img 4)
So in order to delete a single conversation make sure you deleting the respective message in respective tables
P/S: We
STRONGLY suggest you to
BACKUP your site database in order to do these steps. Or do this on staging state first.