WordPress.org

Make WordPress Core

Opened 3 years ago

Closed 3 years ago

#40592 closed defect (bug) (invalid)

duplicate key name in 4.7.4

Reported by: hiheaven01 Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: General Keywords:
Focuses: Cc:

Description (last modified by ocean90)

The images are not displayed in WC 3.0.4 and Wordpress 4.7.4
The 'duplicate key name' error is logged. These errors are show in log. Please help!!


[Fri Apr 28 05:15:43.684219 2017] [:error] [pid 865] [client 172.9.235.107:17115] WordPress database error Duplicate key name 'download_order_key_product' for query ALTER TABLE wp_woocommerce_downloadable_product_permissions ADD KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:43.876266 2017] [:error] [pid 865] [client 172.9.235.107:17115] WordPress database error Duplicate key name 'meta_key' for query ALTER TABLE wp_woocommerce_order_itemmeta ADD KEY `meta_key` (`meta_key`(32)) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:44.162147 2017] [:error] [pid 865] [client 172.9.235.107:17115] WordPress database error Duplicate key name 'tax_rate_state' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY `tax_rate_state` (`tax_rate_state`(2)) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:44.162496 2017] [:error] [pid 865] [client 172.9.235.107:17115] WordPress database error Duplicate key name 'tax_rate_class' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY `tax_rate_class` (`tax_rate_class`(10)) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:44.339277 2017] [:error] [pid 865] [client 172.9.235.107:17115] 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`(10),`location_code`(20)) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:44.652894 2017] [:error] [pid 865] [client 172.9.235.107:17115] 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`(10),`location_code`(20)) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:45.228783 2017] [:error] [pid 865] [client 172.9.235.107:17115] WordPress database error Duplicate key name 'meta_key' for query ALTER TABLE wp_woocommerce_payment_tokenmeta ADD KEY `meta_key` (`meta_key`(32)) /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/class-wc-install.php:438] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

[Fri Apr 28 05:15:46.466240 2017] [:error] [pid 865] [client 172.9.235.107:17115] WordPress database error Table 'wp_lhsupply.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_lock_down_admin' LIMIT 1 /* From [lhsupply.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/lhsupply/wp-content/plugins/woocommerce/includes/admin/class-wc-admin.php:144] */ made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin->prevent_admin_access, get_option, referer: https://lhsupply.wpengine.com/wp-admin/admin.php?page=wpengine-staging

Change History (1)

#1 @ocean90
3 years ago

  • Component changed from Administration to General
  • Description modified (diff)
  • Milestone Awaiting Review deleted
  • Resolution set to invalid
  • Status changed from new to closed
  • Version 4.7.4 deleted

Hello @hiheaven01, welcome to WordPress Trac!

This Trac is used for enhancements and bug reporting for the WordPress core software. For problems with WooCommerce please try their support forums at https://wordpress.org/support/plugin/woocommerce.

Note: See TracTickets for help on using tickets.