Mass prune all PMs (queries)

[Bi0S Emerald Member Posts:12,183 Threads:12,128 Reputation 31]

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.