# Force recount of topics in category after moving them
**URL:** https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026
**Category:** Support
**Created:** [30 oktober 2017 om 03:37 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026 "2017-10-30T03:37:10Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@omarfilip](https://meta.discourse.org/u/omarfilip)
#### Post date: [30 oktober 2017 om 03:37 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/1 "2017-10-30T03:37:10Z")
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](https://meta.discourse.org/t/bulk-move-many-topics-from-one-category-to-another/38704/2)
> [@Bulk move many topics from one category to another](https://meta.discourse.org/t/bulk-move-many-topics-from-one-category-to-another/38704/2):
>
> If you execute either of these, category stats will be wrong but should fix themselves after a day.
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [30 oktober 2017 om 04:28 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/2 "2017-10-30T04:28:23Z")
Shouldn’t the category counts rebuild after a day @neil?
---
### Author:  [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [30 oktober 2017 om 09:20 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/3 "2017-10-30T09:20:25Z")
It would be nice if they did! However, that didn’t work out for us [when we did a similar move](https://meta.discourse.org/t/re-purposing-a-discourse-installation-for-a-yearly-event/34670/17).
The following Ruby code, executed in the Rails console, will either fix the issue or set your database on fire 🔥, so backup accordingly 😉
```ruby
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](https://meta.discourse.org/t/wrong-post-count-in-profile/71352/41) 🙂)
---
### Author:  [@neil](https://meta.discourse.org/u/neil)
#### Post date: [30 oktober 2017 om 17:39 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/4 "2017-10-30T17:39:50Z")
Yes this is happenings [once a day](https://github.com/discourse/discourse/blob/master/app/jobs/scheduled/category_stats.rb), doing this to update the counts:
>
Seems to work for me.
@fefrei @omarfilip Please go to sidekiq scheduler (`/sidekiq/scheduler`) and see what the last run of CategoryStats shows.
---
### Author:  [@omarfilip](https://meta.discourse.org/u/omarfilip)
#### Post date: [30 oktober 2017 om 17:52 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/5 "2017-10-30T17:52:34Z")
I’ve triggered mine manually yesterday so the scheduler won’t mean much right now:
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.
---
### Author:  [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [30 oktober 2017 om 18:02 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/6 "2017-10-30T18:02:22Z")
I had also triggered that job manually, as far as I recall. It completed successfully, but had no effect.
---
### Author:  [@jerdog](https://meta.discourse.org/u/jerdog)
#### Post date: [23 januari 2018 om 14:27 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/7 "2018-01-23T14:27:59Z")
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
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [14 april 2020 om 15:04 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/8 "2020-04-14T15:04:41Z")
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [13 mei 2024 om 17:03 UTC](https://meta.discourse.org/t/force-recount-of-topics-in-category-after-moving-them/73026/9 "2024-05-13T17:03:04Z")