Database Error: Multiple primary key defined

  • Resolved milican

    (@milican)


    11 years, 8 months ago

    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/

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

    (@tcolling)

    11 years, 8 months ago

    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

    (@christopherdubeau)

    11 years, 8 months ago

    I believe I corrected the issue in the new release.

    Please upgrade and let me know.

    rotthier

    (@rotthier)

    11 years, 8 months ago

    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

    (@christopherdubeau)

    11 years, 7 months ago

    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.