Can the topic count for a category be forced to update after the topics have been moved to a different category? I used this method to move topics around after merging two forums, but the counts are still off after 1.5 days. https://meta.discourse.org/t/bulk-move-many-topics-from-one-category-to-another/38704/2 [image]Bulk move many topics from one category to another If you execute either of these, category stats will be wrong but should fix themselves after a day.

Shouldn’t the category counts rebuild after a day @neil?

It would be nice if they did! However, that didn’t work out for us when we did a similar move. The following Ruby code, executed in the Rails console, will either fix the issue or set your database on fire :fire:, so backup accordingly :wink: Category.find_each { |c| c.topic_count = Topic.where(category: c).count - 1 # -1 for about post c.save! } (I’d still love for these to be re-counted occasionally, just as I’d do for post counts :slight_smile:)

Yes this is happenings once a day, doing this to update the counts: app/models/category.rb main after_destroy :clear_subcategory_ids after_destroy :publish_category_deletion after_destroy :remove_site_settings after_save :reset_topic_ids_cache after_save :clear_subcategory_ids after_save :clear_url_cache after_save :publish_discourse_stylesheet after_save :publish_category after_save do if saved_change_to_uploaded_logo_id? || saved_change_to_uploaded_logo_dark_id? || saved_change_to_uploaded_background_id? || saved_change_to_uploaded_background_dark_id? upload_ids = [ uploaded_logo_id, uploaded_logo_dark_id, Seems to work for me. @fefrei @omarfilip Please go to sidekiq scheduler (/sidekiq/scheduler) and see what the last run of CategoryStats shows. [27 PM]

I’ve triggered mine manually yesterday so the scheduler won’t mean much right now: [28 AM] The manual triggering of CategoryStats did not change the counts, though. I ran Felix’s ruby code earlier today and that dropped the topic counts in the empty categories. It did not increase the topic count elsewhere like I thought it would.

I had also triggered that job manually, as far as I recall. It completed successfully, but had no effect.

Mine also ran but didn’t change the counts. I also have one which is -1 as well. [image] I will run the code from @fefrei and see if that makes a difference. Edit: running the code worked in the rails console

Force recount of topics in category after moving them

Product Support

jerdog (Jeremy M) January 23, 2018, 2:27pm 7

Mine also ran but didn’t change the counts. I also have one which is -1 as well.

I will run the code from @fefrei and see if that makes a difference.

Edit: running the code worked in the rails console

Topic		Replies	Views
Moved topics to new category via ruby console, topic counts wrong on old category Product Support	1	1060	January 23, 2018
Updating topic count in categories after bulk delete & missing topics/posts Product Support	6	1774	June 11, 2018
Bulk tagged topics, then moved topics into another category, but the category tag selector doesn't show tags Product Support tags , bulk-actions	4	898	January 5, 2022
Move all topics from 1 category to other and tagging Product Support	7	1648	May 8, 2019
Category topic count incorrectly displaying number of posts Product Support	6	412	April 18, 2024

Force recount of topics in category after moving them

Related topics