Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Dion Hulse

    (@dd32)

    Meta Developer

    the table wp_post2cat is no longer used by wordpress, You’ve most likely got a search plugin installed which needs to be updated.

    I tried going to your site, but, since I’m on dial-up connections yet, it takes too long and I gave up. If you’re not a member of the wp-testers list, please join it and post this issue there. The Developers could assist you quicker that way. Thanks. =)

    Maybe the theme isn’t updated for 2.3 Compatibility? I’m not sure, but just throwing that out there once…

    Help me please, I have that error.

    my website is: https://www.daoducquan.com

    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 06:30:23’ GROUP BY p2c.category_id ORDER BY numposts DESC

    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!

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