wc blocks api error

Resolved erawin28
(@erawin28)

2 years, 5 months 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)

2 years, 5 months ago

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)

2 years, 5 months ago

i’m still facing this error

really appreciate if someone helps with solving it…

hrn1995 (woo-hc)
(@aguinaldodarla)

2 years, 5 months ago

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)

2 years, 5 months ago
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 2 years, 5 months ago by slimcatdesign. Reason: spelling
hrn1995 (woo-hc)
(@aguinaldodarla)

2 years, 5 months ago

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)

2 years, 3 months ago

was this resolved now?

Zee
(@doublezed2)

2 years, 3 months ago

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.