mass mark pm as read

[majdi]

i want to mark all pm as read
is there an option for it ?

 

[Paul B]

There is no option for that but I believe it has been suggested.

 

[Jake Bunce]

I came up with these queries for you. You can run these queries on your database to mark all PMs as read:

(added semicolons per DSF's post):

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;

I tested this and it works. But you should backup first to be safe.

 

[DSF]

But don't forget the ";"

 

[Floris]

Awesome Jake, this came in handy today.

 

[Bellinis]

How can I delete all Private Conversations from user x?

 

[Dubbed Navigator]

@Jake Bunce - does this work with XF2?

 

[Chris D]

I can confirm that - very few changes to Conversations overall.

 

[torontotim]

I just did this on a fresh SMF 2 import > XF1.5 upgraded to XF2 with 130,000 old Private Messages. I had 3000+ myself 'unread' after the conversion.

Executed the SQL above and all seems fine. No unread messages.

 

[parafly9]

I came up with these queries for you. You can run these queries on your database to mark all PMs as read:

(added semicolons per DSF's post):

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;

I tested this and it works. But you should backup first to be safe.

Does this mark as read for every single user?

And to confirm (bc this is from 2011), this applies to xf2.2?

 

[Cupara]

Even though this is old the queries advice should still work.

 

[Painbaker]

Here is it (paid add-on):

[OzzModz] Mark All Conversations

Mark all conversations as read, unread, starred or unstarred. implemented with XF's job manager so has not performance impact with large amount of conversations. Conversation permissions:

xenforo.com