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

  1. Jake Bunce
    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.
    Chris D and Fuhrmann like this.

Recent Reviews

  1. MsJacquiiC
    MsJacquiiC
    5/5,
    Thanks!
  2. Sukrams
    Sukrams
    5/5,
    Great! Very useful after an import!
  3. Fuhrmann
    Fuhrmann
    5/5,
    Very important stuff.