WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Table ‘wp_post2cat’ doesn’t exist

[Resolved] Table ‘wp_post2cat’ doesn’t exist

  • Error message in the home page.

    WordPress database error: [Table ‘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)) + ‘8’ 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-19 12:08:25’ GROUP BY p2c.category_id ORDER BY numposts DESC

Viewing 15 replies - 1 through 15 (of 36 total)
  • WP version 2.3 RC1 revision 6137

    as of WP 2.3, there is no post2cat, link2cat and categories. So update your code accordingly.

    I wrote this to remind the author.

    erm and WP2.3 includes tagging and Simple Tagging importer so bascially you do not need this plugin as tagging is already in 2.3

    The newly tagging system is not good enough compared to Simple Tagging, I cannot generate related post and cannot add tags through Windows Live Writer.
    I hope Simple Tagging could do that for me.

    As Ryan Boren said on the WP-Testers list already: β€œ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.”

    This should be pointed out to the plugin authors firmly and quickly, so they all know of it.

    The newly tagging system is not good enough compared to Simple Tagging, I cannot generate related post and cannot add tags through Windows Live Writer.

    The new tagging system is fresh and will not be full of wonderful features and capabilities. Things will gradually be added and people will suggest improvements for it later though. I’m quite sure of that.

    Patience is a good thing. But, you can always use another Tag Related Plugin that will do what you want though, until such things are implemented into the WP Core for tagging stuff… Good luck!

    I’m getting this upon a new post also after upgrading to the new 2.3 version

    I have no such plugin activated that uses that old database table. Why am I getting this error now after overwriting all files with the stable release of 2.3?

    These three tables were dropped after/during your upgrade: categories, post2cat, and link2cat. Did you do a back up before the upgrade? Also, I usually DELETE all the previous WP files, EXCEPT for the wp-content/ folder, the wp-config.php, the .htaccess and any special plugin files outside the wp-content/plugins/ directory.. Just to make sure that everything was done right and good.

    Regardless, 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. =)

    Spencerp: I am retarded, it’s late and consequently I am embarrassed to say that I forgot to upload some updated plugin code, doh! It’s all good now.

    Oh, okay! Glad to hear it’s all good now! =D And no, you’re not retarded, it’s a common mistake. It happens!

    I get this kind of error message as soon as I activate the brand-new version of WP-Cache (2.1.2) onto WP 2.3. And to make things returned to normal, I have to clear the current cache, deactivate all the plugins, and re-activate all the plugins except for WP-Cache.

    Color me perplex. πŸ˜€

    Psstt… All the plugins I use are listed here:
    http://www.midasoracle.org/about/credits/

    Jeff Chandler

    @jeffr0

    Volunteer Moderator and Voice of WP

    I too am receiving this error. I double checked the COMPATIBLE PLUGINS list and all of the plugins I have installed are supposedly compatible with 2.3 I’m also using WP-Cache but I’m not sure if that is causing the issue. Here are the errors I’m receiving:

    WordPress database error: [Table 'wordpress.wp_post2cat' doesn't exist]
    SELECT c.cat_name FROM wp_post2cat p2c INNER JOIN wp_categories c ON p2c.category_id = c.cat_id WHERE p2c.post_id = 218
    
    WordPress database error: [Table 'wordpress.wp_post2cat' doesn't exist]
    SELECT c.cat_name FROM wp_post2cat p2c INNER JOIN wp_categories c ON p2c.category_id = c.cat_id WHERE p2c.post_id = 218
    
    WordPress database error: [Table 'wordpress.wp_post2cat' doesn't exist]
    SELECT c.cat_name FROM wp_post2cat p2c INNER JOIN wp_categories c ON p2c.category_id = c.cat_id WHERE p2c.post_id = 218

    CORRECTION: The WP-Cache plugin alone works fine. Sorry for my previous post, where I did accuse it. The problem lays somewhere else.

    Jeff Chandler

    @jeffr0

    Volunteer Moderator and Voice of WP

    I found out that my UTC or Ultimate Tagging Warrior plugin was causing these errors. I have disabled it and finally figured out how to import my tags. All is well.

    UPDATE:
    1. Here’s what I did. I have deactivated all plugins. I have cleared the cache. I have then installed the plugins one by one —each time, I would clear the cache after each activation, and I would dowload a blog post to check.
    2. In my list of plugins, it turned out that the culprit is POSTS BY AUTHOR.
    http://www.dagondesign.com/articles/posts-by-author-plugin-for-wordpress/

Viewing 15 replies - 1 through 15 (of 36 total)
  • The topic ‘[Resolved] Table ‘wp_post2cat’ doesn’t exist’ is closed to new replies.
Skip to toolbar