Resource icon

Mark all PMs as read (queries)

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.
Top