Opened 8 years ago
Closed 8 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 )
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)
Note: See
TracTickets for help on using
tickets.
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.