Title: Table ‘wp_post2cat’ doesn’t exist Last modified: August 18, 2016 --- # Table ‘wp_post2cat’ doesn’t exist * Resolved [blt-fqx](https://wordpress.org/support/users/blt-fqx/) * (@blt-fqx) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-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) 1 [2](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/2/?output_format=md) [3](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/3/?output_format=md) [→](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/2/?output_format=md) * Thread Starter [blt-fqx](https://wordpress.org/support/users/blt-fqx/) * (@blt-fqx) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622028) * WP version 2.3 RC1 revision 6137 * [Lester Chan](https://wordpress.org/support/users/gamerz/) * (@gamerz) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622058) * as of WP 2.3, there is no post2cat, link2cat and categories. So update your code accordingly. * Thread Starter [blt-fqx](https://wordpress.org/support/users/blt-fqx/) * (@blt-fqx) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622073) * I wrote this to remind the author. * [Lester Chan](https://wordpress.org/support/users/gamerz/) * (@gamerz) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622085) * 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](https://wordpress.org/support/users/blt-fqx/) * (@blt-fqx) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622141) * 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. * [spencerp](https://wordpress.org/support/users/spencerp/) * (@spencerp) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622147) * 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! * [btard](https://wordpress.org/support/users/btard/) * (@btard) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622230) * 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? * [spencerp](https://wordpress.org/support/users/spencerp/) * (@spencerp) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622231) * 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](http://lists.automattic.com/mailman/listinfo/wp-testers) list, please join it and post this issue there. The Developers could assist you quicker that way. Thanks. =) * [btard](https://wordpress.org/support/users/btard/) * (@btard) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622232) * 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. * [spencerp](https://wordpress.org/support/users/spencerp/) * (@spencerp) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622233) * Oh, okay! Glad to hear it’s all good now! =D And no, you’re not retarded, it’s a common mistake. It happens! * [Chris F. Masse](https://wordpress.org/support/users/chrisfmasse/) * (@chrisfmasse) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622234) * 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/](http://www.midasoracle.org/about/credits/) * [Jeffro](https://wordpress.org/support/users/jeffr0/) * (@jeffr0) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622235) * 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 ``` * [Chris F. Masse](https://wordpress.org/support/users/chrisfmasse/) * (@chrisfmasse) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622236) * CORRECTION: The WP-Cache plugin alone works fine. Sorry for my previous post, where I did accuse it. The problem lays somewhere else. * [Jeffro](https://wordpress.org/support/users/jeffr0/) * (@jeffr0) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622237) * 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. * [Chris F. Masse](https://wordpress.org/support/users/chrisfmasse/) * (@chrisfmasse) * [18 years, 9 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/#post-622238) * 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/](http://www.dagondesign.com/articles/posts-by-author-plugin-for-wordpress/) Viewing 15 replies - 1 through 15 (of 36 total) 1 [2](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/2/?output_format=md) [3](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/3/?output_format=md) [→](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/2/?output_format=md) The topic ‘Table ‘wp_post2cat’ doesn’t exist’ is closed to new replies. * 36 replies * 23 participants * Last reply from: [omgitztrey](https://wordpress.org/support/users/omgitztrey/) * Last activity: [18 years, 6 months ago](https://wordpress.org/support/topic/table-wp_post2cat-doesnt-exist/page/3/#post-622325) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics