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

Mass PM converted to huge conversation

Discussion in 'General XenForo Discussion and Feedback' started by RobParker, Aug 26, 2013.

  1. RobParker

    RobParker Well-Known Member

    I'm not sure of the best place to post this but thought it was worth mentioning.

    Years ago with VB we used to have a newsletter addon which sent out "newsletters" via PM to all our members.

    Today someone replied to one of those very old PMs...

    Cue a giant conversation including hundreds of users who then replied in confusion causing it to snowball and send loads of email notifications.

    It might be useful to have some kind of PM management (sender lists, not content) in the ACP but I'm not sure how that'd work.
  2. Adam Howard

    Adam Howard Well-Known Member

    I think it would be better if there was away to move a large PM into the forum... ie... convert a pm into a public thread (or into a private forum).
  3. RobParker

    RobParker Well-Known Member

    I think I'd settle for being able to identify them.

    I assume we may have some other PMs floating around which have thousands of users added due to our previous use of the VB newsletter addon but I deleted those PMs years ago and they're not apparent until someone digs one up and replies to it.
  4. Adam Howard

    Adam Howard Well-Known Member

    Well if you just want to delete them. This SQL command will delete all PM's current on your site.

    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;
    That should take care of all the old, large PM's without you having to track them down 1 by 1.
  5. RobParker

    RobParker Well-Known Member

    We don't want to delete all PMs obviously :)

    Just being able to identify any with hundreds of recipients would be useful.
  6. AndyB

    AndyB Well-Known Member

    How would that be useful? Unfortunately Xenforo doesn't provide Admin tools to delete Private Conversations.
  7. feldon30

    feldon30 Well-Known Member

    He doesn't want to delete all PMs. Just newsletters that had hundreds of recipients.

    I'm sure there is a COUNT(*) query that would do it.
    Adam Howard and RobParker like this.

Share This Page