I just upgraded to WordPress 2.5. Everything went ok, but my comment counts displayed all say zero even for posts with comments on them. The comments are all still there and can be seen; It is only the comment count that's displayed beneath the post that is wrong.
If a new comment is left on post, the comment count is updated correctly. It just shows zero until that happens.
In browsing my WP database, I noticed the wp_posts table has a comment_count field. Currently it has the value of 0 for all the posts (except those which have received comments after the WP 2.5 upgrade).
I'm wondering if there are any MySQL gurus out there who would know if the comments count can be corrected through a SQL query of something.
If so, what would the command be and how would I enter it? I access my WP database using phpMyAdmin 126.96.36.199. Forgive me for being such a newb here, but I don't know much about SQL.
Thanks in advance for your help. It's really appreciated.