Error 525 for users and database errors with Woocommerce

Resolved cbondi
(@cbondi)

7 years, 9 months ago

Hello
We are having ongoing problems with our Woocommerce installation. The issue was first reported by some users who were getting an error 525 when submitting their order. This was not happening for everyone but maybe 20% of customers. We then setup logging to see the backend error messages and we are seeing database errors such as the one listed below. Also on the Woocommerce orders page along with the database errors we see multiple guest orders with no data, no data at all, just a bunch of blank incomplete guest orders.

I’ve already tried using phpmyadmin to repair the indicated tables but that has not made any difference. Can anyone help me figure out how to resolve this.

Example error message on backend (this error message is occurring multiple times with multiple Woocommerce tables):

Jul 17, 05:41:46 WordPress database error Table ‘./mickle/wp_woocommerce_order_items’ is marked as crashed and should be repaired for query SHOW FULL COLUMNS FROM wp_woocommerce_order_items made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_checkout’), call_user_func_array, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->create_order, WC_Abstract_Order->add_product, wc_add_order_item

https://wordpress.org/plugins/woocommerce/

Viewing 5 replies - 1 through 5 (of 5 total)

Caleb Burks
(@icaleb)

Automattic Happiness Engineer

7 years, 9 months ago

That doesn’t look good. Somehow your database got corrupted.

You should do some critiquing on the plugins you are using on your site and make sure they are working and from reputable sources. Would also be good to do the same for your theme.

riomurphy
(@riomurphy)

7 years, 9 months ago

A client of mine is having the exact same issue. About the same ratio and all worked fine until yesterday. Same incomplete empty guest orders. Nothing changed on the site. They are still running version 2.5.5 but all other plugins that have been used since the site was created are up to date. Will watch this for ideas on how to fix.

Thread Starter cbondi
(@cbondi)

7 years, 9 months ago

No response from Woocommerce on this and no paid option for support from them it seems. I’m going to reconsider using this plugin for commerce from this point on. If there is no way to get useful support when there are serious issues I cannot recommend this product to business clients. We’d be happy to pay for support but there doesn’t seem to be an option for that. Pretty bad customer service!

Plugin Author Mike Jolley (a11n)
(@mikejolley)

7 years, 9 months ago

cbondi FYI, Caleb is from WooCommerce support ^ so you have had a response.

Please do what caleb said (rule out plugins, especially gateways), post your report (https://wordpress.org/support/topic/before-posting-gather-the-following-details?replies=1), and try optimising/cleaning/repairing that database table via PHPMYADMIN.

Plugin Author Mike Jolley (a11n)
(@mikejolley)

7 years, 9 months ago

And he answered you here and got no reply https://wordpress.org/support/topic/woo-commerce-orders-intermittently-giving-error-525?replies=2 ¯\_(ツ)_/¯