Support » Installing WordPress » After upgrade, Categories AND Comments read ZERO

  • I just upgraded from 1.5 to the latest 2.whatever. All seemed to go well, but now all my Categories list no posts under them, even though my posts show assigned categories as before. Also, no posts show comments either, even though most of my posts do have comments.

    Everything else seems to be in order. I disabled plugins and didn’t have the spam karma thing like I’ve read.

    Any ideas? I have a backup, too, but am hoping for an easier fix.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Ok, no, really. I wasn’t kidding. Please?? Help???

    Blech. I give up.

    I did several 1.5-to-2.0.6 upgrades last weekend, pretty much without problems.

    This may be a stupid question, but did you (a) delete all but the necessary files (e.g., config.php) and (b) run upgrade.php?

    Yea, I did. I followed the instructions to a T, triple-checking my steps. Thanks for the reply!

    I’m going to take a wild guess, and ask whether the categories code in sidebar.php for your theme have this code:

    <?php wp_list_cats('sort_column=name&optioncount=1&hierarchical=0'); ?>

    It’s there.

    When I log in, none of the categories show posts, and no posts show comments, though the posts do show categories. If you wanna log in and see for yourself, email me at at gmail dot com.

    I really appreciate the attention!


    I had this same problem, but was able to solve it… I describe how here:

    Basically, to solve the comment_count issue, I ran the following SQL query in phpMyAdmin:

    UPDATE wp_posts SET comment_count = (SELECT COUNT(comment_post_id) FROM wp_comments WHERE = wp_comments.comment_post_id)

    My database has 129 categories, 14,461 posts and 107,302 comments, and the query ran almost instantaneously, so speed should not be an issue.

    As for categories, that can be solved without delving into phpMyAdmin. In the WordPress interface, simply create a new post and check off every single category. Save the post. Voila, you’re done. All the categories will update their category_count field. Admittedly, it was a little annoying to manually check off 129 categories, but it was doable, and it solved the problem in one fell swoop.

    The above post stripped the backticks out of my SQL query. Please visit to get the properly formatted query.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘After upgrade, Categories AND Comments read ZERO’ is closed to new replies.