WordPress database error Commands out of sync; you can’t run this command

  • Beret

    (@beret)


    4 years ago

    29-Oct-2020 23:07:12 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM "wplp_woocommerce_sessions"made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data

    I got this error during a sale that had a lot of users refreshing the site over and over and attempting to check out with the same items at once.

    My host says:

    It seems that this error occurs when MySQL query data is left in an inconsistent state. Most of the time, this is likely due to another plugin running a query and not finishing” it off or clearing it correctly.

    Can someone tell me what the issue is?

    WooCommerce status report: https://pastebin.com/NUuwLK5J

    I will admit my theme was not updated. It was on 7.1 and now it is on 7.3
    Also my WordPress might not have been up-to-date. Was still on 5.5.1 instead of 5.5.3

    Lastly, I am dequeueing my cast fragment with this code in my theme’s function.php file

    /* DEQUEUES CART FRAGMENT */
add_action( 'wp_print_scripts', 'de_script', 100 );

    However, someone else said I should make sure to whitelist (and make sure is not cached):
    ?wc-ajax=get_refreshed_fragments

    Do I have to do both things? Dequeue and whitelist? Or one or the other? Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Beret

    (@beret)

    I also had an issue where when people were checking out, the right side of the screen on the last step of the checkout, was greyed out. The part where you enter credentials such as CC or select PayPal. Has this ever happened to anyone?

    Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @beret!

    Do I have to do both things? Dequeue and whitelist? Or one or the other?

    There would be no point in whitelisting it if you dequeue it. You can either dequeue or whitelist.

    As for the error message in the database, is that the full log entry, or do you have one where we can see the full stack trace?

    the right side of the screen on the last step of the checkout, was greyed out. The part where you enter credentials such as CC or select PayPal. Has this ever happened to anyone?

    This is usually indicative of a conflict, either from your theme or another plugin.

    Have you had a chance to test for conflict, as per https://docs.woocommerce.com/document/how-to-test-for-conflicts/ ?

    Cheers!

    Thread Starter Beret

    (@beret)

    There would be no point in whitelisting it if you dequeue it. You can either dequeue or whitelist.

    So I should whitelist instead of dequeueing it because the dequeue gets reset everytime the theme updates?

    As for the error message in the database, is that the full log entry, or do you have one where we can see the full stack trace?

    This is just the normal woocommerce report. How would I access the full stack trace?

    This is usually indicative of a conflict, either from your theme or another plugin.

    Have you had a chance to test for conflict, as per https://docs.woocommerce.com/document/how-to-test-for-conflicts/ ?

    The issue is this error only happens when I have a lot of people on my shop refreshing waiting for a drop and then a bunch of people trying to check out with the same product at the same exact time so it would be kind of hard to replicate.

    Thread Starter Beret

    (@beret)

    Here is a screenshot of the resource usage my last release day: https://imgur.com/a/USwpZHY

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error Commands out of sync; you can’t run this command’ is closed to new replies.