Mark all PMs as read (queries)

[Jake Bunce]

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;

 

[GregF]

Thanks for this Jake, just run it on my imported MyBB forum and it worked perfectly

 

[Floris]

I've used this about a gazillion times already with converts. Thanks Jake.

 

[yavuz]

How would we delete all PC with a query?

 

[Jake Bunce]

How would we delete all PC with a query?

http://xenforo.com/community/threads/imported-conversations.12467/#post-164602