Is there a way to remove all the deleted/hidden posts?

(Mikhail Morfikov) #1

After cleaning my forum’s database, we have a few hundreds of hidden posts that were deleted during this process, and I have two questions about deleting posts in Discourse.

  1. Is there a way to delete permanently all the hidden posts?
  2. Will the posts be deleted someday automatically, or will they stay forever and be visible to admins when they check some user account?

(Daniela) #2

Well, deleted posts are not completely deleted, they are always visible for admins.

So the answer is no, unless you go to put your hands on the database. Probably you can do it by the rails console, but is it so essential to delete something that is visible only to you or your admins?

(Mikhail Morfikov) #3

I could do it via database if I only knew what to change. :slight_smile:

You know I just want to clean it up. I won’t do it in the future, it needs to be done now.

(Kane York) #4

Deleting rows in the posts table from the database is not recommended. If you do try, make sure you keep a backup to restore to if (when) you mess it up.