wc blocks api error

  • Resolved erawin28

    (@erawin28)


    1 year ago

    hello to everyone

    for some time now i’m seeing an error in my woocommerce website:

    [13-Nov-2023 09:21:06 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

    i’t doesn’t matter if caching plugin is on or off the error still shows up

    and now i’m seeing this as well:

    [12-Nov-2023 23:45:39 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3.

    can someone help me with this?

    thank you so much

Viewing 7 replies - 1 through 7 (of 7 total)
  • gecko002002

    (@gecko002002)

    Hello,

    We have a similar error:
    WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM muayu_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option, QM_DB->query

    Thread Starter erawin28

    (@erawin28)

    i’m still facing this error

    really appreciate if someone helps with solving it…

    hrn1995 (woo-hc)

    (@aguinaldodarla)

    Hi @erawin28

    The first error message, Commands out of sync; you can't run this command now is related to MySQL. There’s a conflict between commands in your database.

    First, kindly check if your site database memory size is exhausted or not. You can request your web host to increase your memory limit to see if that helps to solve the issue.

    If that does not help, please navigate?WooCommerce > System Status > Logs, and provide us with the full stack trace.

    Regarding the second error, you should first ensure that all your plugins, themes, and WordPress itself are updated to their latest versions. If the error persists, kindly perform a conflict test I suggest performing a conflict test and then contacting the developer for an update or a fix for that certain theme/plugin.

    I hope this helps!

    slimcatdesign

    (@slimcatdesign)

    I a getting this error too

    WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

    Wodrpess/WooCoomerce and all other plugin updated. I do not use any WC blocks as theme simply hardcoded in (and its not been a issue until very recently). 4x CPU 4x GB RAM all allocated to single website (not very busy, say 100-200 orders per week).

    I realised that some shop products get their stock messed up, say if I had 10 items after ordering 5, I will still have like 8 left, or 2 (just as an example). Does not happen to all products, just random product/random time.

    Thanks

    • This reply was modified 1 year ago by slimcatdesign. Reason: spelling
    hrn1995 (woo-hc)

    (@aguinaldodarla)

    Hello @slimcatdesign

    In order to align with forum best practices, please start your own topic, so that we can address your issue(s) separately, as everyone has a different setup. Thanks!

    slimcatdesign

    (@slimcatdesign)

    was this resolved now?

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello slimcatdesign

    Thank you for your message.

    If you are facing the same error on your site, I recommend you create a New Topic so we can look into your issue separately.

    Have a great day!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wc blocks api error’ is closed to new replies.

Tags