"WooCommerce Data Update Required" Keeps Showing Up

The updater will trigger install script, which looks to be causing “WordPress database error MySQL server has gone away”.

I’d be curious to know what errors you see if calling these 2 queries manually:

https://github.com/woothemes/woocommerce/blob/master/includes/class-wc-install.php#L350-L351

Hmm, I’m not sure if I’m doing it right, but I created a custom page template including this code:
echo $wpdb->get_var( "SHOW INDEX FROM{$wpdb->prefix}woocommerce_tax_rate_locations` WHERE Key_name LIKE ‘location_type_code’;” );
echo ‘test’;
echo $wpdb->query( “DROP INDEX location_type_code ON {$wpdb->prefix}woocommerce_tax_rate_locations;” );`

And I found this error in debug log
[18-Feb-2016 02:19:20 UTC] WordPress database error Can't DROP 'location_type_code'; check that column/key exists for query DROP INDEXlocation_type_codeON wp_woocommerce_tax_rate_locations; made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/spaulding-theme/template_test.php'), QM_DB->query

Result: https://www.spauldinggrp.com/test/

Thanks for your continued help ?? Please let me know if I’m doing anything wrong to test those functions.

Make this change, the SHOW INDEX returns the table name and isn’t needed.

https://github.com/woothemes/woocommerce/commit/e987a3830a9a8096bb305a9b82feaf4c78bc1f8d

I commented out those lines, but it does not seem to have affected the problem. The notices still return after a short while. Still get the same error:
[19-Feb-2016 01:01:11 UTC] WordPress database error Can't DROP 'location_type_code'; check that column/key exists for query DROP INDEXlocation_type_codeON wp_woocommerce_tax_rate_locations; made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/spaulding-theme/template_test.php'), QM_DB->query

If the code is commented out properly, no drop will be performed?

/*
		if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}woocommerce_tax_rate_locations';" ) ) {
			if ( $wpdb->get_var( "SHOW INDEX FROM <code>{$wpdb->prefix}woocommerce_tax_rate_locations</code> WHERE Key_name LIKE 'location_type_code';" ) ) {
				$wpdb->query( "DROP INDEX <code>location_type_code</code> ON {$wpdb->prefix}woocommerce_tax_rate_locations;" );
			}
		}
*/

Did you leave code in place from earlier?

/themes/spaulding-theme/template_test.php

Oops, my mistake. I’ve removed my test code and no longer get the errors. However, the main issue is still present: database does not update and both notices return after a short while. ??

No really much more I can suggest as I cannot replicate. This is the only code which would add that notice https://github.com/woothemes/woocommerce/blob/master/includes/class-wc-install.php#L131

Maybe you can add your own logging and see when it gets called.

So, after running the database update function, I can see that the woocomerce_db_version option is updated to 2.5.2. After a short while, it is reset back to 2.1.8 – which adds the notice again. Do you have any idea why the db version option would be reset? I’m not running the update function again.

Have you had issues updating before? Search your theme/plugin files for an update option call. Perhaps it was hard coded somewhere.

Unfortunately, I can’t say. I’ve only recently started working on this site. It does not appear that the theme runs any update functions.

Found this error in the debug log as well:
[22-Feb-2016 18:59:43 UTC] 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 require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta, QM_DB->query

I suggest you download all theme and plugin files and look for “2.1.8”. Hopefully youll find something updating it to that version incorrectly. Seems too ‘random’ a number to not be custom code.

I’ve searched all plugin and theme files for that string with no luck. I will continue to test; please let me know if you think of any other ideas.

Thanks for your help so far Mike!

I get the same thing on a site that has no Woocommerce installed.