Title: WordPress DB Error-**.wp_terms doesnt exist Last modified: August 18, 2016 --- # WordPress DB Error-**.wp_terms doesnt exist * [ibuildtraffic2](https://wordpress.org/support/users/ibuildtraffic2/) * (@ibuildtraffic2) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/) * Greetings, * I just finished upgrading to 2.3 and was met with the following: ————————— WordPress database error: [Table ‘affbiz_wrdp1.wp_terms’ doesn’t exist] SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND t.slug = ‘wp-admin’ ORDER BY t.name ASC * WordPress database error: [Table ‘affbiz_wrdp1.wp_terms’ doesn’t exist] SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND t.slug = ‘wp-admin’ ORDER BY t.name ASC * WordPress database error: [Table ‘affbiz_wrdp1.wp_term_relationships’ doesn’t exist] SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships. term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND post_name = ‘upgradephp’ AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy. term_id IN (‘0’) AND post_type = ‘post’ GROUP BY wp_posts.ID ORDER BY post_date DESC —————————— * Tell me what to do and I will do it… * Thanks in advance, * JJH Viewing 9 replies - 1 through 9 (of 9 total) * [Jeremy Clark](https://wordpress.org/support/users/jeremyclark13/) * (@jeremyclark13) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633171) * Did you run the upgrade script. It’s [Step 2 here](http://codex.wordpress.org/Upgrading_WordPress). * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633172) * Makes me think the new terms database tables didn’t get created. * If necessary, try forcing a database upgrade. * If that doesn’t work you might have to restore to your database backup and do the upgrade again. * See: [How do I force a database upgrade?](http://codex.wordpress.org/FAQ_Installation#How_do_you_force_a_database_upgrade.3F) * [Desdichado](https://wordpress.org/support/users/desdichado/) * (@desdichado) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633221) * I am getting somewhat similar errors when posts or comments are published… * I got this error when I tried to write a comment to one of my posts: * WordPress database error: [Table ‘whatwedig.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 * I tried to force a database upgrade, but got this error: * WordPress database error: [Table ‘whatwedig.wp_categories’ doesn’t exist] SELECT* FROM wp_categories ORDER BY cat_ID WordPress database error: [Table ‘whatwedig. wp_post2cat’ doesn’t exist] SELECT * FROM wp_post2cat WordPress database error:[ Table ‘whatwedig.wp_link2cat’ doesn’t exist] SELECT * FROM wp_link2cat * Then I just noticed in my Manage Posts Page, the last post I posted says under the Category Column: * WordPress database error: [Table ‘whatwedig.wp_categories’ doesn’t exist] SELECT categories.cat_ID FROM wp_categories as categories WHERE categories.category_nicename = ‘blog’ LIMIT 1 * Everything is still posting and the site works fine, but users are redirected to these error pages when posting comments. Any thoughts? * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633232) * _I am getting somewhat similar errors_ * Not true. Your error is completely different and it is addressed in one of the“ sticky” posts on the main page of the forum. * [Desdichado](https://wordpress.org/support/users/desdichado/) * (@desdichado) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633241) * Thanks, I checked it out and I had not updated Google Site Maps. * Thanks! * Thread Starter [ibuildtraffic2](https://wordpress.org/support/users/ibuildtraffic2/) * (@ibuildtraffic2) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633310) * OK…I ran the “Forced Upgrade” and upon successful completion was presented with the following: * ———————————————– * WordPress database error: [Table ‘affbiz_wrdp1.wp_categories’ doesn’t exist] SELECT * FROM wp_categories ORDER BY cat_ID * WordPress database error: [Table ‘affbiz_wrdp1.wp_post2cat’ doesn’t exist] SELECT* FROM wp_post2cat * WordPress database error: [Table ‘affbiz_wrdp1.wp_link2cat’ doesn’t exist] SELECT* FROM wp_link2cat Upgrade Complete * Your WordPress database has been successfully upgraded! * ———————————————– * Note that is also says the db was successfully upgraded…. * Next task? * And thank you for taking time out of **your** day to help **me**–**you are appreciated.** * Thread Starter [ibuildtraffic2](https://wordpress.org/support/users/ibuildtraffic2/) * (@ibuildtraffic2) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633322) * I began deactivating plug-ins and have managed to get all of the on-page visible code to go away except one instance-in the top left corner-that says: * ‘WordPress database error: [Table ‘affbiz_wrdp1.wp_categories’ doesn’t exist] SELECT * FROM wp_categories ‘ * Do I just continue deactivating plug-ins? * Thanks much! * jjh * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633335) * There is no wp_categories table in WP 2.3 – so it must be either a plugin or a line of custom code calling for that table. It might simply be the theme is not compatible with 2.3 * Thread Starter [ibuildtraffic2](https://wordpress.org/support/users/ibuildtraffic2/) * (@ibuildtraffic2) * [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633338) * Moshu… * I’ve deactivated each and every plug-in. I’ve even removed some of the suspect ones using phpMyAdmin/wp_options. * As of right now I have no plug-ins activated and maybe 5 total are even uploaded/ installed. * Theme is 2.3 compatible… * What next? Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘WordPress DB Error-**.wp_terms doesnt exist’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 9 replies * 5 participants * Last reply from: [ibuildtraffic2](https://wordpress.org/support/users/ibuildtraffic2/) * Last activity: [18 years, 7 months ago](https://wordpress.org/support/topic/wordpress-db-error-wp_terms-doesnt-exist/#post-633338) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics