azielaskowski

Hi, I am using our staging site, with a new Woo Commerce install. I had commented out the exception on line 312 so I could get the product to install. I tried Rok’s suggestion regarding switching to legacy mode WooCommerce > Settings > Advanced > Features. Enabling compatibility mode showed 30 orders needed to sync. Once the orders synced, I deleted Woo Commerce and attempted a new Woo Commerce install and activation. This time the install/activation worked perfectly. So the exception message was correct – I just didn’t know which db table to clear out…

Shameem – Thank you for writing me. The WordPress server is hosted on GoDaddy, which didn’t seem to affect this problem.

To clarify a bit, I am installing/activating Woo Commerce for the first time. The plugin installs fine, but crashes when the Woo Commerce plugin is activated. I disabled all plugins and attempted activation, but Woo Commerce crashed. I commented out line 312 and Woo Commerce activation succeeded. I restored line 312. I admit commenting line 312 to get the plugin to install is a hack. I’d appreciate someone explaining which table or object had a non-zero entry.

Thanks!

Al

I just <span style=”font-family:monospace”><span style=”color:#000000;background-color:#ffffff;”>installed version 8.5.1 of woocommerce and received the same error message:</span></span>

<span style=”font-family:monospace”><span style=”color:#000000;background-color:#ffffff;”> CRITICAL Uncaught Exception: The authoritative table for orders storage can’t be changed while there are orders out of sync in /var/www/wp-content/plugins/woocommer</span>ce/src/Internal/DataStores/Orders/CustomOrdersTableController.php:312 </span>

2024-01-16T19:12:08+00:00 CRITICAL Uncaught Exception: The authoritative table for orders storage can't be changed while there are orders out of sync in /var/www/wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/CustomOrdersTableController.php:312
Stack trace:
#0 [internal function]: Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController->process_pre_update_option('yes', 'woocommerce_cus...', 'no')
#1 /var/www/wp-content/plugins/woocommerce/src/Internal/Traits/AccessiblePrivateMethods.php(158): call_user_func_array(Array, Array)
#2 /var/www/wp-includes/class-wp-hook.php(324): Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController->__call('process_pre_upd...', Array)
#3 /var/www/wp-includes/plugin.php(205): WP_Hook->apply_filters('yes', Array)
#4 /var/www/wp-includes/option.php(784): apply_filters('pre_update_opti...', 'yes', 'woocommerce_cus...', 'no')
#5 /var/www/wp-content/plugins/woocommerce/src/Internal/Features/FeaturesController.php(344): update_option('woocommerce_cus...', 'yes')
#6 /var/www/wp-content/plugins/woocommerce/includes/class-wc-install.php(920): Automattic\WooCommerce\Internal\Features\FeaturesController->change_feature_enable('custom_order_ta...', true)
#7 /var/www/wp-includes/class-wp-hook.php(324): WC_Install::maybe_enable_hpos('')
#8 /var/www/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array)
#9 /var/www/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#10 /var/www/wp-content/plugins/woocommerce/includes/class-wc-install.php(291): do_action('woocommerce_new...')
#11 [internal function]: WC_Install::newly_installed('')
#12 /var/www/wp-content/plugins/woocommerce/src/Internal/Traits/AccessiblePrivateMethods.php(178): call_user_func_array(Array, Array)
#13 /var/www/wp-includes/class-wp-hook.php(324): WC_Install::__callStatic('newly_installed', Array)
#14 /var/www/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array)
#15 /var/www/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#16 /var/www/wp-admin/admin-ajax.php(45): do_action('admin_init')
#17 {main}
  thrown in /var/www/wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/CustomOrdersTableController.php on line 312