Title: Database Error: Multiple primary key defined
Last modified: August 22, 2016

---

# Database Error: Multiple primary key defined

 *  Resolved [milican](https://wordpress.org/support/users/milican/)
 * (@milican)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/database-error-multiple-primary-key-defined-1/)
 * Hello,
 * I’m using the Debug Bar plugin to report errors from WordPress. It is reporting
   the following database error:
 * ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) /* From [develare140818.wpengine.
   com/wp-admin/plugins.php] in [/nas/wp/www/cluster-3110/develare140818/wp-content/
   plugins/mdp-local-business-seo/index.php:290] */
 * The plugin version I’m using is 0.4.9.
 * [https://wordpress.org/plugins/mdp-local-business-seo/](https://wordpress.org/plugins/mdp-local-business-seo/)

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

 *  [tcolling](https://wordpress.org/support/users/tcolling/)
 * (@tcolling)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/database-error-multiple-primary-key-defined-1/#post-5202198)
 * I am seeing this also.
 * I don’t understand why this plugin is causing this fundamental database error(
   if in fact it is).
 * However, the other thing that I’m curious about is why it’s modifying the database
   at all. Once its settings are recorded, why would it need to make any changes
   to the database after that?
 *  Plugin Author [christopherdubeau](https://wordpress.org/support/users/christopherdubeau/)
 * (@christopherdubeau)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/database-error-multiple-primary-key-defined-1/#post-5202207)
 * I believe I corrected the issue in the new release.
 * Please upgrade and let me know.
 *  [rotthier](https://wordpress.org/support/users/rotthier/)
 * (@rotthier)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/database-error-multiple-primary-key-defined-1/#post-5202209)
 * Hello, I updated your plugin but I have always the following error:
 * [04-Sep-2014 07:52:02 UTC] WordPress database error Multiple primary key defined
   for query ALTER TABLE massage_mdp_reviews ADD PRIMARY KEY id (id) made by do_action(‘
   admin_init’), call_user_func_array, mdpInfo::mdp_register, dbDelta
    [04-Sep-2014
   07:52:02 UTC] WordPress database error Duplicate key name ‘pid’ for query ALTER
   TABLE massage_mdp_reviews ADD UNIQUE KEY pid (pid) made by do_action(‘admin_init’),
   call_user_func_array, mdpInfo::mdp_register, dbDelta
 * I’m on a shared hosting
    php Version: 5.4.31 Sql Version: 5.5.37-cll Apache: 
   2.2.27 Achitecture: x86_64 linux wordpress 3.9.2 Local business SEO version :
   0.5.2
 * Thank you to tell me what I need to do to eliminate this error
    have a nice day
 *  Plugin Author [christopherdubeau](https://wordpress.org/support/users/christopherdubeau/)
 * (@christopherdubeau)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/database-error-multiple-primary-key-defined-1/#post-5202238)
 * Please upgrade to 5.3

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

The topic ‘Database Error: Multiple primary key defined’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/mdp-local-business-seo_e0d4e1.svg)
 * [Local Business SEO](https://wordpress.org/plugins/mdp-local-business-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mdp-local-business-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mdp-local-business-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/mdp-local-business-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mdp-local-business-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mdp-local-business-seo/reviews/)

## Tags

 * [bar](https://wordpress.org/support/topic-tag/bar/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [key](https://wordpress.org/support/topic-tag/key/)
 * [primary](https://wordpress.org/support/topic-tag/primary/)

 * 4 replies
 * 4 participants
 * Last reply from: [christopherdubeau](https://wordpress.org/support/users/christopherdubeau/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/database-error-multiple-primary-key-defined-1/#post-5202238)
 * Status: resolved