Title: 2.6 missing categories wp_terms table error
Last modified: August 19, 2016

---

# 2.6 missing categories wp_terms table error

 *  Resolved 750825
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/)
 * I upgraded from some 2.1 version (I think…not sure) to 2.6. Everything works 
   fine except for that the category descriptions are blank. In the wp_categories
   table, they’re listed correctly, but not in the wp_terms table.
 * Whatever version of WP I had before didn’t use the wp_terms table, so I copied
   the info from the wp_categories table and tried to paste it into the wp_terms
   table. I get [this](http://www.whatmyworldslike.com/error/Picture2.png) error
   message each time.
 * I’m entering the following sql code. Any idea what’s wrong with the code?
 * >  —
   >  — Data contents of table `wp_terms` —
   > INSERT INTO `wp_terms` VALUES (1, ‘Uncategorized’, ‘uncategorized’, ”, 0, 5,
   > 0, 0, 0) ;
   >  INSERT INTO `wp_terms` VALUES (2, ‘Cool Blogs’, ‘cool-blogs’, ”,
   > 0, 0, 5, 0, 0) ; INSERT INTO `wp_terms` VALUES (3, ‘Inspiring’, ‘inspiring’,”,
   > 0, 34, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (4, ‘Via Email’, ‘via-email’,”,
   > 0, 1, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (5, ‘Health’, ‘health’, ”, 0,
   > 12, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (6, ‘Give time/money’, ‘give-timemoney’,”,
   > 0, 6, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (7, ‘Read this’, ‘read-this’,”,
   > 0, 5, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (8, ‘Pay attention’, ‘pay-attention’,”,
   > 0, 58, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (9, ‘Moment of Truth’, ‘moment-
   > of-truth’, ”, 0, 69, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (10, ‘Watch this’,‘
   > watch-this’, ”, 0, 28, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (11, ‘Research’,‘
   > research’, ”, 0, 1, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (12, ‘Random’,‘
   > random’, ”, 0, 13, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (13, ‘Thoughts’,‘
   > thoughts’, ”, 0, 27, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (14, ‘Plain cool’,‘
   > plain-cool’, ”, 0, 22, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (15, ‘Website’,‘
   > website’, ”, 0, 11, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (16, ‘Do your 
   > reseach!’, ‘do-your-reseach’, ”, 0, 26, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES(
   > 17, ‘Learn something’, ‘learn-something’, ”, 0, 9, 0, 0, 0) ; INSERT INTO `
   > wp_terms` VALUES (18, ‘Rewritable words’, ‘quotations-rewriteable-words’, ”,
   > 0, 14, 0, 0, 0) ; INSERT INTO `wp_terms` VALUES (19, ‘What My World Sounds 
   > Like’, ‘what-my-world-sounds-like’, ”, 0, 14, 0, 0, 0) ; INSERT INTO `wp_terms`
   > VALUES (20, ‘Listen’, ‘listen’, ”, 0, 13, 0, 0, 0) ; INSERT INTO `wp_terms`
   > VALUES (21, ‘Spotlight’, ‘spotlight’, ”, 0, 11, 0, 0, 0) ; INSERT INTO `wp_terms`
   > VALUES (22, ‘Consider this’, ‘consider-this’, ”, 0, 32, 0, 0, 0) ; INSERT INTO`
   > wp_terms` VALUES (23, ‘Great ideas’, ‘great-ideas’, ”, 0, 3, 0, 0, 0) ; INSERT
   > INTO `wp_terms` VALUES (24, ‘The Visual’, ‘the-visual’, ”, 0, 3, 0, 0, 0) ;
   > INSERT INTO `wp_terms` VALUES (25, ‘Challenge’, ‘challenge’, ”, 0, 1, 0, 0,
   > 0) ; — –End of data contents of table ‘wp_terms’

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

 *  Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/)
 * (@otto42)
 * WordPress.org Admin
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811538)
 * The terms table is not an exact replica of the older categories table and you
   can’t just change names like that willy nilly.
 * Just put your descriptions in again if they got lost.
 *  Thread Starter 750825
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811545)
 * Where do I put the descriptions in?
 *  Thread Starter 750825
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811549)
 * I emptied the wp_terms table so the list of categories isn’t there anymore. Is
   there anyway to reload the table? Or downgrade and try upgrading again?
 *  752808
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811622)
 * I had the same error, solved it yesterday night 🙂
 * My experience with it: [http://blog.cumps.be/wordpress-26-upgrade-categories-missing/](http://blog.cumps.be/wordpress-26-upgrade-categories-missing/)
 * You’ll have to edit 1 table and then fiddle a bit in the admin section to get
   your links working again 🙂
 *  752808
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811752)
 * Apparently there are more people having problems, made a post to give something
   back to the community, detailing what I did to fix it with screenshots 🙂
 * [http://blog.cumps.be/wordpress-26-upgrade-fix-missing-categories/](http://blog.cumps.be/wordpress-26-upgrade-fix-missing-categories/)
 * Good luck fixing it elleepiphany2
 *  Thread Starter 750825
 * [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811784)
 * It worked! I’m elated. Thank you.

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

The topic ‘2.6 missing categories wp_terms table error’ is closed to new replies.

## Tags

 * [categories](https://wordpress.org/support/topic-tag/categories/)
 * [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/)
 * 6 replies
 * 3 participants
 * Last reply from: 750825
 * Last activity: [17 years, 11 months ago](https://wordpress.org/support/topic/26-missing-categories-wp_terms-table-error/#post-811784)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics