Why does this ‘Overall Sentiment’ query gives empty results:
I also just copied, pasted it as a ‘New Query’ and ran. No changes by me made at all.
From where do I need to look for this? I’m admin of my site.
My dashboards looks like this:
Did you change the dates that the query covered? Try refreshing the page and amending the date parameters if you haven’t already done so.
Did you run a backfill?
No. I didn’t. Nor did I read about this in (the first post of) this topic.
Can u pls tell how do/can I do that?
Or if I don’t run backfill, when will this component get enough posts to work out the sentiment?
That’s explained in the guide I quoted.
When did you enable the sentiment analysis? You chose February 2024 as an end date in your data explorer query. Was the analysis enabled before that? Otherwise, since only new posts are classified, I’d expect it to return 0 results.
Ok, I had missed, but now I’d surely study and solve the problem.
Analysis was enabled in Feb or March, 2024, I don’t remember exact date. How many posts does it require (after its enabled, without running back-fill) to show something?
I’m seeing ‘Site Sentiment’ in my Admin Dashboard for the past 2-3 months, but no sentiment is being shown.
I even tried running the same as an Sql Query thru Data Explorer plugin and changed dates to approx 2 years, still only blank result.
When I try run a ‘BackFill Task’ it gave the following error:
I took screenshot of almost 50% of the top area.
As shown in the ‘just-above’ post of mine that Back-Filling is failing, can someone pls tell how many days/how many posts will it take for this ‘Sentiment Analysis’ to work or show something (i.e. wo backfill)?
I’ve searched ‘Back-Fill-Failing’ on meta, but no solution has been found anywhere.
I’ve collected these up and split them into their own topic so they’re not cross-posted in multiple places. ![]()
Have you posted something new for the Sentiment to run against? If it’s not picking up new things either then I think you have a problem with your configuration rather than just the backfill.
Sentiment Analysis is being shown blank constantly. Even though tens of topics have been created since this functionality was introduced around 2-3 months back. And I’ve expanded the dates to try to give it more data.
Report refreshed after changing dates:
And even though BackFilling might not be culprit/required in my case, but when I tried, it too failed, as being discussed in its own topic here.
What could go wrong, if somebody would?
자체 호스팅 인스턴스에서 2026년에 백필(backfill)을 어떻게 해야 할지 궁금합니다.
/var/www/discourse# rake ai:sentiment:populate
rake aborted!
Don't run this task in production!
기능을 활성화하면 지난 60일치 데이터가 자동으로 백필됩니다.
알고 있지만, 우리 커뮤니티(그리고 포럼)가 개발 진행 중으로 거의 2년째라 전반적인 감정을 확인해 보고 싶어요.
참고로, 지난 60일 동안 오류도 감정 분석 결과도 찾지 못했어요. /logs나 /sideqik(대기 중인 작업 없음) 외에 더 디버깅할 수 있는 방법이 있을까요?
후속 조치에 감사드립니다. 내부 IP를 allowed internal hosts에 추가하는 것을 잊었었습니다.
이후 rails console을 통해 작업을 다시 실행했습니다:
Jobs::SentimentBackfill.new.execute({})
하지만 여전히 전체 백필이 누락되어 있습니다 ![]()
저희 포럼과 커뮤니티는 몇 년 동안 개발 중이었으며(현재도 진행 중) 과거의 동향을 이해하는 것이 매우 중요합니다.
이것이 문제를 일으키지 않고 실현 가능한가요?
최소 최근 60일간의 데이터는 확보했나요? 게시글에 해당 내용이 명확히 기재되어 있지 않습니다.








