database error Multiple primary key defined

  • Resolved chuchao2000

    (@chuchao2000)


    9 years, 11 months ago

    Hello
    I did just notice in my error log that i have many error log coming from table wp_mdp_reviews when i’m using WP admin pages :

    [Tue May 13 15:24:29 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: http://www.cigarette-electronique-geneve.com/wp-admin/
[Tue May 13 15:24:37 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: http://www.cigarette-electronique-geneve.com/wp-admin/
[Tue May 13 15:24: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: http://www.cigarette-electronique-geneve.com/wp-admin/themes.php
[Tue May 13 15:24:44 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: http://www.cigarette-electronique-geneve.com/wp-admin/theme-install.php
[Tue May 13 15:25:02 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: http://www.cigarette-electronique-geneve.com/wp-admin/theme-install.php
[Tue May 13 15:25:08 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: http://www.cigarette-electronique-geneve.com/wp-admin/theme-install.php
[Tue May 13 15:25:10 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: http://www.cigarette-electronique-geneve.com/wp-admin/theme-install.php?browse=featured
[Tue May 13 15:25:17 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: http://www.cigarette-electronique-geneve.com/wp-admin/theme-install.php?browse=popular
[Tue May 13 15:25:19 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: http://www.cigarette-electronique-geneve.com/wp-admin/themes.php
[Tue May 13 15:25:19 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: http://www.cigarette-electronique-geneve.com/wp-admin/theme-install.php
[Tue May 13 15:27:37 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: http://www.cigarette-electronique-geneve.com

    Someone has any advices how to solve this issue ???

    Thank you

    https://wordpress.org/plugins/mdp-local-business-seo/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author christopherdubeau

    (@christopherdubeau)

    9 years, 11 months ago

    Fixed in version 0.3.8.

    Thank you for reporting.

    Thread Starter chuchao2000

    (@chuchao2000)

    9 years, 11 months ago

    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: http://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: http://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: http://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: http://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: http://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: http://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: http://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: http://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: http://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: http://www.cigarette-electronique-geneve.com/wp-admin/plugins.php
    Thread Starter chuchao2000

    (@chuchao2000)

    9 years, 11 months ago

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

    globaldirectory

    (@globaldirectory)

    9 years, 3 months ago

    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.

    globaldirectory

    (@globaldirectory)

    9 years, 3 months ago

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

    Try to put double space instead of single space there.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘database error Multiple primary key defined’ is closed to new replies.