Title: WP-CLI & WordPress database error Duplicate key name
Last modified: August 31, 2016

---

# WP-CLI & WordPress database error Duplicate key name

 *  Resolved [philsalt](https://wordpress.org/support/users/philsalt/)
 * (@philsalt)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/wp-cli-wordpress-database-error-duplicate-key-name/)
 * Hi guys,
 * Used WP-CLI to update WooCommerce. At command line the following errors presented
   after “wp plugin update woocommerce”:
 * WordPress database error Duplicate key name ‘attribute_name’ for query ALTER 
   TABLE wp_woocommerce_attribute_taxonomies ADD KEY attribute_name (attribute_name(
   191)) made by include(‘phar:///usr/local/bin/wp/php/boot-phar.php’), include(‘
   phar:///usr/local/bin/wp/php/wp-cli.php’), WP_CLI\Runner->start, WP_CLI\Runner-
   >load_wordpress, require(‘phar:///usr/local/bin/wp/php/wp-settings-cli.php’),
   do_action(‘init’), call_user_func_array, WC_Install::check_version, WC_Install::
   install, WC_Install::create_tables, dbDelta
 * WordPress database error Duplicate key name ‘meta_key’ for query ALTER TABLE 
   wp_woocommerce_termmeta ADD KEY meta_key (meta_key(191)) made by include(‘phar:///
   usr/local/bin/wp/php/boot-phar.php’), include(‘phar:///usr/local/bin/wp/php/wp-
   cli.php’), WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require(‘phar:///
   usr/local/bin/wp/php/wp-settings-cli.php’), do_action(‘init’), call_user_func_array,
   WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta
 * 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(191),download_id) made by include(‘phar:///usr/
   local/bin/wp/php/boot-phar.php’), include(‘phar:///usr/local/bin/wp/php/wp-cli.
   php’), WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require(‘phar:///
   usr/local/bin/wp/php/wp-settings-cli.php’), do_action(‘init’), call_user_func_array,
   WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta
 * WordPress database error Duplicate key name ‘meta_key’ for query ALTER TABLE 
   wp_woocommerce_order_itemmeta ADD KEY meta_key (meta_key(191)) made by include(‘
   phar:///usr/local/bin/wp/php/boot-phar.php’), include(‘phar:///usr/local/bin/
   wp/php/wp-cli.php’), WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require(‘
   phar:///usr/local/bin/wp/php/wp-settings-cli.php’), do_action(‘init’), call_user_func_array,
   WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta
 * WordPress database error Duplicate key name ‘tax_rate_country’ for query ALTER
   TABLE wp_woocommerce_tax_rates ADD KEY tax_rate_country (tax_rate_country(191))
   made by include(‘phar:///usr/local/bin/wp/php/boot-phar.php’), include(‘phar:///
   usr/local/bin/wp/php/wp-cli.php’), WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress,
   require(‘phar:///usr/local/bin/wp/php/wp-settings-cli.php’), do_action(‘init’),
   call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::
   create_tables, dbDelta
 * 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(191)) made
   by include(‘phar:///usr/local/bin/wp/php/boot-phar.php’), include(‘phar:///usr/
   local/bin/wp/php/wp-cli.php’), WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress,
   require(‘phar:///usr/local/bin/wp/php/wp-settings-cli.php’), do_action(‘init’),
   call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::
   create_tables, dbDelta
 * 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(191)) made
   by include(‘phar:///usr/local/bin/wp/php/boot-phar.php’), include(‘phar:///usr/
   local/bin/wp/php/wp-cli.php’), WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress,
   require(‘phar:///usr/local/bin/wp/php/wp-settings-cli.php’), do_action(‘init’),
   call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::
   create_tables, dbDelta
 * 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 include(‘phar:///usr/local/bin/wp/php/boot-phar.
   php’), include(‘phar:///usr/local/bin/wp/php/wp-cli.php’), WP_CLI\Runner->start,
   WP_CLI\Runner->load_wordpress, require(‘phar:///usr/local/bin/wp/php/wp-settings-
   cli.php’), do_action(‘init’), call_user_func_array, WC_Install::check_version,
   WC_Install::install, WC_Install::create_tables, dbDelta
 * Weird log files show no errors. Site runs OK.
 * Cheers,
 * Phil
 * [https://wordpress.org/plugins/woocommerce/](https://wordpress.org/plugins/woocommerce/)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/wp-cli-wordpress-database-error-duplicate-key-name/#post-7190544)
 * See [https://core.trac.wordpress.org/ticket/34870](https://core.trac.wordpress.org/ticket/34870)–
   its a WP issue.

Viewing 1 replies (of 1 total)

The topic ‘WP-CLI & WordPress database error Duplicate key name’ is closed to new
replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/wp-cli-wordpress-database-error-duplicate-key-name/#post-7190544)
 * Status: resolved