• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Mark all PMs as read (queries)

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;
Backup first.
Jake Bunce
First release
Last update
5.00 star(s) 3 ratings

More resources from Jake Bunce

Latest reviews

Great! Very useful after an import!
Very important stuff.