Support » Plugin: WooCommerce » WordPress database error – Duplicate key name

  • I have notice during the upgrade of both Version 2.6.6 and 2.6.7 the following PHP notice in my logs, with debug on.

    [28-Oct-2016 15:16:41 UTC] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_tax_rate_locations ADD KEY 'location_type_code' ('location_type'(40),'location_code'(90)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta
    [28-Oct-2016 15:16:41 UTC] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_shipping_zone_locations ADD KEY 'location_type_code' ('location_type'(40),'location_code'(90)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta

    It only happens during the update. During normal operations, there is no issue, but I don’t know whether this can have side effects.

    Any recommendation on how to resolve this and can this be reproduce by others?

    • This topic was modified 3 years, 8 months ago by decarvalhoaa.
    • This topic was modified 3 years, 8 months ago by decarvalhoaa.
    • This topic was modified 3 years, 8 months ago by decarvalhoaa.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress database error – Duplicate key name’ is closed to new replies.