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

Jake Bunce

XenForo moderator
Staff member
#1
Jake Bunce submitted a new resource:

Mass prune all PMs (queries) (version 1.x) - Queries to delete all PMs for all users.

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.
Read more about this resource...
 

Cal

Well-known member
#3
Jake...excuse this question....but how do we run these queries? Are we doing this in PHPMYADMIN.....or is there a super secret debug area of Xen I don't know about....or what?