Update error – duplicate key name

  • Resolved kazonline

    (@kazonline)


    11 years, 2 months ago

    Hiya,

    I’ve just updated OpenTickets Community Edition and now I get this on every WP page:

    WordPress database error Multiple primary key defined for query ALTER TABLE 93h9unZh_qsot_ticket_codes ADD PRIMARY KEY oiid (order_item_id) made by require_once(‘D:\vhosts\lomvc.org.uk\lomvc.org\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, qsot_db_upgrader::admin_init, qsot_db_upgrader::_maybe_update_db, dbDelta
    WordPress database error Duplicate key name ‘tc’ for query ALTER TABLE 93h9unZh_qsot_ticket_codes ADD INDEX tc (ticket_code(250)) made by require_once(‘D:\vhosts\lomvc.org.uk\lomvc.org\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, qsot_db_upgrader::admin_init, qsot_db_upgrader::_maybe_update_db, dbDelta
    WordPress database error Multiple primary key defined for query ALTER TABLE 93h9unZh_qsot_price_structures ADD PRIMARY KEY psid (id) made by require_once(‘D:\vhosts\lomvc.org.uk\lomvc.org\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, qsot_db_upgrader::admin_init, qsot_db_upgrader::_maybe_update_db, dbDelta
    WordPress database error Duplicate key name ‘ea’ for query ALTER TABLE 93h9unZh_qsot_price_structures ADD INDEX ea (event_area_id) made by require_once(‘D:\vhosts\lomvc.org.uk\lomvc.org\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, qsot_db_upgrader::admin_init, qsot_db_upgrader::_maybe_update_db, dbDelta
    WordPress database error Duplicate key name ‘ps2p’ for query ALTER TABLE 93h9unZh_qsot_price_structure_prices ADD UNIQUE KEY ps2p (price_struct_id, product_id, sub_group) made by require_once(‘D:\vhosts\lomvc.org.uk\lomvc.org\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, qsot_db_upgrader::admin_init, qsot_db_upgrader::_maybe_update_db, dbDelta
    WordPress database error Duplicate key name ‘pid’ for query ALTER TABLE 93h9unZh_qsot_price_structure_prices ADD INDEX pid (product_id) made by require_once(‘D:\vhosts\lomvc.org.uk\lomvc.org\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, qsot_db_upgrader::admin_init, qsot_db_upgrader::_maybe_update_db, dbDelta

    Not totally sure what to do now 🙁

    Karen

    https://ww.wp.xz.cn/plugins/opentickets-community-edition/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author loushou

    (@loushou)

    11 years, 2 months ago

    Hey Karen (@kazonline),

    I will look at this immediately.

    Loushou

    Plugin Author loushou

    (@loushou)

    11 years, 2 months ago

    @kazonline – can you remove the plugin via ftp from your dev site that we worked on in the past please. Thanks.

    Loushou

    Thread Starter kazonline

    (@kazonline)

    11 years, 2 months ago

    Hi Loushou,
    Sorry – I’ve been away from my system all day. I’ve now deleted the opentickets folder.
    Kind regards,
    Karen

    Plugin Author loushou

    (@loushou)

    11 years, 2 months ago

    @kazonline – no problem. thanks. I will start looking back into it.

    Loushou

    Plugin Author loushou

    (@loushou)

    11 years, 2 months ago

    Hey @kazonline ,

    As it turns out, your site falls into a rare, yet obviously possible category, that was causing a bit of a mishap with the latest updater code. The short version is that your ‘database prefix’ is not wp_, it is random characters. This is a normal situation, but what makes yours rather rare is that yours has a combination of lower and uppercase letters.

    <nerdAlert> MySQL is case insensitive for table names, so having an upper case letter is identical to having the same lower case letter. This caused a mismatch when determining if your db tables were up to date in our software. I have adjusted our software to account for this situation, which is in the latest version of 1.10.8. In addition, I did find that GAMP also needed a minor update to be more compatible with the latest updater code in OpenTickets Community Edition core.</nerdAlert>

    Both the new version of the OTCE plugin, 1.10.8, and the new version of GAMP, 1.2.5, are installed on the dev site. You will need to reinstall/update OTCE on your live site to the latest version, and then grab and install a new version of GAMP from your my account page on our website. As usual, thanks for looping us in on this, and let us know how this resolves the issue.

    Sincerely,
    Loushou

    Thread Starter kazonline

    (@kazonline)

    11 years, 2 months ago

    Hi Loushou,

    All working fine now. Many thanks for your help.

    Kind regards,

    Karen

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Update error – duplicate key name’ is closed to new replies.