Title: WordPress Database Errors after upgrade to 2.0.1
Last modified: August 22, 2016

---

# WordPress Database Errors after upgrade to 2.0.1

 *  Resolved [ulir](https://wordpress.org/support/users/ulir/)
 * (@ulir)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-errors-after-upgrade-to-201/)
 * Hi there,
    right after upgrading to Code Snippets 2.0.1 I got 2 WordPress Database
   Errors (I have WP_DEBUG activated):
 *     ```
       WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned auto_increment' at line 1]
       ALTER TABLE hptest_snippets CHANGE COLUMN id id bigint(20) not null unsigned auto_increment
   
       WordPress database error: [Multiple primary key defined]
       ALTER TABLE hptest_snippets ADD PRIMARY KEY (id)
       ```
   
 * [https://wordpress.org/plugins/code-snippets/](https://wordpress.org/plugins/code-snippets/)

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

 *  [haleeben](https://wordpress.org/support/users/haleeben/)
 * (@haleeben)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-errors-after-upgrade-to-201/#post-5832833)
 * version 2.0.2 fixed this error for me
 *  Plugin Author [Shea Bunge](https://wordpress.org/support/users/bungeshea/)
 * (@bungeshea)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-errors-after-upgrade-to-201/#post-5832834)
 * I’m glad to hear it. Hopefully it works for everyone else as well.

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

The topic ‘WordPress Database Errors after upgrade to 2.0.1’ is closed to new replies.

 * ![](https://ps.w.org/code-snippets/assets/icon.svg?rev=2148878)
 * [Code Snippets](https://wordpress.org/plugins/code-snippets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/code-snippets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/code-snippets/)
 * [Active Topics](https://wordpress.org/support/plugin/code-snippets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/code-snippets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/code-snippets/reviews/)

## Tags

 * [WordPress database error](https://wordpress.org/support/topic-tag/wordpress-database-error/)

 * 2 replies
 * 3 participants
 * Last reply from: [Shea Bunge](https://wordpress.org/support/users/bungeshea/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-errors-after-upgrade-to-201/#post-5832834)
 * Status: resolved