WordPress.org

Ready to get started?Download WordPress

Forums

After upgrade, Categories AND Comments read ZERO (9 posts)

  1. elpaolo
    Member
    Posted 7 years ago #

    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.

  2. elpaolo
    Member
    Posted 7 years ago #

    Ok, no, really. I wasn't kidding. Please?? Help???

  3. elpaolo
    Member
    Posted 7 years ago #

    Blech. I give up.

  4. DianeV
    Member
    Posted 7 years ago #

    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?

  5. elpaolo
    Member
    Posted 7 years ago #

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

  6. DianeV
    Member
    Posted 7 years ago #

    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'); ?>

  7. elpaolo
    Member
    Posted 7 years ago #

    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 marcoe.net at gmail dot com.

    I really appreciate the attention!

    P

  8. trojanloy
    Member
    Posted 7 years ago #

    I had this same problem, but was able to solve it... I describe how here:
    http://www.brendanloy.com/2007/02/wordpress-21-upgrade-problems.html

    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_posts.id = 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.

  9. trojanloy
    Member
    Posted 7 years ago #

    The above post stripped the backticks out of my SQL query. Please visit http://www.brendanloy.com/2007/02/wordpress-21-upgrade-problems.html to get the properly formatted query.

Topic Closed

This topic has been closed to new replies.

About this Topic