Error when upgrade to version 2.3

  • daoducquan

    (@daoducquan)


    16 years, 7 months 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

Viewing 4 replies - 1 through 4 (of 4 total)
  • stevie212

    (@stevie212)

    16 years, 7 months ago

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

    Problem looks like an outdated plugin.

    spencerp

    (@spencerp)

    16 years, 7 months 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!

    Thread Starter daoducquan

    (@daoducquan)

    16 years, 7 months ago

    Thank you for your kindly help! I will try!

    savvy1405

    (@savvy1405)

    16 years, 7 months ago

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error when upgrade to version 2.3’ is closed to new replies.