Database error updating to 3.0.3
-
Hey guys,
Just did the auto update to WC 3.0.3. (I think it was from 2.6.14.)
AFter the database update step there was a success message in the WP panel, but I got the following in the log. Should I be worried? The errors are all “duplicate key”.
Thanks!
[Tue Apr 18 13:22:42.170402 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'attribute_name' for query ALTER TABLE wp_woocommerce_attribute_taxonomies ADD KEY <code>attribute_name</code> (<code>attribute_name</code>(20)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:44.414368 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'download_order_key_product' for query ALTER TABLE wp_woocommerce_downloadable_product_permissions ADD KEY <code>download_order_key_product</code> (<code>product_id</code>,<code>order_id</code>,<code>order_key</code>(16),<code>download_id</code>) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:46.036028 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'meta_key' for query ALTER TABLE wp_woocommerce_order_itemmeta ADD KEY <code>meta_key</code> (<code>meta_key</code>(32)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:47.405797 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'tax_rate_state' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY <code>tax_rate_state</code> (<code>tax_rate_state</code>(2)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:47.406417 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'tax_rate_class' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY <code>tax_rate_class</code> (<code>tax_rate_class</code>(10)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:48.679612 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_tax_rate_locations ADD KEY <code>location_type_code</code> (<code>location_type</code>(10),<code>location_code</code>(20)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:49.840012 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_shipping_zone_locations ADD KEY <code>location_type_code</code> (<code>location_type</code>(10),<code>location_code</code>(20)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php [Tue Apr 18 13:22:51.742236 2017] [:error] [pid 67990] [client ::1:61854] WordPress database error Duplicate key name 'meta_key' for query ALTER TABLE wp_woocommerce_payment_tokenmeta ADD KEY <code>meta_key</code> (<code>meta_key</code>(32)) 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, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, referer: https://localhost:8080/challenge/chancetochallenge.com/wp-admin/plugins.php
- The topic ‘Database error updating to 3.0.3’ is closed to new replies.