NFTs not appearing on explore items page

[hassnian]

What happened?

nft -> https://kodadot.xyz/ahk/gallery/356-7

it's missing when searching for it using the name -> https://kodadot.xyz/ahk/explore/items?search=Dark+Potencies&listed=false

[hassnian]

👋

[kodabot]

ASSIGNED ISSUES LIMIT REACHED - @hassnian, you have been already assigned with 5 issues: 6955,8163,8890,9173,9456,9488,9499. Finish one of them in order to get more issues assigned!

[hassnian]

indexer issue kodadot/stick#223

[hassnian]

@daiagi the issue seems to persist

https://canary.kodadot.xyz/ahk/explore/items?search=Dark+Potencies&listed=false

[daiagi]

@vikiival can we do a release?

[vikiival]

Blocked by

• update or delete on table "token_entity" violates foreign key constraint stick#220

I would appreciate if you can fix it I find the tokenAPI very hard to read

[daiagi]

What's wrong with this fix?

kodadot/stick#231

Also, I am completely unable to reproduce it.
Since you posted that issue I have ran indexer on local machine both on kusama and polkadot multiple times.
Didn't encounter any issue

As you said, it looks like there is something a bit off with counting of references when deleting a token

Your solution of getting the count from db seems legit

[vikiival]

Still failing tho