WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Table 'wp_post2cat' doesn't exist (37 posts)

  1. BLT-FQX
    Member
    Posted 6 years 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

  2. BLT-FQX
    Member
    Posted 6 years ago #

    WP version 2.3 RC1 revision 6137

  3. Lester Chan
    Member
    Posted 6 years ago #

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

  4. BLT-FQX
    Member
    Posted 6 years ago #

    I wrote this to remind the author.

  5. Lester Chan
    Member
    Posted 6 years ago #

    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

  6. BLT-FQX
    Member
    Posted 6 years ago #

    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.

  7. spencerp
    Member
    Posted 6 years ago #

    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!

  8. btard
    Member
    Posted 6 years ago #

    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?

  9. spencerp
    Member
    Posted 6 years ago #

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

  10. btard
    Member
    Posted 6 years ago #

    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.

  11. spencerp
    Member
    Posted 6 years ago #

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

  12. chrisfmasse
    Member
    Posted 6 years ago #

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

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

  13. 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
  14. chrisfmasse
    Member
    Posted 6 years ago #

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

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

  16. chrisfmasse
    Member
    Posted 6 years ago #

    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/

  17. stribe37
    Member
    Posted 6 years ago #

    I upgraded to WP 2.3 with no problems at all. I only saw this error when I got the Simple Tagging plug-in and activated it. When I de-activated it, the error disappeared. I'd like to use Simple Tagging, but not if it's going to give me that error. Any way to fix it?

  18. Keilya
    Member
    Posted 6 years ago #

    I'm afraid not as the plugin is currently not compatible with WP 2.3. Guess you could search for another tagging plugin or use the new one that comes with 2.3

    Or wait for the author to release a new version. (:

  19. Gabo
    Member
    Posted 6 years ago #

    Oh I see. I just spent almost 4 hours scratching my head and asking myself why the current Simple Tagging plugin (1.7) still doesn't work. I thought it was already fixed since the one posted in the Known Issues section only mentioned of the Release Candidate version of WordPress 2.3, not the Final (which was just released).

    I use the same function of Simple Tagging that BLT-FQX uses (Related Posts). I also had the same results with stribe37. I guess I'll just have to wait for an update and disable the plugin for a while.

  20. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

    Virtually no tagging plugins will be compatible with 2.3 yet. Same thing goes for plugins that deal with categories in any way.

    2.3 is new. Wait for things to settle down. Or don't upgrade to 2.3 yet. Nobody said that you have to do it first day.

  21. stribe37
    Member
    Posted 6 years ago #

    fantasycrusader said:

    Guess you could search for another tagging plugin or use the new one that comes with 2.3

    I'm wondering how exactly to use the tagging function in 2.3. I see the tag input box below where I write my post.. but anything I put in there doesn't show up at all as a tag when I publish and post something.

  22. Geezerjim
    Member
    Posted 6 years ago #

    Check the codex here, and here.

  23. Jeremy Clark
    Moderator
    Posted 6 years ago #

    Your theme has to be updated to display the tags. If you feel confident enough you could update it your self with this.

    Also if you want to create a tag archive page have a look here.

  24. stribe37
    Member
    Posted 6 years ago #

    Thanks for the suggestions. I added the simple line in the Main Index Template, and it works fine now for showing those tags up. I think I'll wait a bit on the tag cloud.

  25. 10cplay
    Member
    Posted 6 years ago #

    I'm getting the same error message when I either post a new post, or add a comment. It doesn't seem to affect the posting or the comments being added though.

    I didn't do my own code and don't see any advice on which bits of code to alter and in which files...

    I don't have a tagger plugin...

    Any tips peeps?

    site located at 10cplay.com

  26. 10cplay
    Member
    Posted 6 years ago #

    Bingo...

    Apparently the Google Sitmaps plugin needed an update...

    I try to keep relatively plugin free, but this one is sooooo essential.

    Thank you!

  27. buzz
    Member
    Posted 6 years ago #

    I had a error like the OP while upgrading today. As it turned out, I had uploaded the wrong wp-config.php file (I look after 4 WP istalls.) After replacing with the correct one and a database (re)upgrade, everything's fine.

  28. nhtahoe
    Member
    Posted 6 years ago #

    The "Posts by Author" plugin was causing this problem for me after upgrading to 2.3. I deactivated it and now everything is fine. Pretty frustrating though!

  29. 4k
    Member
    Posted 6 years ago #

  30. Brooklyn2
    Member
    Posted 6 years ago #

    Table 'wp_post2cat' doesn't exist

    I also received the above error message. I was so convinced that I had done something wrong with permissions or something like that, that I deleted my site, deleted my database, and completely uploaded a new and clean WP 2.3, only to find out I was getting the same error. later found out that the error came from plugin "Google Sitemap" I deleted the 2.7 Google sitemap, then I was no longer getting the posting error. Tried to upload the Google Sitemap 3.0. Could not upload Newer Version of Google sitemap, using WSFTP. So as of now I am able to post without getting that error message, but I have no Google Sitemap, Now that is a bummer.

Topic Closed

This topic has been closed to new replies.

About this Topic