• 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)

Sometimes useful after an import.
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.
Author
Jake Bunce
First release
Last update
Rating
5.00 star(s) 3 ratings

More resources from Jake Bunce

Latest reviews

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