Support » Fixing WordPress » WordPress 2.5: Comment Count Shows 0 On All Posts After Upgrade

  • Resolved scottorama

    (@scottorama)


    I just upgraded to WordPress 2.5. Everything worked ok, but my comment counts all say zero even for posts with comments on them. The comments display all right, and if a new comment is left, the comment count on that post is corrected. The problem is that it’s not feasible to go through and leave “test” comments on 1,128 posts in order to correct the comment counts.

    Any ideas on how to fix this?

    Thanks!

    (Yes, I did do a search on this topic prior to posting this here. Others have had similar problems, but not quite the same. Also, none of the other posts involved WordPress 2.5.)

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter scottorama

    (@scottorama)

    I’ve been thinking about this a bit more.

    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 2.9.1.1. Forgive me for being such a newb here, but I don’t know much about SQL.

    As I said before, the comments are all still there. 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).

    Thanks in advance for your help. It’s really appreciated.

    Thread Starter scottorama

    (@scottorama)

    I’m closing this thread and opening one with a more descriptive title since I believe this problem can be fixed via MySQL.

    There’s SQL code to fix this posted at wordpress.org/support/topic/164904 – be sure to backup your database just in case.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress 2.5: Comment Count Shows 0 On All Posts After Upgrade’ is closed to new replies.