Resource icon

Mass prune all PMs (queries)

Jake Bunce

XenForo moderator
Staff member
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.

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


Well-known member
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?