Table ‘wp_post2cat’ doesn’t exist

  • Resolved blt-fqx

    (@blt-fqx)


    17 years, 2 months ago

    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)
  • Thread Starter blt-fqx

    (@blt-fqx)

    WP version 2.3 RC1 revision 6137

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

    Thread Starter blt-fqx

    (@blt-fqx)

    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

    Thread Starter blt-fqx

    (@blt-fqx)

    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:
    https://www.midasoracle.org/about/credits/

    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.

    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.
    https://www.dagondesign.com/articles/posts-by-author-plugin-for-wordpress/

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