Mark all PMs as read (queries)

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

You can run these queries on your database to mark all PMs as read:

Code:

UPDATE xf_conversation_recipient
SET last_read_date = UNIX_TIMESTAMP();

UPDATE xf_conversation_user
SET is_unread = 0;

UPDATE xf_user
SET conversations_unread = 0;

Backup first.