# Top topics not working after import
**URL:** https://meta.discourse.org/t/top-topics-not-working-after-import/184544
**Category:** Support
**Created:** [March 26, 2021, 10:08am UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544 "2021-03-26T10:08:26Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@TheDarkWizard](https://meta.discourse.org/u/TheDarkWizard)
#### Post date: [March 26, 2021, 10:08am UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/1 "2021-03-26T10:08:26Z")
Any way to get Discourse to recalculate all Top Topics in a user’s profile after an import and/or links counter in a topic?
Oddly enough, Top Replies is working correctly.
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [March 26, 2021, 1:51pm UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/2 "2021-03-26T13:51:48Z")
I _believe_ the stats are calculated automatically every 24 hours. You shouldn’t need to do anything but wait.
---
### Author:  [@TheDarkWizard](https://meta.discourse.org/u/TheDarkWizard)
#### Post date: [March 26, 2021, 10:09pm UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/3 "2021-03-26T22:09:26Z")
That doesn’t seem to be the case, we’ve had an import test up and running for a few weeks now, somethings self corrected, others did not. Top Topics is the biggest example of this. Amount Links in topics is the other. Other then that, seems to be correct across the site.
---
### Author:  [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [March 26, 2021, 10:22pm UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/4 "2021-03-26T22:22:21Z")
Hmm, looking at the code we have two jobs — [TopRefreshToday](https://github.com/discourse/discourse/blob/master/app/jobs/scheduled/top_refresh_today.rb) (fires every hour) and [TopRefreshOlder](https://github.com/discourse/discourse/blob/master/app/jobs/scheduled/top_refresh_older.rb) (fires every 24 hours). Both call methods from [here](https://github.com/discourse/discourse/blob/master/app/models/top_topic.rb) which you should be able to run from the rails console manually if needed.
Can you check `/sidekiq/scheduler` to see if the two jobs have been running?
I’m assuming all of the relevant information for calculating top topics was brought over with the import?
---
### Author:  [@Ghan](https://meta.discourse.org/u/Ghan)
#### Post date: [March 27, 2021, 12:47am UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/5 "2021-03-27T00:47:18Z")
In this case, these jobs are running just fine. The issue appears to be that the like\_count field on the topics table is not populated. Is there a good way to recalculate the value for that field, or is that something that needs to be done during import? If it does need to be done during import, then how is the calculation for that supposed to work? Is this a summation of all likes from all posts in the topic?
I did find a way using the Rails console that appears to recalculate this field:
```plaintext
Topic.visible.map(&:update_statistics)
```
The issue with this solution is that for our topic and post counts, I was estimating it would take about two months for that command to run to completion.
---
### Author:  [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [March 27, 2021, 1:47am UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/6 "2021-03-27T01:47:14Z")
It looks like you can regenerate the `like_count` using the `update_action_counts` method:
>
So maybe something like:
```ruby
Topic.all.find_each do |t|
putc '.'
t.update_action_counts
end
```
---
### Author:  [@TheDarkWizard](https://meta.discourse.org/u/TheDarkWizard)
#### Post date: [March 29, 2021, 4:23pm UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/7 "2021-03-29T16:23:32Z")
This appears to have worked really well for @Ghan and I, thank you so much 🙂
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [April 28, 2021, 4:24pm UTC](https://meta.discourse.org/t/top-topics-not-working-after-import/184544/8 "2021-04-28T16:24:33Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.