How did you populate the database to begin with? If you're using the RPC mechanism, after 30 days some data is no longer returned. For example, active_votes
is empty for all posts after their second payout. You can even see this on steemit.com where old posts have zero upvotes.
You are viewing a single comment's thread from:
All votes are in transactions and stored in the TxVotes table, even first votes ever :
![](https://images.hive.blog/768x0/https://s18.postimg.org/mhjtzg7p5/14_09_2016_13_56_49.png)