Title: clockspot's Replies | WordPress.org

---

# clockspot

  [  ](https://wordpress.org/support/users/clockspot/)

 *   [Profile](https://wordpress.org/support/users/clockspot/)
 *   [Topics Started](https://wordpress.org/support/users/clockspot/topics/)
 *   [Replies Created](https://wordpress.org/support/users/clockspot/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/clockspot/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/clockspot/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/clockspot/engagements/)
 *   [Favorites](https://wordpress.org/support/users/clockspot/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Category creation problem after upgrading to 2.5.1](https://wordpress.org/support/topic/category-creation-problem-after-upgrading-to-251/)
 *  [clockspot](https://wordpress.org/support/users/clockspot/)
 * (@clockspot)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/category-creation-problem-after-upgrading-to-251/#post-757469)
 * I’m a little late to the party, but if you still need help, here’s my two cents–
 * I ran into this issue, and in my case, the problem was that WordPress’ database
   user didn’t have sufficient privileges to alter the structure of the database,
   so the upgrades weren’t quite going through.
 * So I gave the user structure-altering privileges (create, drop, alter, etc) and
   [forced a database upgrade](http://codex.wordpress.org/FAQ_Installation#How_do_you_force_a_database_upgrade.3F),
   and my previously missing categories came right back.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Blogroll problem after upgrading to 2.5.1](https://wordpress.org/support/topic/blogroll-problem-after-upgrading-to-251/)
 *  [clockspot](https://wordpress.org/support/users/clockspot/)
 * (@clockspot)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/blogroll-problem-after-upgrading-to-251/#post-757468)
 * I’m a little late to the party, but hopefully this will help:
 * I received the “could not insert term into the database” error, and it turned
   out WordPress’ database user didn’t have sufficient privileges to alter the structure
   of the table during an upgrade. So the upgrades weren’t quite going through. 
   But after giving it enough privileges and forcing a database upgrade as above,
   it worked perfectly, and my previously missing data came back.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to add a category?](https://wordpress.org/support/topic/how-to-add-a-category/)
 *  [clockspot](https://wordpress.org/support/users/clockspot/)
 * (@clockspot)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/how-to-add-a-category/#post-789510)
 * I had this problem and solved it today. As MichaelH suspected, it was an upgrade
   problem – it turned out my WordPress database user didn’t have enough privileges
   to complete the upgrades.
 * In my case, I hadn’t lost my categories; they were still in the old wp_categories
   table, which was supposed to have been replaced with the trio of wp_term tables
   somewhere along the line. The thing was, even though I had upgraded, WordPress
   hadn’t changed the database structure.
 * So I gave its database user privileges to alter the structure (create, drop, 
   alter, etc) and forced a database upgrade as above, and it worked! My categories
   are once again listed in the admin panel and my posts still belong to them.
 * I hope that helps!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Could not insert term into the database](https://wordpress.org/support/topic/could-not-insert-term-into-the-database/)
 *  [clockspot](https://wordpress.org/support/users/clockspot/)
 * (@clockspot)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/could-not-insert-term-into-the-database/#post-817444)
 * I was having this issue, and it turned out the problem was that WordPress’s database
   user didn’t have sufficient privileges to do all the things WordPress needed 
   to (mostly during upgrading, like creating and dropping tables).
 * After I gave the user enough privileges, I [forced a database upgrade](http://codex.wordpress.org/FAQ_Installation#How_do_you_force_a_database_upgrade.3F)
   and my missing categories came right back.
 * Hope that helps!

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