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

SQL queries to mass remove..........

Discussion in 'Troubleshooting and Problems' started by Adam H, Nov 19, 2012.

  1. Adam H

    Adam H Member

    Profile messages, Spammers............lots of them have been posting their links all over visitor messages/profile messages and going through them one by one isnt an option.

    is there a query which i can run to get rid of ALL profile posts by all members.

    thanks in advance .
  2. Chris D

    Chris D XenForo Developer Staff Member

    Get rid of all profile posts by all members? Even legitimate ones?

    If you insist...

    First, remove all profile post comments:
    TRUNCATE `xf_profile_post_comment`

    Then, remove all profile posts:
    TRUNCATE `xf_profile_post`
    Jake Bunce and Adam H like this.
  3. Adam H

    Adam H Member

    Thanks Chris,

    Yes its a newish forum so not many ( if any profile posts ).
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

Share This Page