[wp-trac] [WordPress Trac] #40592: duplicate key name in 4.7.4
WordPress Trac
noreply at wordpress.org
Fri Apr 28 08:06:46 UTC 2017
#40592: duplicate key name in 4.7.4
--------------------------+----------------------
Reporter: hiheaven01 | Owner:
Type: defect (bug) | Status: closed
Priority: normal | Milestone:
Component: General | Version:
Severity: normal | Resolution: invalid
Keywords: | Focuses:
--------------------------+----------------------
Changes (by ocean90):
* status: new => closed
* component: Administration => General
* version: 4.7.4 =>
* milestone: Awaiting Review =>
* resolution: => invalid
Old description:
> 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
New description:
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
}}}
--
Comment:
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.
--
Ticket URL: <https://core.trac.wordpress.org/ticket/40592#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform
More information about the wp-trac
mailing list