• slimcatdesign

    (@slimcatdesign)


    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

    (@slimcatdesign)

    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

    (@babylon1999)

    Hello @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, 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 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 already being tracked in this report. You can safely ignore it for now. :?)

    Look forward to hearing back from you.

    Thread Starter slimcatdesign

    (@slimcatdesign)

    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!

    Hi @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 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 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/ 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 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!

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @slimcatdesign,

    Could you please confirm if you were able to try switching to a default theme like Storefront on your staging site? This would help us in troubleshooting the issues you are facing.

    Thread Starter slimcatdesign

    (@slimcatdesign)

    hi @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.