Title: WordPress database error @ 2.3 Last modified: August 18, 2016 --- # WordPress database error @ 2.3 * [guxo](https://wordpress.org/support/users/guxo/) * (@guxo) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/) * i had this error in the frontpage after upgrade to 2.3 * > WordPress database error: [Table ‘a19108.wp_categories’ doesn’t exist] > SELECT > cat_id, cat_name FROM wp_categories WHERE link_count >= 1 * check this error @ [http://www.joaorico.com](http://www.joaorico.com) Viewing 10 replies - 1 through 10 (of 10 total) * [spencerp](https://wordpress.org/support/users/spencerp/) * (@spencerp) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-624880) * You running plugins that might query THAT table? As Ryan Boren stated: “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.” * These three tables were dropped after/during your upgrade: categories, post2cat, and link2cat. Please disable any plugins that might be using one of those three older tables, and try again. You can look [here](http://codex.wordpress.org/Plugins/Plugin_Compatibility/2.3) to see if your plugins were updated for 2.3 or not. Thanks. * [Arne](https://wordpress.org/support/users/arnee/) * (@arnee) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-624881) * Somebody should make a sticky post about DB errors. * [spencerp](https://wordpress.org/support/users/spencerp/) * (@spencerp) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-624882) * I know, I totally agree. LOL! * p.s. oh geez, enough of this repeating self all day and night, I’m going to bed! later folks! lmao * Thread Starter [guxo](https://wordpress.org/support/users/guxo/) * (@guxo) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-624884) * i deactivate all plug-ins, one by one, and the message didn’t disappear * the problematic code is: * > > >

Archives

> - > if (wp_version() == ’20’) { $link_cats = $wpdb->get_results(“SELECT > cat_id, cat_name FROM $wpdb->linkcategories”); } else { $link_cats = $wpdb- > >get_results(“SELECT cat_id, cat_name FROM $wpdb->categories WHERE link_count > >= 1”); } foreach ($link_cats as $link_cat) { ?> > > * [spencerp](https://wordpress.org/support/users/spencerp/) * (@spencerp) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-624907) * Nice catch guxo! I added this to the sticky on front page.. [http://wordpress.org/support/topic/135564?replies=2#post-620698](http://wordpress.org/support/topic/135564?replies=2#post-620698) * [cliffmaster](https://wordpress.org/support/users/cliffmaster/) * (@cliffmaster) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-625113) * Hello, I get the following error when posting or editing a page or post. However the page and posts will still take the edit. This happens right after I hit save. All my plugins show updated. * Here is the error I get * **WordPress database error: [Table ‘db208998606.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 * Thanks in advance for any help I can get. * [Geezerjim](https://wordpress.org/support/users/actorjiml/) * (@actorjiml) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-625114) * Take a look at the sticky post spencerp referenced above. * [cliffmaster](https://wordpress.org/support/users/cliffmaster/) * (@cliffmaster) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-625139) * The problem was the google site-map generator. I had version 3.0 but the problem was, I downloaded it prior to 9/24/2007. * [doc_holiday](https://wordpress.org/support/users/doc_holiday/) * (@doc_holiday) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-625150) * As many posts as there has been google site map generator, there should be a sticky!!!!!!!!!!!!! * [rabmaster](https://wordpress.org/support/users/rabmaster/) * (@rabmaster) * [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-625323) * Basically, you should be removing all references to the old wp_categories etc that aren’t there any more and replacing them with new ones, or just taking them out for now. Or any plugins that call these tables! * Get the newest (compatible) plugins, or fix them yourself. * A lot of themes have stuff that calls them too, so check in Sidebar.php, footers and headers, depending on your theme. * It is a bit of a pain, but worth it when one considers just how good WordPress is! Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘WordPress database error @ 2.3’ is closed to new replies. ## Tags * [categories](https://wordpress.org/support/topic-tag/categories/) * [database](https://wordpress.org/support/topic-tag/database/) * In: [Requests and Feedback](https://wordpress.org/support/forum/requests-and-feedback/) * 10 replies * 7 participants * Last reply from: [rabmaster](https://wordpress.org/support/users/rabmaster/) * Last activity: [18 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-23/#post-625323) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics