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

Removed from public view

Discussion in 'XenForo Questions and Support' started by TazDevilLooney, Jul 22, 2011.

  1. TazDevilLooney

    TazDevilLooney Active Member

    How do i list all posts that's been "removed from public view" so i can permanently delete them?
    Digital Doctor likes this.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    There's no way of doing that in the ACP.

    You can however run a query to delete all entries in the xf_post table which have a message_state of deleted.
    maszd likes this.
  3. TazDevilLooney

    TazDevilLooney Active Member

    That sounds like a plan, what would the command be? :whistle:
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Try this:

    DELETE from xf_post WHERE message_state='deleted'

    Take a backup first.
    maszd and TazDevilLooney like this.
  5. TazDevilLooney

    TazDevilLooney Active Member

    Nice, i'll backup and get back to you.
  6. TazDevilLooney

    TazDevilLooney Active Member

    Works grate, thanks Brogan
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Lucky guess :whistle:
  8. Digital Doctor

    Digital Doctor Well-Known Member


    Awesome site ! [​IMG]
    I love it ... very clean and unique !
    TazDevilLooney likes this.
  9. TazDevilLooney

    TazDevilLooney Active Member

    A cracking guess Brogan (y).

    Thank you for you kind words Digital Doctor i appreciate the feedback. :)
  10. Syndol

    Syndol Guest

    What about any attachments those posts may have had?
  11. TazDevilLooney

    TazDevilLooney Active Member

    The users have the option to delete there own posts. I was just cleaning up so there should be no working attachments in the deletes anyway.

    But to answer you question i just don't know.
  12. jondoe0069

    jondoe0069 Member

    Sorry to bump this, but I just followed it and also had to run the following as well. Otherwise, where the "removed form public view" posts were the only thing in the thread, the threads stayed behind still.

    DELETE from xf_thread WHERE discussion_state='deleted'
  13. AndyB

    AndyB Well-Known Member

    maszd likes this.
  14. jondoe0069

    jondoe0069 Member

    AndyB likes this.

Share This Page