XF 2.0 SQL Query to mass delete conversations?

[CoreIssue]

My PhpAdmin will only do 50 max.

 

[Paul B]

If you want to irrevocably delete the conversation content, you can truncate/empty the related tables.

Make sure you take a backup first, just in case of any issues.

 

[Ozzy47]

This may still work, https://xenforo.com/community/threads/imported-conversations.12467/#post-164602

 

[CoreIssue]

TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

SQL Works

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/delete-conversations.6196/

 

[Ozzy47]

You might like this add-on:

https://xenforo.com/community/resources/delete-conversations.6196/

Why? It was done with simple queries.

 

[Ozzy47]

TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

SQL Works

Glad that worked for you.