Title: SQL Database gimped
Last modified: August 18, 2016

---

# SQL Database gimped

 *  [tav](https://wordpress.org/support/users/tav/)
 * (@tav)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/sql-database-gimped/)
 * After the upgrade from 2.2 to 2.3, numerous errors have happened for me. Right
   now, I am unable to change the category of any posts with the “manage, category”
   function.
 * For whatever reason, there is something in the SQL database which is still referencing
   the wp_categories table which I believe was changed in 2.3. I did the regular
   upgrade routing and it seemed to work ok, and I’m not using any plugins to manage
   the categories – just simply editing an existing post and trying to ‘re-categorize’
   it which produces the following error.
 * WordPress database error: [Table ‘gymskinz_blog.wp_categories’ doesn’t exist]
   
   SELECT c.cat_ID AS ID, MAX(p.post_modified) AS last_mod FROM `wp_categories` 
   c, `wp_post2cat` pc, `wp_posts` p WHERE pc.category_id = c.cat_ID AND p.ID = 
   pc.post_id AND p.post_status = ‘publish’ AND p.post_type=’post’ GROUP BY c.cat_id
 * any way to fix this easily? Or should I just wipe the entire thing and start 
   from scratch again with a brand new 2.3 install (?!?!)
 * thanx
    T.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Jeremy Clark](https://wordpress.org/support/users/jeremyclark13/)
 * (@jeremyclark13)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/sql-database-gimped/#post-646061)
 * The sticky at the top of the forums is about this.
    [http://wordpress.org/support/topic/135564?replies=75](http://wordpress.org/support/topic/135564?replies=75)
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/sql-database-gimped/#post-646062)
 * Since wp-categories no longer exists (replace by the terms tables) I’d guess 
   you did NOT delete the old WordPress files.
 * Please consider deleting the WordPress files and reuploading as per Steps 7 and
   8 in [Upgrading_WordPress_Extended](http://codex.wordpress.org/Upgrading_WordPress_Extended).
 * And what jeremy said — essentially make sure you have compatible themes and plugins.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL Database gimped’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [18 years, 5 months ago](https://wordpress.org/support/topic/sql-database-gimped/#post-646062)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics