Removed from public view

[TazDevilLooney]

How do i list all posts that's been "removed from public view" so i can permanently delete them?

 

[Paul B]

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.

 

[TazDevilLooney]

That sounds like a plan, what would the command be?

 

[Paul B]

Try this:

DELETE from xf_post WHERE message_state='deleted'

Take a backup first.

 

[TazDevilLooney]

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

 

[TazDevilLooney]

Works grate, thanks Brogan

 

[Paul B]

Lucky guess

 

[Digital Doctor]

Awesome site !

I love it ... very clean and unique !

 

[TazDevilLooney]

A cracking guess Brogan .

Thank you for you kind words Digital Doctor i appreciate the feedback.

 

[Syndol]

What about any attachments those posts may have had?

 

[TazDevilLooney]

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.

 

[jondoe0069]

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'

 

[AndyB]

I suggest using the Show Deleted add-on:

https://xenforo.com/community/resources/show-deleted.2387/

 

[jondoe0069]

I suggest using the Show Deleted add-on:

https://xenforo.com/community/resources/show-deleted.2387/

Great addon! Will use from now on. Thanks!