Thanks @pfaffman for the bulk deletion snippet you wrote using the Rails find_each method. Great work. After bulk back-end deletion, is there a way to update the topic count in categories? Right now, I have an empty topic list which is ready for fresh import but the topic count in my categories still shows a count of thousands.And when I re-import fresh, the number only grows. I waited overnight since I am not sure if there is a cron job or background task in Discourse that updates the counts. (I’m new to Discourse) I feel like there is a command to refresh_topic_count or something…

FIXED. [I deleted my other replies in this topic, since they were the wrong path] I happened to find this idea by @simon [image]Post is deleted and shows as hidden in topic, not marked as hidden or deleted in db Through the rails console you’ll need to search with something like Post.with_deleted.where("topic_id = ? AND deleted_at IS NOT NULL", your_topic_id) This helped me to see that the Post.find_each method was not returning deleted posts. So when I went to re-import, my data it still existed. Now, before I re-import I run this for topics (and separately, posts): require_relative '../discourse/config/environment' cnt = 0 #Topic.find_each do |t| # only returns active topics Topic.with_deleted.find_each do |t| # returns both active and deleted topics if t.id > 6 && t.user_id != -2 # excludes included system topics and Discobot user Greeting messages puts "Topic: #{t.id}, #{t.title}, #{t.user_id}" t.destroy cnt = cnt +1 end end puts "Deleted #{cnt} active and deleted topics where t.id > 6 && t.user_id != -2"

I had a similar problem. The following code (to be run within rails console) may solve your problem, make it worse, or set your hair on fire :fire:. Use at your own risk (and with a backup). Category.all.each { |c| c.topic_count = c.topics.length - 1 # -1 for about post c.save! } Alternatively, rake import:ensure_consistency from here might help, but it seems to have destructive side effects.

Awesome, thanks @fefrei . Since I am new to Discourse and apparently did not completely read the docs I was not even aware that Sidekiq existed! :heart_eyes: Totally awesome. The solution was to simply trigger the Jobs::CategoryStats. No fire needed :fire_engine:. [comment redacted (figured it out)]

Now, I have a new problem which I don’t know how to feel about… After import, I expected to have 2158 topics (or thereabout): [image] However, my new category count is around 1700. I checked the rails console to get (find_each) topics count where user not discobot and it confirms the new category topic count around 1700. Is there something I’m missing? Is there a log of “skipped topics” during import? I can’t seem to trace it out in the base.rb import include. Where does base.rb “puts” the error messages, exactly? Because it’s not in the ssh console.

What does Topic.count returns (when executed in the rails console)?

Updating topic count in categories after bulk delete & missing topics/posts

Product Support

Bryan_Underwood_CA (Bryan Underwood) June 7, 2018, 8:18pm 6

Sorry, I meant to say my topic count not category count. Trying to say my “topic count” showing next to my “category” label. The topic count returns 1691.

Topic		Replies	Views
Force recount of topics in category after moving them Product Support	6	1935	January 23, 2018
A few questions about batch moving or deleting topics Product Support	3	1133	December 10, 2020
The proper way to completely delete hundred of topics via rails? Product Support	10	5744	July 6, 2018
Cannot delete system created topic Product Support	13	1502	September 14, 2019
Can't delete this category because it has 1 topic Product Support	11	1412	February 2, 2021

Updating topic count in categories after bulk delete & missing topics/posts

Related topics