Database Error (5 posts)

  1. frostyIntrepid
    Posted 8 years ago #

    Hi All,

    I have just upgraded to ver 2.3 and have encountered a database error whenever I use the search function at the sidebar.

    Website is located at http://spencertan.com

    Any help is greatly appreciated.

  2. Dion Hulse
    Lead Developer
    Posted 8 years ago #

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

  3. spencerp
    Posted 8 years ago #

    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...

  4. daoducquan
    Posted 8 years ago #

    Help me please, I have that error.

    my website is: http://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

  5. spencerp
    Posted 8 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.