Title: Solution for 2.3 database errors / wp_post2cat does not exist Last modified: August 18, 2016 --- # Solution for 2.3 database errors / wp_post2cat does not exist * [Arne](https://wordpress.org/support/users/arnee/) * (@arnee) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/) * If you are getting a database error like this: * > 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 * or like this: * > 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 * or like this: * > WordPress database error: [Table ‘wordpress.wp_post2cat’ doesn’t exist] > SELECT > cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat > pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID > WHERE post_status = ‘publish’ GROUP BY cat_ID * or any other database error which contains **wp_post2cat** or **wp_categories**, you are using a plugin or theme which is not compatible with WordPress 2.3. * Example plugins which don’t work: - Google Sitemaps Generator older than 3.0 ([Download new version here](http://wordpress.org/extend/plugins/google-sitemap-generator/)) - Posts by Author plugin - Ultimate Tag Warrior * It could also be that your theme is causing this error: - K2 Theme ([See this thread](http://wordpress.org/support/topic/135540?replies=11#post-620629)) * Please double check before posting that you don’t use any incompatible plugins. A list of plugins that work and which won’t work can be found at [the WordPress Codex](http://codex.wordpress.org/Plugins/Plugin_Compatibility/2.3). Viewing 15 replies - 16 through 30 (of 100 total) [←](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/?output_format=md) [1](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/?output_format=md) 2 [3](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/3/?output_format=md)… [5](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/5/?output_format=md) [6](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/6/?output_format=md) [7](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/7/?output_format=md) [→](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/3/?output_format=md) * [theenterprise17](https://wordpress.org/support/users/theenterprise17/) * (@theenterprise17) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625021) * In many cases the non working themes are calling the database directly in the sidebar.php or header.php file in the template to get you list of catigories. [ wp-list-catigories ](http://codex.wordpress.org/Template_Tags/wp_list_categories) is the tag that you wanna use to accomplish this effect. * [george71](https://wordpress.org/support/users/george71/) * (@george71) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625023) * Otto, honestly I have no clue what your talking about. Like I said before, upgrading used to be easy. I do not now what an SQL querie is. Up to now all WP themes worked fine and some plugins did not work well together. I can understand that and this is the reason why I liked blogging with WordPress. So now I do not understand why the database broke down in my own blog, this upgrade round. I don’t know if it’s the theme or anything else… * theenterprise17, I guess this won’t come as a plugin. * P.S. even when I use a 2.3 ready theme (for example Silverlight) the database keeps broken… * [affinityenterprises](https://wordpress.org/support/users/affinityenterprises/) * (@affinityenterprises) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625024) * In my styles.css, I have #categories to tell the system that the sidebar format applies. * However, in 2.3 Categories no longer exist. What should this keyword be replaced with? * Thanks. * Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/) * (@otto42) * WordPress.org Admin * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625028) * > _Up to now all WP themes worked fine and some plugins did not work well together. > I can understand that and this is the reason why I liked blogging with WordPress._ * Not true, the 2.1 upgrade broke a lot of themes, as well as plugins. * > _So now I do not understand why the database broke down in my own blog, this > upgrade round. I don’t know if it’s the theme or anything else…_ * And nobody can tell you that for certain either. We’re not you, we don’t have access to your site and setup. It might be a plugin, it might be the theme, but I cannot tell you because I’m not actually there, looking at your code. * > _P.S. even when I use a 2.3 ready theme (for example Silverlight) the database > keeps broken…_ * Then maybe, just maybe, you’ve got an incompatible plugin? You know that you’re supposed to disable all plugins before an upgrade, right? Well, now you know why. * Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/) * (@otto42) * WordPress.org Admin * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625029) * > _However, in 2.3 Categories no longer exist. What should this keyword be replaced > with?_ * Categories still exist in 2.3. So it’s hard to know what you’re talking about. Your CSS doesn’t have anything to do with the database. * [george71](https://wordpress.org/support/users/george71/) * (@george71) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625030) * Otto, I dropped all tables in MyPHP. Uploaded the backed-up database. Then re- run upgrade.php, and now voila everything seems fixed. All plugins were disabled, it must have been the conversion of the database. So glad I made a back up! * [affinityenterprises](https://wordpress.org/support/users/affinityenterprises/) * (@affinityenterprises) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625031) * [http://deepthoughts.affinityenterprises.com/](http://deepthoughts.affinityenterprises.com/) * Deep Thoughts Categories no longer has the background formatting the other widgets have. I was instructed to go into “styles.css” and make sure I have #categories in the appropriate places. * /*——-SIDEBAR———*/ * #sidebar { font-size:.9em; } * #meta, #categories, #pages, #yammyamm-menu, #recent-posts, #recent-comments,# peters-date-countdown, #calendar, #scrobbler, #links, #text-1, #text-2, #linkcat- 5, #archives, #linkcat-4, #linkcat-11, #google-search, #front-page-login, #rss- 1, #rss-2, #dthoughts { background: #eee url(images/sideboxbg.gif) top left repeat- x; padding: 25x; margin: 5px; border: 1px solid #ddd; } * However, #categories doesn’t seem to be working. * [jollymoon](https://wordpress.org/support/users/jollymoon/) * (@jollymoon) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625037) * Greetings: Wow, a lot of serious dedicated users got upset. what do you expect for free! * All we did to get rid of the errors was in Arnee’s post…DISABLE ALL PLUGINS. * We were lucky because we don’t use that many plugins, SpotMilk,CaptCha!,Kaccordion Multipack… * We Forgot to disable all plugins on the upgrade yesterday, but after trying to post and getting the errors like Arnee said, we went back and disabled the ULTIMATE TAG WARRIOR, SIMPLE TAGS, and WP-SHORTSTAT… * Yeah!! no more errors… * Hope this helps. The DATABase error is not in the theme but in the plugins mentioned. * [Ferdinand](https://wordpress.org/support/users/ferdinand/) * (@ferdinand) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625038) * In may case the MyDashboard plugin cause the database error. Since it’s gone everything is working fine again. * [mhdhallak](https://wordpress.org/support/users/mhdhallak/) * (@mhdhallak) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625049) * I’m getting this error from the Popularity Contest plugin. Hope the author upgrades it as soon as possible. * [Sparrowhawk](https://wordpress.org/support/users/sparrowhawk/) * (@sparrowhawk) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625068) * I received the WordPress database error in both the CopyBlogger and CutLine Themes. * The cause was the SimpleTagging Plugin, version 1.6.8.1 which is **supposed** to be compatible with WordPress 2.3. * I de-activated the plugin, error stopped, however now I don’t have any of my tags. * My page tabs don’t work either now, 404 error, but I figure that may be something to do with the themes. * [doc_holiday](https://wordpress.org/support/users/doc_holiday/) * (@doc_holiday) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625071) * I was not aware that SimpleTagging would work with 2.3 * [http://trac.herewithme.fr/project/simpletagging/wiki/Limits%2C%20Known%20Issues](http://trac.herewithme.fr/project/simpletagging/wiki/Limits%2C%20Known%20Issues) * [rexsky](https://wordpress.org/support/users/rexsky/) * (@rexsky) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625074) * upgrade ,just now~~ 🙂 * [patjepayer](https://wordpress.org/support/users/patjepayer/) * (@patjepayer) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625079) * Well, I got some error lines too for wp2cat… after depluggin all and activating one bye one the plugin Jerome’s Keyword causes the problem * [Sparrowhawk](https://wordpress.org/support/users/sparrowhawk/) * (@sparrowhawk) * [18 years, 8 months ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/2/#post-625081) * “I was not aware that SimpleTagging would work with 2.3” * SimpleTagging version 1.6.8.1, was offered as a new upgrade for 2.3 on my plugin page, which is why I installed it. * Apprantly I should have taken a look at the compatibility page instead and saved myself a lot of work. 😉 Viewing 15 replies - 16 through 30 (of 100 total) [←](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/?output_format=md) [1](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/?output_format=md) 2 [3](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/3/?output_format=md)… [5](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/5/?output_format=md) [6](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/6/?output_format=md) [7](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/7/?output_format=md) [→](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/3/?output_format=md) The topic ‘Solution for 2.3 database errors / wp_post2cat does not exist’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 100 replies * 78 participants * Last reply from: [whooami](https://wordpress.org/support/users/whooami/) * Last activity: [18 years ago](https://wordpress.org/support/topic/solution-for-database-errors-wp_post2cat-does-not-exist/page/7/#post-625524) * Status: not a support question ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics