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

Mass prune all PMs (queries)

Queries to delete all PMs for all users.

  1. Jake Bunce
    Run these queries to delete all PMs for all users.

    Code:
    TRUNCATE TABLE xf_conversation_master;
    TRUNCATE TABLE xf_conversation_message;
    TRUNCATE TABLE xf_conversation_recipient;
    TRUNCATE TABLE xf_conversation_user;
    UPDATE xf_user SET conversations_unread = 0;
    
    Backup first.
    Alien, HWS, maszd and 4 others like this.

Recent Reviews

  1. resonansER
    resonansER
    5/5,
    Thank YOU! Really, very useful.
  2. alkahf
    alkahf
    5/5,
    Excellent
  3. Adam Howard
    Adam Howard
    5/5,
    So very useful. I make it a point to do this at least 1 - 2x a year. Users seem to save those things (can't imagine why).