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

[изображение] 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.

[изображение] 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 ident…

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?

Поддержка

pfaffman (Jay Pfaffman) 28.Ноябрь.2021 11:29:57 51

Does that give you the posts you want to destroy?

1 лайк

Тема		Ответов	Просм.
Purge/clean/delete deleted topics from database Support	4	286	05.07.2025
Administrative Bulk Operations Self-Hosting configuring , reference	8	14039	25.02.2026
I am getting 502 error while trying to delete topics created by specific user Support	20	1067	12.06.2023
Clean up old topics Support	4	527	02.02.2023
Help Wiping all Posts from a Forum Support	18	2038	26.08.2020

Delete deleted-posts permanently in bulk?

Связанные темы