Title: WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient Last modified: December 31, 2023 --- # WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient * [slimcatdesign](https://wordpress.org/support/users/slimcatdesign/) * (@slimcatdesign) * [2 years, 5 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/) * Hi everyone, * anyone came across to WooCommerce errors, I started to receive recently: * [date:time]**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! Viewing 6 replies - 1 through 6 (of 6 total) * Thread Starter [slimcatdesign](https://wordpress.org/support/users/slimcatdesign/) * (@slimcatdesign) * [2 years, 5 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17225782) * also just started to see these errors: * [23-Nov-2023 22:11:52 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3. [23-Nov-2023 22:11:52 UTC] The Automattic\ WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3. [23-Nov-2023 22:11:52 UTC] The Automattic\WooCommerce\Admin\API\Options:: get_options function is deprecated since version 6.3. [23-Nov-2023 22:11:52 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3. [23-Nov-2023 22:18:17 UTC] The Automattic\WooCommerce\Admin\ API\Options::get_options function is deprecated since version 6.3. [23-Nov-2023 22:18:17 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3. [23-Nov-2023 22:18:17 UTC] The Automattic\WooCommerce\ Admin\API\Options::get_options function is deprecated since version 6.3. [23- Nov-2023 22:18:17 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3. * I have currently WC Admin disabled via: * add_filter( ‘woocommerce_admin_disabled’, ‘__return_true’ ); * [Saif](https://wordpress.org/support/users/babylon1999/) * (@babylon1999) * [2 years, 5 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17230776) * Hello [@slimcatdesign](https://wordpress.org/support/users/slimcatdesign/), Thank you for reaching out! * > anyone came across to WooCommerce errors, I started to receive recently: > [date:time]**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 haven’t come across recent reports regarding this issue, [but this StackOverflow question caught my attention](https://stackoverflow.com/a/66378950), especially considering you mentioned your theme being hard coded. * Are you also constructing a React template? To confirm if the issue is related to the theme, you can temporarily switch to the default [Storefront](https://woocommerce.com/storefront/) theme. * > The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated > since version 6.3. [23-Nov-2023 22:11:52 UTC] The Automattic\WooCommerce\Admin\ > API\Options::get_options function is deprecated since version 6.3. [23-Nov- > 2023 22:11:52 UTC] The * This is simply a deprecation notice and is alrea[dy being tracked in this report.](https://github.com/woocommerce/woocommerce/issues/37592) You can safely ignore it for now. :‎) * Look forward to hearing back from you. * Thread Starter [slimcatdesign](https://wordpress.org/support/users/slimcatdesign/) * (@slimcatdesign) * [2 years, 5 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17230812) * Thanks Saif. * Just to make clear, by hardcoded I meant I have created separate templates for all pages (and it’s basic html/php). * All worked great until very recently. * Swapping theme for testing is not an option, as it’s live (and pretty busy) e- commerce. * I have disabled any cache (LScache on cPanel) and removed any files it had in lscache folder. Will need a bit of time to observe. * Will update tomorrow. * Thanks! * [xue28 (woo-hc)](https://wordpress.org/support/users/xue28/) * (@xue28) * [2 years, 5 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17236121) * Hi [@slimcatdesign](https://wordpress.org/support/users/slimcatdesign/) * > Swapping theme for testing is not an option, as it’s live (and pretty busy) > e-commerce. * I understand that changing themes on a live site can greatly impact your customers. In this case, I’d recommend cloning your site to a staging environment and performing the tests described in this [guide](https://woocommerce.com/document/how-to-test-for-conflicts/) without modifying your live site. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free [WP Staging](https://wordpress.org/plugins/wp-staging/) plugin. * If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here. * If this did not resolve the issue, please share your **System Status Report**, that will help us further troubleshoot. * You can find it via `WooCommerce > Status`. Select `Get system report` and then` Copy for support`. Once you’ve done that, you can paste it into your reply here. * If you could also provide the **fatal error logs** (if any) under `WooCommerce > Status > Logs`. * You could copy and paste your reply here or paste it via [https://gist.github.com/](https://gist.github.com/) and send the link here. * Or, if you’d like someone else to do this work for you, our trusted partner, Codeable, has an [offering](https://www.codeable.io/partners/woocommerce/conflict-testing/?ref=99VIa2) where they will run this test for $150 USD. If there is time left, they will also fix the problems they found. * Let us know how it goes! * [ckadenge (woo-hc)](https://wordpress.org/support/users/ckadenge/) * (@ckadenge) * [2 years, 5 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17275642) * Hi [@slimcatdesign](https://wordpress.org/support/users/slimcatdesign/), * Could you please confirm if you were able to try switching to a default theme like [Storefront ](https://woocommerce.com/storefront/)on your staging site? This would help us in troubleshooting the issues you are facing. * Thread Starter [slimcatdesign](https://wordpress.org/support/users/slimcatdesign/) * (@slimcatdesign) * [2 years, 4 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17290085) * hi [@ckadenge](https://wordpress.org/support/users/ckadenge/), staging site does not produce these errors as it needs live data (orders). live website i cannot switch the themes, nor disabling any plugins. it is clearly something with woocoomerce, i start seeing these errors for few months now. i have updated all plugins again, so all upto date, and still errors in logs. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 6 replies * 7 participants * Last reply from: [slimcatdesign](https://wordpress.org/support/users/slimcatdesign/) * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/woocommerceblocksassetsapi-update_script_data_cache-set_transient/#post-17290085) * Status: not resolved