WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. deanpence
    Member
    Posted 2 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 2 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 2 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 2 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 2 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

About this Topic