WordPress.org

Support

Support » Plugins and Hacks » [Plugin: ZipList Recipe Plugin] [Plugin: Ziplist Recipe Plugin]

[Plugin: ZipList Recipe Plugin] [Plugin: Ziplist Recipe Plugin]

  • deanpence
    Member

    @deanpence

    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/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author ZipList
    Member

    @ziplist

    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. 🙂

    Plugin Author ZipList
    Member

    @ziplist

    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.

    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.

    deanpence
    Member

    @deanpence

    @auntie,

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: ZipList Recipe Plugin] [Plugin: Ziplist Recipe Plugin]’ is closed to new replies.