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

mass mark pm as read

Discussion in 'XenForo Questions and Support' started by majdi, Feb 23, 2011.

  1. majdi

    majdi Well-Known Member

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

    Brogan XenForo Moderator Staff Member

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

    Jake Bunce XenForo Moderator Staff Member

    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.
  4. DSF

    DSF Well-Known Member

    But don't forget the ";" [​IMG]
    Jake Bunce likes this.
  5. Floris

    Floris Guest

    Awesome Jake, this came in handy today.
  6. Bellinis

    Bellinis Active Member

    How can I delete all Private Conversations from user x?

Share This Page