Originally Posted by Chuck S
I know your issue
You forgot to reset vote counts when you started a contest. You need to do this to clear normal ratings.
See once someone votes in a contest all ratings over 1 are cleared as they should be. So you where calculating other ratings at the beginning of the contest.
As soon as someone voted it was set correctly.
Good theory, but I don't allow normal ratings, so there shouldn't have been any ratings for any of these photos before I started the contest.
When I "enable contest", I'm the first one to vote, after I do, there is only one vote showing, and it's mine. As time goes on and more people vote, the numbers reflect that. Then, a user saw that his vote didn't count, which prompted this thread. Since today was the last day to vote, I "ended" the voting, and it showed 6 votes for the winning photo. An hour or so later, it showed 1 vote for this photo. So my 'comments' table is accurate (as far as I can tell anyways), but my 'photos' table was updated one last time incorrectly.