bamsyamann

Hi @simplysaru, I doubt that would be necessary – judging by the 75 other 1 star reviews it appears I’m not the first person to encounter this issue. I’d suggest implementing a better testing strategy prior to publishing the plug in. Cheers.

### WordPress Environment ###

WordPress address (URL): https://<span style="font-size:12.0pt;line-height:115%;
font-family:"Aptos",serif;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:
Aptos;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;
mso-ansi-language:EN-AU;mso-fareast-language:EN-US;mso-bidi-language:AR-SA">*************/</span>.com.au

Site address (URL): https://*************/.com.au

WC Version: 8.9.2

REST API Version: ? 8.9.2

Action Scheduler Version: ? 3.7.4

Log Directory Writable: ?

WP Version: 6.5.4

WP Multisite: –

WP Memory Limit: 256 MB

WP Debug Mode: ?

WP Cron: –

Language: en_AU

External object cache: –

### Server Environment ###

Server Info: LiteSpeed

PHP Version: 8.2.19

PHP Post Max Size: 128 MB

PHP Time Limit: 300

PHP Max Input Vars: 3000

cURL Version: 7.87.0

OpenSSL/1.1.1w

SUHOSIN Installed: –

MySQL Version: 10.6.18-MariaDB

Max Upload Size: 128 MB

Default Timezone is UTC: ?

fsockopen/cURL: ?

SoapClient: ?

DOMDocument: ?

GZip: ?

Multibyte String: ?

Remote Post: ?

Remote Get: ?

### Database ###

WC Database Version: 8.9.2

WC Database Prefix: ****_

Total Database Size: 46.37MB

Database Data Size: 32.26MB

Database Index Size: 14.11MB

****_woocommerce_sessions: Data: 0.87MB + Index: 0.03MB + Engine MyISAM

****_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_order_items: Data: 0.56MB + Index: 0.25MB + Engine MyISAM

****_woocommerce_order_itemmeta: Data: 3.69MB + Index: 2.45MB + Engine MyISAM

****_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM

****_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM

****_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_actionscheduler_actions: Data: 0.09MB + Index: 0.05MB + Engine MyISAM

****_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_actionscheduler_logs: Data: 0.05MB + Index: 0.04MB + Engine MyISAM

****_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_cart_tracking_wc: Data: 0.13MB + Index: 0.05MB + Engine MyISAM

****_cart_tracking_wc_cart: Data: 0.11MB + Index: 0.04MB + Engine MyISAM

****_cart_tracking_wc_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM

****_comments: Data: 1.93MB + Index: 0.64MB + Engine MyISAM

****_cron_logs: Data: 0.22MB + Index: 0.16MB + Engine InnoDB

****_itbbc_history: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

****_itbbc_history_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

****_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_litespeed_img_optming: Data: 0.04MB + Index: 0.02MB + Engine MyISAM

****_litespeed_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_litespeed_url_file: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_options: Data: 3.12MB + Index: 0.28MB + Engine MyISAM

****_postmeta: Data: 10.96MB + Index: 5.11MB + Engine MyISAM

****_posts: Data: 1.62MB + Index: 0.38MB + Engine MyISAM

****_sendlelogs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM

****_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_term_relationships: Data: 0.05MB + Index: 0.09MB + Engine MyISAM

****_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM

****_usermeta: Data: 0.82MB + Index: 0.46MB + Engine MyISAM

****_users: Data: 0.05MB + Index: 0.04MB + Engine MyISAM

****_wcpdf_invoice_number: Data: 0.01MB + Index: 0.01MB + Engine MyISAM

****_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

****_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wc_customer_lookup: Data: 0.06MB + Index: 0.04MB + Engine MyISAM

****_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wc_orders: Data: 0.47MB + Index: 0.18MB + Engine MyISAM

****_wc_orders_meta: Data: 2.63MB + Index: 2.34MB + Engine MyISAM

****_wc_order_addresses: Data: 0.36MB + Index: 0.19MB + Engine MyISAM

****_wc_order_coupon_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM

****_wc_order_operational_data: Data: 0.26MB + Index: 0.09MB + Engine MyISAM

****_wc_order_product_lookup: Data: 0.64MB + Index: 0.48MB + Engine MyISAM

****_wc_order_stats: Data: 0.14MB + Index: 0.09MB + Engine MyISAM

****_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wc_product_attributes_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM

****_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_wc_product_meta_lookup: Data: 0.07MB + Index: 0.11MB + Engine MyISAM

****_wc_rate_limits: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_woo_shippment_provider: Data: 0.09MB + Index: 0.01MB + Engine MyISAM

****_wpforms_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

****_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

****_wss_log: Data: 2.39MB + Index: 0.08MB + Engine MyISAM

****_yoast_indexable: Data: 0.59MB + Index: 0.09MB + Engine MyISAM

****_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.04MB + Engine MyISAM

****_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

****_yoast_primary_term: Data: 0.01MB + Index: 0.02MB + Engine MyISAM

****_yoast_seo_links: Data: 0.06MB + Index: 0.01MB + Engine MyISAM

### Post Type Counts ###

attachment: 1324

custom_css: 1

customize_changeset: 9

cwginstocknotifier: 1

nav_menu_item: 43

oembed_cache: 2

page: 7

post: 1

product: 775

product_variation: 68

revision: 180

shop_coupon: 6

shop_order: 1625

shop_order_refund: 95

wp_global_styles: 2

wp_navigation: 1

wp_template: 2

### Security ###

Secure connection (HTTPS): ?

Hide errors from visitors: ?

### Active Plugins (13) ###

LiteSpeed Cache: by LiteSpeed Technologies – 6.2.0.1

Premmerce Permalink Manager for WooCommerce: by Premmerce – 2.3.11

Payment Plugins for Stripe WooCommerce: by Payment Plugins

[email protected] – 3.3.71

WooCommerce: by Automattic – 8.9.2

Yoast SEO: by Team Yoast – 22.8

WP Mail SMTP: by WP Mail SMTP – 4.0.1

### Inactive Plugins (7) ###

Cron Logger: by Palasthotel <[email protected]> (Edward Bock) – 1.2.2

Custom Bulk/Quick Edit: by Axelerant – 1.6.10

Enable Media Replace: by ShortPixel – 4.1.5

PW WooCommerce Bulk Edit: by Pimwick

LLC – 2.125

Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6

Stock Sync for WooCommerce Pro: by Lauri Karisola / WP Trio – 2.7.0

WooCommerce Shippit: by Shippit Pty Ltd – 2.0.2

WP Crontrol: by John Blackbourn – 1.16.3

### Dropin Plugins () ###

maintenance.php: maintenance.php

### Settings ###

API Enabled: –

Force SSL: –

Currency: AUD ($)

Currency Position: left

Thousand Separator: ,

Decimal Separator: .

Number of Decimals: 2

Taxonomies: Product Types: external (external)

grouped (grouped)

simple (simple)

variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)

exclude-from-search (exclude-from-search)

featured (featured)

outofstock (outofstock)

rated-1 (rated-1)

rated-2 (rated-2)

rated-3 (rated-3)

rated-4 (rated-4)

rated-5 (rated-5)

Connected to WooCommerce.com: –

Enforce Approved Product Download Directories: –

HPOS feature enabled: ?

Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore

HPOS data sync enabled: ?

### Logging ###

Enabled: ?

Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2

Retention period: 30 days

Level threshold: –

Log directory size: 89 KB

### WC Pages ###

Shop base: ? Page not set

Cart: #7 - /cart/

Checkout: #8 - /checkout/

My account: #9 - /my-account/

Terms and conditions: ? Page not set

### Theme ###

Name: *********

Version: 1

Author URL: *********

Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build

personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ?

### Templates ###

Overrides: *************/woocommerce/cart/cart-totals.php

*************/woocommerce/cart/cart.php

*************/woocommerce/cart/mini-cart.php

*************/woocommerce/checkout/review-order.php

*************/woocommerce/global/form-login.php

*************/woocommerce/loop/loop-end.php

*************/woocommerce/myaccount/form-lost-password.php

*************/woocommerce/myaccount/form-reset-password.php

### Admin ###

Enabled Features: activity-panels

analytics

product-block-editor

coupons

core-profiler

customize-store

customer-effort-score-tracks

import-products-task

experimental-fashion-sample-products

shipping-smart-defaults

shipping-setting-tour

homescreen

marketing

mobile-app-banner

navigation

onboarding

onboarding-tasks

product-variation-management

product-virtual-downloadable

product-external-affiliate

product-grouped

product-linked

product-pre-publish-modal

product-custom-fields

remote-inbox-notifications

remote-free-extensions

payment-gateway-suggestions

shipping-label-banner

subscriptions

store-alerts

transient-notices

woo-mobile-welcome

wc-pay-promotion

wc-pay-welcome-page

Disabled Features: minified-js

new-product-management-experience

settings

async-product-editor-category-field

launch-your-store

Daily Cron: ? Next scheduled: 2024-06-06 20:40:17 +10:00

Options: ?

Notes: 21

Onboarding: completed

### Action Scheduler ###

Complete: 297

Oldest: 2024-05-29 04:37:10 +1000

Newest: 2024-06-06 07:00:05 +1000

Pending: 6

Oldest: 2024-06-06 07:45:06 +1000

Newest: 2024-06-07 05:30:04 +1000

### Status report information ###

Generated at: 2024-06-06 07:20:25 +10:00

@rajeshml I simply replied to the O.P. initial question. I have now created a duplicate post for same issue, as per your request. Thank You ??

My online store is experiencing the same problem. Latest Woocommerce with HPOS, Payment Plugins for Stripe WooCommerce, LiteSpeed Cache, Yoast SEO, WP Mail SMTP. I’ve been pulling my hair out trying to find the cause yet so far without any luck. Enable compatibility mode was checked, 1 week later it was unchecked. But every time it is unchecked, the orders add up and are pending sync. What is stopping this from happening automatically? It seems as though every time “woocommerce_hpos_legacy_data_cleanup_in_progress” is in the queue, the database error commands out of sync message is displayed.

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ****_options WHERE option_name = ‘woocommerce_hpos_legacy_data_cleanup_in_progress’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->is_flag_set, get_option

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT umeta_id FROM ****_usermeta WHERE meta_key = ‘****_yoast_notifications’ AND user_id = 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM ****_usermeta made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata, add_metadata

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ****_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ****_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO ****_options (option_name, option_value, autoload) VALUES (‘action_scheduler_lock_async-request-runner’, ‘665e234646eec6.65761982|1717445506’, ‘no’) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set

[03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE ****_options SET option_value = ‘1720037446’ WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl’ 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 agree, this product went from a 5 star rating to 1 star overnight.