WordPress.org

Forums

ZipList Recipe Plugin
[Plugin: Ziplist Recipe Plugin] (5 posts)

  1. deanpence
    Member
    Posted 3 years ago #

    I'm a server admin, not a plugin user, but it appears that after upgrading to v1.4, your plugin attempts to update the database table using dbDelta() inside the amd_zlrecipe_install() function, and I'm getting this notice in my logs:

    WordPress database error Multiple primary key defined for query ALTER TABLE wp_amd_zlrecipe_recipes CHANGE COLUMN recipe_id recipe_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY made by require, require_once, require_once, require_once, do_action, call_user_func_array, amd_zlrecipe_install, dbDelta

    I haven't received any complaints from my client who is using it, but I seem to get the error for every PHP request that loads the plugin.

    I think the correct SQL to modify a column without changing its name is:

    ALTER TABLE wp_amd_zlrecipe_recipes MODIFY COLUMN recipe_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;

    But the wp_amd_zlrecipe_recipes column does not need to be modified; it's already defined as BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY.

    Ideas? We're on WordPress 3.2.1, PHP 5.3.8, and MySQL 5.1.56.

    http://wordpress.org/extend/plugins/ziplist-recipe-plugin/

  2. ZipList
    Member
    Plugin Author

    Posted 3 years ago #

    Hi Dean,

    I'm the developer of the plugin. Thanks so much for your note -- indeed, we have seen one other reports of this and we have been hoping to find someone with a reproducible case to help us work through the undocumented guts of dbDelta.

    I have a couple of code changes I would like to try and I'm wondering if you can help me see what's going on from the DB side?

    If you could drop me a note at plugins@ziplist.com, I'd love your help in resolving this issue. :)

  3. ZipList
    Member
    Plugin Author

    Posted 3 years ago #

    Dean,

    I've discovered something in the plugin code that may be the cause of the problem you reported. I've made a fix that I'd like to confirm does fix your issue before I release a new plugin version.

    Please drop me a note at plugins@ziplist.com and I will follow up with you.

  4. Auntie
    Member
    Posted 3 years ago #

    I am having the exact same problem. My error log is getting humongous at this point (gotta do something about that), I am posting to see if I get an update soon.

  5. deanpence
    Member
    Posted 3 years ago #

    @Auntie,

    Have you upgraded to the latest version (1.41)? I'm pretty sure it fixes the problem.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • ZipList Recipe Plugin
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic