WordPress.org

Ready to get started?Download WordPress

Forums

Error when upgrade to version 2.3 (5 posts)

  1. daoducquan
    Member
    Posted 6 years ago #

    After upgrade to new version 2.3, my blog has an error as follow (error appears in top of home page).

    Note: I did this already
    http://example.com/wordpress/wp-admin/upgrade.php

    Help me please!

    WordPress database error:

    [Table 'blogdb.wp_post2cat' doesn't exist]
    SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(posts.post_date_gmt)) + '7' AS last_post_date, UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt FROM wp_post2cat p2c INNER JOIN wp_posts posts ON p2c.post_id=posts.id WHERE 1 = 1 AND posts.post_type = 'post' AND posts.post_status = 'publish' AND posts.post_date_gmt <= '2007-09-25 03:25:13' GROUP BY p2c.category_id ORDER BY numposts DESC

  2. Stevie212
    Member
    Posted 6 years ago #

    http://wordpress.org/support/topic/135512

    Problem looks like an outdated plugin.

  3. spencerp
    Member
    Posted 6 years ago #

    Like Steve said above...

    You running plugins that might query THAT table? As Ryan Boren stated: “The big schema change is the dropping of the categories, post2cat, and link2cat changes in favor of the new terms, term_taxonomy, and term_relationship tables. Any plugin that queries against the old table will break horribly.”

    These three tables were dropped after/during your upgrade: categories, post2cat, and link2cat. Please disable any plugins that might be using one of those three older tables, and try again. You can look here to see if your plugins were updated for 2.3 or not. Thanks.

    Also, like said on Upgrade instructions.. PLUGINS SHOULD BE DISABLED BEFORE UPGRADING BLOGS!

  4. daoducquan
    Member
    Posted 6 years ago #

    Thank you for your kindly help! I will try!

  5. savvy1405
    Member
    Posted 6 years ago #

    It's the google sitemap-gen plugin that creates that error, you need to update to latest version,

Topic Closed

This topic has been closed to new replies.

About this Topic