Dear Team, Please help me out to resolve this! We have too many deleted-posts and we need to delete that permanently but in bulk! [image]

Excellent, glad to hear that did the job for you. So for the sake of combining the answers, one can use the following in the Rails console to destroy all topics that were deleted more than 90 days ago, repeating as many times as necessary if there are more than 1000 topics: Topic.with_deleted.where…

If I am not mistaken there is a field called deleted_at If it is deleted, then there should be a date time Stamp. If it is not deleted then is null Maybe look for the entry that is <> Null and delete

[image] IAmGav: Maybe look for the entry that is <> Null and delete Thanks Gav, but the ones that I am targeting aren’t marked as deleted. Rather, their Topic has been deleted and then destroy_all’d.

I was playing around with this and i notice that part of your query was not returning the response you need. SELECT topic_id from posts does not return an integer, but it returned a string [image] This might be the cause that your db still contains orphaned posts.

[image] IAmGav: does not return an integer, but it returned a string I think that you are seeing Data Explorer automagically converting the integer into URL, which it does when the label is topic_id. When I run this query in Data Explorer , all of the posts that I am attempting to identify ar…

Well, thanks to @pfaffman I have identified the relevant posts using this: Post.find_by_sql("select id from posts where topic_id not in (select id from topics)") I get this output: [1] pry(main)> Post.find_by_sql(“select id from posts where topic_id not in (select id from topics)”) => [#<Post:0…

I think this will do it posts= Post.find_by_sql("select id from posts where topic_id not in (select id from topics)") posts.destroy_all Or you could add the .destroy_all to your find_by_sql

I’ve tried that. The data seems to be returned as an array with some post identifier and an ID (see Delete deleted-posts permanently in bulk? - #45 by nathank ). This is the error I get when I either add .destroy_all or use the posts= that you suggest: [2] pry(main)> posts.destroy_all NoMethodErr…

Oh. Then maybe see if p=posts.first Is a post_id. If t that’s it then you can x=Post.find(p) x.destroy Then you could loop through those. I think you’d need to wrap your query in something to get it to be an array of posts rather than post ids.

Thanks Jay. This is what I get: [3] pry(main)> p= [3] pry(main)* posts.first => #<Post:0x0000563a24cab908 id: 150> [4] pry(main)> x=Post.find(p) ArgumentError: You are passing an instance of ActiveRecord::Base to find. Please pass the id of the object by calling .id. from /var/www/discourse/v…

What did that do? I can’t imagine that rails changed.

Delete deleted-posts permanently in bulk?

Support

pfaffman (Jay Pfaffman) November 28, 2021, 11:29am 51

Does that give you the posts you want to destroy?

Topic		Replies	Views
Purge/clean/delete deleted topics from database Support	4	340	July 5, 2025
I am getting 502 error while trying to delete topics created by specific user Support	18	1132	June 12, 2023
Administrative Bulk Operations Self-Hosting configuring , reference	8	14252	June 9, 2026
Clean up old topics Support	4	569	February 2, 2023
Help Wiping all Posts from a Forum Support	18	2084	August 26, 2020

Delete deleted-posts permanently in bulk?

Related topics