Title: database error message
Last modified: August 22, 2016

---

# database error message

 *  Resolved [Michael](https://wordpress.org/support/users/alchymyth/)
 * (@alchymyth)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-error-message-7/)
 * after upgrading to version 2.0.1 I get this error message:
 * >  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 wp_snippets CHANGE
   > COLUMN id id bigint(20) not null unsigned auto_increment
   > WordPress database error: [Multiple primary key defined]
   >  ALTER TABLE wp_snippets
   > ADD PRIMARY KEY (id)
 * [https://wordpress.org/plugins/code-snippets/](https://wordpress.org/plugins/code-snippets/)

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

 *  [kcsf](https://wordpress.org/support/users/kcsf/)
 * (@kcsf)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-error-message-7/#post-5842775)
 * same here..
 *  [Steven](https://wordpress.org/support/users/shazahm1hotmailcom/)
 * (@shazahm1hotmailcom)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-error-message-7/#post-5842880)
 * I have the Query Monitor plugin installed on my dev site and when updating to
   2.0.1 Query Monitor shows these two error messages:
 * **Query:**
 *     ```
       ALTER TABLE wp_snippets CHANGE COLUMN id id bigint(20) not null unsigned auto_incremen
       ```
   
 * **Call Stack:**
 *     ```
       create_code_snippets_tables()
       code_snippets_upgrader()
       do_action('plugins_loaded')
       ```
   
 * **Component:**
 *     ```
       Plugin: code-snippets
       ```
   
 * **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
       ```
   
 * **Query:**
 *     ```
       ALTER TABLE wp_snippets ADD PRIMARY KEY (id)
       ```
   
 * **Call Stack:**
 *     ```
       create_code_snippets_tables()
       code_snippets_upgrader()
       do_action('plugins_loaded')
       ```
   
 * **Component:**
 *     ```
       Plugin: code-snippets
       ```
   
 * **Error:**
 *     ```
       Multiple primary key defined
       ```
   
 *  Plugin Author [Shea Bunge](https://wordpress.org/support/users/bungeshea/)
 * (@bungeshea)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-error-message-7/#post-5842884)
 * This should be fixed in version 2.0.2. Sorry for the oversight.

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

The topic ‘database error message’ 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/)

 * 3 replies
 * 4 participants
 * Last reply from: [Shea Bunge](https://wordpress.org/support/users/bungeshea/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/database-error-message-7/#post-5842884)
 * Status: resolved