• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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).