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

Mass prune all PMs (queries)

Run these queries to delete all PMs for all users.

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.
Jake Bunce
First release
Last update
5.00 star(s) 3 ratings

More resources from Jake Bunce

Latest reviews

Thank YOU! Really, very useful.
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).