[wp-trac] [WordPress Trac] #40592: duplicate key name in 4.7.4

WordPress Trac noreply at wordpress.org
Fri Apr 28 07:13:14 UTC 2017


#40592: duplicate key name in 4.7.4
----------------------------+-----------------------------
 Reporter:  hiheaven01      |      Owner:
     Type:  defect (bug)    |     Status:  new
 Priority:  normal          |  Milestone:  Awaiting Review
Component:  Administration  |    Version:  4.7.4
 Severity:  normal          |   Keywords:
  Focuses:                  |
----------------------------+-----------------------------
 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

--
Ticket URL: <https://core.trac.wordpress.org/ticket/40592>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list