XF 1 Tip Mass prune all PMs (queries)

[ENXF NET]

LQD submitted a new resource:

Mass prune all PMs (queries) - 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;

Read more about this resource...