Sometime after upgrading to 2.3 a month or so ago, one (of our four) blogs developed a problem where it says that a post has 1 comment on the main page, but then there are no comments when you go to the post page.
I've looked in the DB, and the problem seems to be in the comment_count field. On one such post, that field has the value 1, when there are in fact no comments associated with the post (hence none show up on the post page).
Any idea why this might be happening? Can/should I just change the values of that field in the DB by hand, or are their consistency concerns I should be aware of?
Many thanks in advance.