Mark all PMs as read (queries)

[Jake Bunce]

Jake Bunce submitted a new resource:

Mark all PMs as read (queries) (version 1.x) - Sometimes useful after an import.

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

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;

Read more about this resource...