database error Multiple primary key defined

Fixed in version 0.3.8.

Thank you for reporting.

Hello
Thank you.
I did upgrade this morning but still have same messages when using admin pages :

[Wed May 14 08:55:11 2014] [error] [client 160.53.250.119] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-login.php?redirect_to=http%3A%2F%2Fcigarette-electronique-geneve.com%2Fwp-admin%2F&reauth=1
[Wed May 14 08:55:12 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/
[Wed May 14 08:55:12 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/
[Wed May 14 08:55:20 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/
[Wed May 14 08:55:24 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/edit.php
[Wed May 14 08:55:25 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/post.php?post=217&action=edit
[Wed May 14 08:55:25 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/post.php?post=217&action=edit
[Wed May 14 08:55:38 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/post.php?post=217&action=edit
[Wed May 14 08:55:38 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/post.php?post=217&action=edit
[Wed May 14 08:55:42 2014] [error] [client 160.53.250.126] WordPress database error Multiple primary key defined for query ALTER TABLE wp_mdp_reviews ADD PRIMARY KEY id (id) made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, mdpInfo::mdp_register, dbDelta, referer: https://www.cigarette-electronique-geneve.com/wp-admin/plugins.php

Hello
even now i run 0.4.0 version and there is still same problem, do you have any idea why ?

Hi,
I have founded the same problem and here are the steps to fix it.

Try to locate Create Table statement in your plugin.
the create statement of any table should look something like below.
$invoice_table_query = “CREATE TABLE invoice (
order_id int(11),
invoice_html TEXT NOT NULL,
PRIMARY KEY (order_id)
)”;
dbDelta($gdp_user_detail);

in above example, u will see that to make dbDelta function work properly you have to enter each field in new line and to get rid of primary key related issue, you have to put double space between PRIMARY KEY keyword and ().
I have double space here between PRIMARY KEY and (order_id)
PRIMARY KEY (order_id)
along this dont put any space between () and the key inside of these small brackets.
PRIMARY KEY ( order_id ) this is wrong, u will get error.
PRIMARY KEY (order_id) this is right without any space.

Hope this will help.

Wordprees editor has removed double space between PRIMARY KEY and ().

Try to put double space instead of single space there.

Thanks