Title: Database Error on Activation
Last modified: September 1, 2016

---

# Database Error on Activation

 *  [learner4life](https://wordpress.org/support/users/learner4life/)
 * (@learner4life)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-error-on-activation/)
 * Hi, on deactivating and activating the plugin, I get the following database errors:
 * 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 activate_plugin, do_action(‘activate_woocommerce/
   woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables,
   dbDelta
 * and
 * 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(
   40),location_code(90)) made by activate_plugin, do_action(‘activate_woocommerce/
   woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables,
   dbDelta
 * How to fix these?
 * [https://wordpress.org/plugins/woocommerce/](https://wordpress.org/plugins/woocommerce/)

Viewing 1 replies (of 1 total)

 *  [Caleb Burks](https://wordpress.org/support/users/icaleb/)
 * (@icaleb)
 * Automattic Happiness Engineer
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-error-on-activation/#post-7711560)
 * You can ignore those errors for now. It’s a bug in WordPress: [https://core.trac.wordpress.org/ticket/34870](https://core.trac.wordpress.org/ticket/34870)

Viewing 1 replies (of 1 total)

The topic ‘Database Error on Activation’ 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: [Caleb Burks](https://wordpress.org/support/users/icaleb/)
 * Last activity: [9 years, 9 months ago](https://wordpress.org/support/topic/database-error-on-activation/#post-7711560)
 * Status: not resolved