WordPress.org

Forums

Local Business SEO
[resolved] Database Error: Multiple primary key defined (5 posts)

  1. milican
    Member
    Posted 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/

  2. tcolling
    Member
    Posted 7 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?

  3. christopherdubeau
    Member
    Plugin Author

    Posted 7 months ago #

    I believe I corrected the issue in the new release.

    Please upgrade and let me know.

  4. rotthier
    Member
    Posted 7 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

  5. christopherdubeau
    Member
    Plugin Author

    Posted 7 months ago #

    Please upgrade to 5.3

Reply

You must log in to post.

About this Plugin

  • Local Business SEO
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic