Resource icon

Mass prune all PMs (queries)

Run these queries to delete all PMs for all users.

Code:
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;
Backup first.
Author
Jake Bunce
First release
Last update
Rating
5.00 star(s) 3 ratings

More resources from Jake Bunce

Latest reviews

Thank YOU! Really, very useful.
Excellent
So very useful. I make it a point to do this at least 1 - 2x a year. Users seem to save those things (can't imagine why).
Top