• Resolved mecus55

    (@mecus55)


    Hello.

    This problem has been around for several months on several sites using WooCommerce. In general, I only use the most popular themes and modules to be sure that there are no compatibility problems.

    The problem appeared after I updated WooCommerce version 8.0.3 to version 8.5.3.

    Since then, the following errors appear 2 or 3 times a day. Sometimes they appear after 2-3 days. It’s something random. I don’t use HPOS. I have other friends who also have these problems. I haven’t had any problems in 9 years of updating WooCommerce on all clients sites. A few days ago I updated a client from version 8.5.3 to 9.2.3. and several rows with synchronization errors appeared. I repeat that I do not use HPOS.

    I don’t use cache plugins. I have no PHP memory issues.

    This is before update to 9.2.3

    [27-Aug-2024 05:39:57 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
    [27-Aug-2024 05:46:54 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
    [27-Aug-2024 05:51:57 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
    [27-Aug-2024 06:00:12 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

    This is after update to 9.2.3

    [15-Sep-2024 07:37:16 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [15-Sep-2024 07:37:16 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [15-Sep-2024 07:37:16 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [15-Sep-2024 07:37:16 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
    [16-Sep-2024 10:23:41 UTC] PHP Notice: Undefined index: host in /home/r83091just/public_html/wp-includes/canonical.php on line 716
    [16-Sep-2024 11:47:11 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [16-Sep-2024 11:47:11 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [16-Sep-2024 11:47:11 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [16-Sep-2024 11:47:11 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
    [16-Sep-2024 13:30:45 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [16-Sep-2024 13:30:45 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [16-Sep-2024 13:30:45 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [16-Sep-2024 13:30:45 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
    [17-Sep-2024 06:54:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [17-Sep-2024 06:54:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [17-Sep-2024 06:54:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [17-Sep-2024 06:54:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [17-Sep-2024 06:54:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [17-Sep-2024 06:54:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [17-Sep-2024 06:54:29 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
    [17-Sep-2024 06:54:29 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
    [17-Sep-2024 14:35:47 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [17-Sep-2024 14:35:47 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [17-Sep-2024 14:35:47 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [17-Sep-2024 14:35:47 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
    [17-Sep-2024 22:27:51 UTC] Eroare a evenimentului de reprogramare cron pentru carlig: action_scheduler_run_queue, cod de eroare: could_not_set, mesaj de eroare: Lista cu evenimente planificate nu a putut fi salvat?., date: {"schedule":"every_minute","args":["WP Cron"],"interval":60}
    [18-Sep-2024 06:59:39 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='wc_schedule_pending_batch_processes' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
    [18-Sep-2024 06:59:39 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
    [18-Sep-2024 06:59:39 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' LIMIT 1 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
    [18-Sep-2024 06:59:39 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
    WC Version: 9.2.3
    Legacy REST API Package Version: Modulul Legacy REST API nu este instalat pe acest site.
    Action Scheduler Version: ? 3.8.1
    Log Directory Writable: ?
    WP Version: 6.6.2
    WP Multisite: –
    WP Memory Limit: 2 Go
    WP Debug Mode: ?
    WP Cron: ?
    Language: ro_RO
    External object cache: –

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 512 Mo
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.87.0
    OpenSSL/1.1.1w

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.6.17-MariaDB
    Max Upload Size: 512 Mo
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 9.2.3
    WC Database Prefix: wp_
    Dimensiune total? baz? de date: 60.60MB
    Dimensiune date baz? de date: 44.73MB
    Dimensiune index baz? de date: 15.87MB
    wp_woocommerce_sessions: Date: 0.05 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_api_keys: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_attribute_taxonomies: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_downloadable_product_permissions: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_order_items: Date: 0.61 MO + Index: 0.20 MO + Motor MyISAM
    wp_woocommerce_order_itemmeta: Date: 2.78 MO + Index: 2.16 MO + Motor MyISAM
    wp_woocommerce_tax_rates: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_tax_rate_locations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_shipping_zones: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_shipping_zone_locations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_shipping_zone_methods: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_payment_tokens: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_payment_tokenmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_actionscheduler_actions: Date: 0.10 MO + Index: 0.04 MO + Motor MyISAM
    wp_actionscheduler_claims: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_actionscheduler_groups: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_actionscheduler_logs: Date: 0.05 MO + Index: 0.04 MO + Motor MyISAM
    wp_commentmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_comments: Date: 0.89 MO + Index: 0.36 MO + Motor MyISAM
    wp_frm_fields: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_frm_forms: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_frm_items: Date: 0.08 MO + Index: 0.04 MO + Motor MyISAM
    wp_frm_item_metas: Date: 0.32 MO + Index: 0.12 MO + Motor MyISAM
    wp_links: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_options: Date: 2.77 MO + Index: 0.18 MO + Motor MyISAM
    wp_postmeta: Date: 20.45 MO + Index: 8.91 MO + Motor MyISAM
    wp_posts: Date: 10.39 MO + Index: 1.14 MO + Motor MyISAM
    wp_revslider_css: Date: 0.09 MO + Index: 0.01 MO + Motor MyISAM
    wp_revslider_css_bkp: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_layer_animations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_layer_animations_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_navigations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_navigations_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_sliders: Date: 0.06 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_sliders7: Date: 0.06 MO + Index: 0.02 MO + Motor InnoDB
    wp_revslider_sliders_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_slides: Date: 0.73 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_slides7: Date: 1.52 MO + Index: 0.02 MO + Motor InnoDB
    wp_revslider_slides_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_static_slides: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_static_slides_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_termmeta: Date: 0.31 MO + Index: 0.06 MO + Motor MyISAM
    wp_terms: Date: 0.01 MO + Index: 0.03 MO + Motor MyISAM
    wp_term_relationships: Date: 0.09 MO + Index: 0.19 MO + Motor MyISAM
    wp_term_taxonomy: Date: 0.01 MO + Index: 0.01 MO + Motor MyISAM
    wp_usermeta: Date: 0.01 MO + Index: 0.01 MO + Motor MyISAM
    wp_users: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_admin_notes: Date: 0.07 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_admin_note_actions: Date: 0.04 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_category_lookup: Date: 0.01 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_customer_lookup: Date: 0.26 MO + Index: 0.22 MO + Motor MyISAM
    wp_wc_download_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_orders: Date: 0.02 MO + Index: 0.11 MO + Motor InnoDB
    wp_wc_orders_meta: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB
    wp_wc_order_addresses: Date: 0.02 MO + Index: 0.06 MO + Motor InnoDB
    wp_wc_order_coupon_lookup: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_order_operational_data: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB
    wp_wc_order_product_lookup: Date: 0.64 MO + Index: 0.55 MO + Motor MyISAM
    wp_wc_order_stats: Date: 0.28 MO + Index: 0.21 MO + Motor MyISAM
    wp_wc_order_tax_lookup: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_product_attributes_lookup: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_wc_product_download_directories: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_wc_product_meta_lookup: Date: 0.09 MO + Index: 0.13 MO + Motor MyISAM
    wp_wc_rate_limits: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_wc_reserved_stock: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_tax_rate_classes: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_webhooks: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woodmart_wishlists: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woodmart_wishlist_products: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_yoast_indexable: Date: 1.52 MO + Index: 0.55 MO + Motor InnoDB
    wp_yoast_indexable_hierarchy: Date: 0.09 MO + Index: 0.16 MO + Motor InnoDB
    wp_yoast_migrations: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_yoast_primary_term: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB
    wp_yoast_seo_links: Date: 0.16 MO + Index: 0.11 MO + Motor InnoDB

    ### Post Type Counts ###

    attachment: 2054
    cms_block: 17
    frm_form_actions: 2
    frm_styles: 1
    mc4wp-form: 1
    nav_menu_item: 195
    page: 29
    post: 1
    product: 1248
    revision: 775
    shop_order: 324
    wpcf7_contact_form: 1

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (12) ###

    Editor clasic: de Contributori WordPress – 1.6.4
    Piese clasice: de Contributori WordPress – 0.3
    Formular de contact 7: de Takayuki Miyoshi – 5.9.8
    Yoast Duplicate Post: de Enrico Battocchi ?i echipa Yoast – 4.5
    Font Awesome: de Font Awesome – 4.5.0
    Formidable Forms: de Strategy11 Form Builder Team – 6.14.1
    WPBakery Page Builder: de Michael M - WPBakery.com – 7.9
    Slider Revolution: de ThemePunch – 6.7.18
    WooCommerce: de Automattic – 9.2.3 (este disponibil? actualizarea la versiunea 9.3.1)
    Woodmart Core: de – 1.0.44
    Yoast SEO: de Echipa Yoast – 23.4
    WP Migrate Lite: de WP Engine – 2.6.11

    ### Inactive Plugins (0) ###


    ### Dropin Plugins () ###

    maintenance.php: maintenance.php

    ### Must Use Plugins (1) ###

    WP Migrate Lite Compatibility: de Delicious Brains – 1.3

    ### Settings ###

    Legacy API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right
    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: WC_Order_Data_Store_CPT
    HPOS data sync enabled: –

    ### Logging ###

    Enabled: ?
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 de zile
    Level threshold: –
    Log directory size: 188 o

    ### WC Pages ###

    Baz? magazin: #7 - /produse/
    Co?: ? Pagin? nesetat?
    Finalizare: #7309 - /cerere-oferta/ - Con?ine scurt-codul [woocommerce_checkout]
    Contul meu: ? ID-ul pagin? este setat
    dar pagina nu exist?

    Termeni ?i condi?ii: #9571 - /termene-si-conditii/

    ### Theme ###

    Name: Woodmart Child
    Version: 1.0.0
    Author URL: https://xtemos.com
    Child Theme: ?
    Parent Theme Name: Woodmart
    Parent Theme Version: 7.6.0
    Parent Theme Author URL: https://themeforest.net/user/xtemos
    WooCommerce Support: ?

    ### Templates ###

    Overrides: woodmart/woocommerce/archive-product.php
    woodmart/woocommerce/cart/cart-item-data.php
    woodmart/woocommerce/cart/cart.php
    woodmart/woocommerce/cart/cross-sells.php
    woodmart/woocommerce/cart/mini-cart.php
    woodmart/woocommerce/checkout/form-checkout.php
    woodmart/woocommerce/checkout/thankyou.php
    woodmart/woocommerce/content-product-cat.php
    woodmart/woocommerce/content-product.php
    woodmart/woocommerce/content-single-product.php
    woodmart/woocommerce/content-widget-product.php
    woodmart-child/woocommerce/emails/email-addresses.php
    woodmart-child/woocommerce/emails/email-order-details.php
    woodmart/woocommerce/global/breadcrumb.php
    woodmart/woocommerce/global/form-login.php
    woodmart/woocommerce/global/quantity-input.php
    woodmart/woocommerce/loop/add-to-cart.php
    woodmart/woocommerce/loop/loop-end.php
    woodmart/woocommerce/loop/loop-start.php
    woodmart/woocommerce/loop/no-products-found.php
    woodmart/woocommerce/loop/orderby.php
    woodmart/woocommerce/loop/pagination.php
    woodmart/woocommerce/loop/sale-flash.php
    woodmart/woocommerce/myaccount/form-login.php
    woodmart/woocommerce/product-searchform.php
    woodmart/woocommerce/single-product/add-to-cart/grouped.php
    woodmart/woocommerce/single-product/add-to-cart/variable.php
    woodmart/woocommerce/single-product/meta.php
    woodmart/woocommerce/single-product/product-attributes.php
    woodmart/woocommerce/single-product/product-image.php
    woodmart/woocommerce/single-product/product-thumbnails.php
    woodmart/woocommerce/single-product/rating.php
    woodmart/woocommerce/single-product/related.php
    woodmart/woocommerce/single-product/sale-flash.php
    woodmart/woocommerce/single-product/tabs/description.php
    woodmart/woocommerce/single-product/tabs/tabs.php
    woodmart/woocommerce/single-product/title.php
    woodmart/woocommerce/single-product/up-sells.php
    woodmart/woocommerce/single-product-reviews.php
    woodmart/woocommerce/single-product.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
    pattern-toolkit-full-composability
    product-custom-fields
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    printful
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    launch-your-store

    Disabled Features: experimental-blocks
    minified-js
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    product-editor-template-system

    Daily Cron: ? Next scheduled: 2024-09-19 09:58:18 +03:00
    Options: ?
    Notes: 180
    Onboarding: completed

    ### Action Scheduler ###

    Finalizeaz?: 192
    Oldest: 2024-08-19 05:57:55 +0000
    Newest: 2024-09-18 06:33:54 +0000

    E?uat?: 2
    Oldest: 2023-09-04 06:13:06 +0000
    Newest: 2023-09-25 10:42:47 +0000

    ?n a?teptare: 1
    Oldest: 2024-09-19 06:33:54 +0000
    Newest: 2024-09-19 06:33:54 +0000


    ### Status report information ###

    Generated at: 2024-09-18 15:24:17 +03:00
    `

    I hope you can help me with this problem.

Viewing 15 replies - 1 through 15 (of 31 total)
  • Ruhul Amin

    (@ruhulamin)

    The errors you’re seeing, specifically the “Commands out of sync; you can’t run this command now” errors, typically occur when multiple MySQL commands are executed without properly closing or synchronizing them. This usually happens in the context of the Action Scheduler system in WooCommerce, which is responsible for managing scheduled tasks (e.g., batch processes, updating stock, processing orders).

    There are few things you can do to troubleshoot this

    Go to WooCommerce → Status → Scheduled Actions. Look for any “pending” or “in-progress” actions related to WooCommerce batch processing or Action Scheduler. Try manually running or canceling these actions to clear the queue. If this doesn’t work, you may need to clear the actions directly in the database. You can do this by running a SQL query to clear any stuck entries in the wp_actionscheduler_actions table. Be sure to backup your database before running any direct SQL commands.

    Thread Starter mecus55

    (@mecus55)

    Hello.
    Thank you for your answer.

    I checked in ?WooCommerce → Status → Scheduled Actions. “woocommerce_cleanup_draft_orders” was the only action in pending.I checked and it is ok.
    As I said before the update to 9.2.3, I used version 8.5.3 and that error with Action Schedule was not there. There were other errors as I stated above.
    I think the problem is related to HPOS, although I don’t use HPOS.
    At one site I used a backup when version 8.0.3 was used and the problem disappeared.
    This problem is not only with a few sites. I have friends whose clients sites have the same problem.
    I only created this topic, because there was no point in making more than 10 topics with the same error.
    Most of the sites I started using version 8.0.3. This is not a solution, because I have no way to update without that error.
    I’ll try to use HPOS on a client’s website to see if it solves the error, but it’s still not a solution. The developers should solve the problem.

    I hope you can help me with this problem.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello mecus55,

    Thank you for contacting Woo support.

    Since the errors started appearing after upgrading WooCommerce and seemed random, let’s break down the troubleshooting process.

    First, are all the affected sites hosted on the same server or hosting provider?

    To begin troubleshooting, I suggest focusing on one site and resolving the problem there.
    Once we’ve found the solution, we can apply it to all the other sites.

    Could you share the System Status Report of the affected site with me?
    This will provide useful information about the environment and configuration.

    Next, I recommend installing the WP Crontrol plugin. This tool will give us insight into any issues with the WP-Cron system, which might be leading to pending actions and random errors.
    Once you’ve installed the plugin, kindly share any screenshots or details regarding pending or failed tasks.

    With this information, we can dig deeper and work towards a solution.
    Let me know how it goes, and we’ll proceed from there.

    Best regards.

    Thread Starter mecus55

    (@mecus55)

    Hello.

    The affected sites are hosted on the same hosting provider.It is the biggest hosting provider in my country.

    Here is the System Status Report.

    WC Version: 9.2.3
    Legacy REST API Package Version: Modulul Legacy REST API nu este instalat pe acest site.
    Action Scheduler Version: ? 3.8.1
    Log Directory Writable: ?
    WP Version: 6.6.2
    WP Multisite: –
    WP Memory Limit: 2 Go
    WP Debug Mode: ?
    WP Cron: ?
    Language: ro_RO
    External object cache: –

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 512 Mo
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.87.0
    OpenSSL/1.1.1w

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.6.17-MariaDB
    Max Upload Size: 512 Mo
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 9.2.3
    WC Database Prefix: wp_
    Dimensiune total? baz? de date: 60.68MB
    Dimensiune date baz? de date: 44.80MB
    Dimensiune index baz? de date: 15.88MB
    wp_woocommerce_sessions: Date: 0.12 MO + Index: 0.01 MO + Motor MyISAM
    wp_woocommerce_api_keys: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_attribute_taxonomies: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_downloadable_product_permissions: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_order_items: Date: 0.61 MO + Index: 0.20 MO + Motor MyISAM
    wp_woocommerce_order_itemmeta: Date: 2.78 MO + Index: 2.16 MO + Motor MyISAM
    wp_woocommerce_tax_rates: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_tax_rate_locations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_shipping_zones: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_shipping_zone_locations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_shipping_zone_methods: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_payment_tokens: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_payment_tokenmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woocommerce_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_actionscheduler_actions: Date: 0.10 MO + Index: 0.04 MO + Motor MyISAM
    wp_actionscheduler_claims: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_actionscheduler_groups: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_actionscheduler_logs: Date: 0.05 MO + Index: 0.04 MO + Motor MyISAM
    wp_commentmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_comments: Date: 0.89 MO + Index: 0.36 MO + Motor MyISAM
    wp_frm_fields: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_frm_forms: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_frm_items: Date: 0.08 MO + Index: 0.04 MO + Motor MyISAM
    wp_frm_item_metas: Date: 0.32 MO + Index: 0.12 MO + Motor MyISAM
    wp_links: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_options: Date: 2.77 MO + Index: 0.18 MO + Motor MyISAM
    wp_postmeta: Date: 20.45 MO + Index: 8.91 MO + Motor MyISAM
    wp_posts: Date: 10.39 MO + Index: 1.14 MO + Motor MyISAM
    wp_revslider_css: Date: 0.09 MO + Index: 0.01 MO + Motor MyISAM
    wp_revslider_css_bkp: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_layer_animations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_layer_animations_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_navigations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_navigations_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_sliders: Date: 0.06 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_sliders7: Date: 0.06 MO + Index: 0.02 MO + Motor InnoDB
    wp_revslider_sliders_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_slides: Date: 0.73 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_slides7: Date: 1.52 MO + Index: 0.02 MO + Motor InnoDB
    wp_revslider_slides_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_static_slides: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_revslider_static_slides_bkp: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_termmeta: Date: 0.31 MO + Index: 0.06 MO + Motor MyISAM
    wp_terms: Date: 0.01 MO + Index: 0.03 MO + Motor MyISAM
    wp_term_relationships: Date: 0.09 MO + Index: 0.19 MO + Motor MyISAM
    wp_term_taxonomy: Date: 0.01 MO + Index: 0.01 MO + Motor MyISAM
    wp_usermeta: Date: 0.01 MO + Index: 0.01 MO + Motor MyISAM
    wp_users: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_admin_notes: Date: 0.07 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_admin_note_actions: Date: 0.04 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_category_lookup: Date: 0.01 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_customer_lookup: Date: 0.26 MO + Index: 0.22 MO + Motor MyISAM
    wp_wc_download_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_orders: Date: 0.02 MO + Index: 0.11 MO + Motor InnoDB
    wp_wc_orders_meta: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB
    wp_wc_order_addresses: Date: 0.02 MO + Index: 0.06 MO + Motor InnoDB
    wp_wc_order_coupon_lookup: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_order_operational_data: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB
    wp_wc_order_product_lookup: Date: 0.64 MO + Index: 0.55 MO + Motor MyISAM
    wp_wc_order_stats: Date: 0.28 MO + Index: 0.21 MO + Motor MyISAM
    wp_wc_order_tax_lookup: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_product_attributes_lookup: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_wc_product_download_directories: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_wc_product_meta_lookup: Date: 0.09 MO + Index: 0.13 MO + Motor MyISAM
    wp_wc_rate_limits: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_wc_reserved_stock: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_wc_tax_rate_classes: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM
    wp_wc_webhooks: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woodmart_wishlists: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_woodmart_wishlist_products: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM
    wp_yoast_indexable: Date: 1.52 MO + Index: 0.55 MO + Motor InnoDB
    wp_yoast_indexable_hierarchy: Date: 0.09 MO + Index: 0.16 MO + Motor InnoDB
    wp_yoast_migrations: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB
    wp_yoast_primary_term: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB
    wp_yoast_seo_links: Date: 0.16 MO + Index: 0.11 MO + Motor InnoDB

    ### Post Type Counts ###

    attachment: 2054
    cms_block: 17
    frm_form_actions: 2
    frm_styles: 1
    mc4wp-form: 1
    nav_menu_item: 195
    page: 29
    post: 1
    product: 1248
    revision: 775
    shop_order: 98
    wpcf7_contact_form: 1

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (12) ###

    Editor clasic: de Contributori WordPress – 1.6.4
    Piese clasice: de Contributori WordPress – 0.3
    Formular de contact 7: de Takayuki Miyoshi – 5.9.8
    Yoast Duplicate Post: de Enrico Battocchi ?i echipa Yoast – 4.5
    Font Awesome: de Font Awesome – 4.5.0
    Formidable Forms: de Strategy11 Form Builder Team – 6.14.1
    WPBakery Page Builder: de Michael M - WPBakery.com – 7.9
    Slider Revolution: de ThemePunch – 6.7.18
    WooCommerce: de Automattic – 9.2.3 (este disponibil? actualizarea la versiunea 9.3.2)
    Woodmart Core: de – 1.0.44
    Yoast SEO: de Echipa Yoast – 23.4
    WP Migrate Lite: de WP Engine – 2.6.11

    ### Inactive Plugins (0) ###


    ### Dropin Plugins () ###

    maintenance.php: maintenance.php

    ### Must Use Plugins (1) ###

    WP Migrate Lite Compatibility: de Delicious Brains – 1.3

    ### Settings ###

    Legacy API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right
    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: WC_Order_Data_Store_CPT
    HPOS data sync enabled: –

    ### Logging ###

    Enabled: ?
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 de zile
    Level threshold: –
    Log directory size: 188 o

    ### WC Pages ###

    Baz? magazin: #7 - /produse/
    Co?: ? Pagin? nesetat?
    Finalizare: #7309 - /cerere-oferta/ - Con?ine scurt-codul [woocommerce_checkout]
    Contul meu: ? ID-ul pagin? este setat
    dar pagina nu exist?

    Termeni ?i condi?ii: #9571 - /termene-si-conditii/

    ### Theme ###

    Name: Woodmart Child
    Version: 1.0.0
    Author URL: https://xtemos.com
    Child Theme: ?
    Parent Theme Name: Woodmart
    Parent Theme Version: 7.6.0
    Parent Theme Author URL: https://themeforest.net/user/xtemos
    WooCommerce Support: ?

    ### Templates ###

    Overrides: woodmart/woocommerce/archive-product.php
    woodmart/woocommerce/cart/cart-item-data.php
    woodmart/woocommerce/cart/cart.php
    woodmart/woocommerce/cart/cross-sells.php
    woodmart/woocommerce/cart/mini-cart.php
    woodmart/woocommerce/checkout/form-checkout.php
    woodmart/woocommerce/checkout/thankyou.php
    woodmart/woocommerce/content-product-cat.php
    woodmart/woocommerce/content-product.php
    woodmart/woocommerce/content-single-product.php
    woodmart/woocommerce/content-widget-product.php
    woodmart-child/woocommerce/emails/email-addresses.php
    woodmart-child/woocommerce/emails/email-order-details.php
    woodmart/woocommerce/global/breadcrumb.php
    woodmart/woocommerce/global/form-login.php
    woodmart/woocommerce/global/quantity-input.php
    woodmart/woocommerce/loop/add-to-cart.php
    woodmart/woocommerce/loop/loop-end.php
    woodmart/woocommerce/loop/loop-start.php
    woodmart/woocommerce/loop/no-products-found.php
    woodmart/woocommerce/loop/orderby.php
    woodmart/woocommerce/loop/pagination.php
    woodmart/woocommerce/loop/sale-flash.php
    woodmart/woocommerce/myaccount/form-login.php
    woodmart/woocommerce/product-searchform.php
    woodmart/woocommerce/single-product/add-to-cart/grouped.php
    woodmart/woocommerce/single-product/add-to-cart/variable.php
    woodmart/woocommerce/single-product/meta.php
    woodmart/woocommerce/single-product/product-attributes.php
    woodmart/woocommerce/single-product/product-image.php
    woodmart/woocommerce/single-product/product-thumbnails.php
    woodmart/woocommerce/single-product/rating.php
    woodmart/woocommerce/single-product/related.php
    woodmart/woocommerce/single-product/sale-flash.php
    woodmart/woocommerce/single-product/tabs/description.php
    woodmart/woocommerce/single-product/tabs/tabs.php
    woodmart/woocommerce/single-product/title.php
    woodmart/woocommerce/single-product/up-sells.php
    woodmart/woocommerce/single-product-reviews.php
    woodmart/woocommerce/single-product.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
    pattern-toolkit-full-composability
    product-custom-fields
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    printful
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    launch-your-store

    Disabled Features: experimental-blocks
    minified-js
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    product-editor-template-system

    Daily Cron: ? Next scheduled: 2024-09-22 09:58:18 +03:00
    Options: ?
    Notes: 181
    Onboarding: completed

    ### Action Scheduler ###

    Finalizeaz?: 194
    Oldest: 2024-08-22 06:01:42 +0000
    Newest: 2024-09-20 10:42:55 +0000

    E?uat?: 2
    Oldest: 2023-09-04 06:13:06 +0000
    Newest: 2023-09-25 10:42:47 +0000

    ?n a?teptare: 1
    Oldest: 2024-09-21 10:42:55 +0000
    Newest: 2024-09-21 10:42:55 +0000


    ### Status report information ###

    Generated at: 2024-09-21 13:04:25 +03:00

    I will install WP Crontrol plugin.

    I hope you can help me with this problem.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @mecus55

    The error message “Commands out of sync; you can’t run this command now” typically occurs when multiple database queries are executed in the wrong order. This error can occur in the context of WordPress and WooCommerce when WooCommerce’s sync features attempt to access the database while another query is already being executed.

    The issue can be caused by various factors, including poorly optimized plugins, slow database servers, a plugin conflict, a theme conflict, or other performance-related issues.

    Here are a few steps you can take to troubleshoot the issue:

    1. Try deactivating all plugins except WooCommerce to see if the issue persists. If it’s resolved, reactivate your plugins one by one to identify the conflicting plugin.
    2. Switch to a default WordPress theme like Twenty Twenty-Four and see if the issue still exists. If it doesn’t, the issue might be with your theme.

    Additionally, head over to WooCommerce → Status → Tools, and do the following:

    • WooCommerce transients – Clear
    • Expired transients – Clear
    • Clear template cache – Clear
    • Capabilities – Reset Capabilities
    • Clear customer sessions -Clear
    • Database Update – Update
    • Verify Database – Verify
    • Product lookup tables – Regenerate
    • Regenerate the product attributes lookup table – Regenerate

    Next, please clear your browser cache and then check again.

    If the issue persists, you can try using the Repair Action Scheduler plugin that can fix this issue automatically on most sites:

    I hope this helps! Please let us know how it goes or if you need further assistance.

    Thread Starter mecus55

    (@mecus55)

    Hello.

    The problem is that the said error is random. 1-2 times every 1-2 days. It only appears on the active site. If I work on the clone of the site on a subdomain, I see that the problem is not triggered. Maybe it is not activated because there are no orders and visitors on the test site. Even if I make a few orders, I think it’s not enough.
    I see that the last synchronization error appeared 2 days ago. Yesterday I activated “Enable compatibility mode”, but I did not switch to HPOS. I’ll leave it like that for now. I think the problem is since HPOS was introduced from 8.2. Pretty much everything I’ve seen on the forums is HPOS’s fault, but in my case I didn’t activate HPOS.
    I’m waiting a few days to see if with the “Enable compatibility mode” setting activated, that synchronization problem will still appear.
    From what I see in the “wc_schedule_pending_batch_processes” error, it is related to HPOS synchronization.
    I believe this because in 8.0 the HPOS function was only in the test and I think it does not force you to switch to HPOS.

    Regarding the templates, I don’t think this is the problem, because it appears on several templates. I only use the most popular templates like Flatsome, WoodMart, etc. I avoid having errors due to templates. And as modules I only use:
    Classic Editor: by WordPress Contributors – 1.6.4
    Classic Tracks: by WordPress Contributors – 0.3
    Contact form 7: by Takayuki Miyoshi – 5.9.8
    Yoast Duplicate Post: By Enrico Battocchi and the Yoast Team – 4.5
    Font Awesome: by Font Awesome – 4.5.0
    Formidable Forms: by Strategy11 Form Builder Team – 6.14.1
    WPBakery Page Builder: by Michael M – WPBakery.com – 7.9
    Slider Revolution: by ThemePunch – 6.7.18
    WooCommerce: by Automattic – 9.2.3 (upgrade to version 9.3.2 is available)
    Woodmart Core: from – 1.0.44
    Yoast SEO: by the Yoast Team – 23.4
    WP Migrate Lite: by WP Engine – 2.6.11

    I’ll come back in a few days with more details, or when the first synchronization error appears.

    Thank you for your support.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @mecus55

    Given the error’s randomness and absence on your cloned site, it is likely that the issue is related to site traffic or specific actions performed by your site visitors.

    It’s also possible that the “wc_schedule_pending_batch_processes” error is related to the High-Performance Object Store (HPOS) synchronization, as you’ve mentioned. Even though you have not activated HPOS, certain features could still be attempting to use it, leading to the error.

    If the error does not reappear after enabling “compatibility mode”, it might indicate that there was indeed a conflict with HPOS.

    Additionally, while popular templates and plugins like Flatsome and WoodMart are generally well-optimized, conflicts can still occur, especially with updates. However, since you’ve tested with multiple templates, they seem less likely to be the cause.

    Please do keep us updated on whether the error reoccurs. Looking forward to hearing from you!

    Thread Starter mecus55

    (@mecus55)

    Hello.
    The error appeared again.
    I will switch to HPOS and see if the error will appear again.
    If it appears, I will deactivate compatibility mode and wait again.
    Please leave the topic open, because it may take some time for the error to appear, as it did now.
    Thank you for your support.

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @mecus55,

    Just wanted to check in with you on your findings. Did the error get to appear again?

    On the other hand, I just wanted to let you know that a new version of WooCommerce was released. You can try updating your plugin to the latest version, as updates tend to fix some issues like the one you’re facing.

    Looking forward to hearing from you.

    Thread Starter mecus55

    (@mecus55)

    Hello.
    The error appeared again.
    I will switch to HPOS without compatibility mode and see if the error will appear again.
    I want to see if it’s ok like this or not.
    Then I will check with the new version of WooCommerce. So I thought at first that it was solved with the update, but it wasn’t like that.

    Please leave the topic open, because it may take some time for the error to appear, as it did now.
    Thank you for your support.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @mecus55

    Thank you for keeping us updated on the issue. We understand that this can be frustrating, and we appreciate your patience in this matter.

    Switching to HPOS without compatibility mode seems like a good next step. This will help us further isolate the issue and determine if HPOS is indeed causing the problem.

    Once you’ve done that and if the error still occurs, updating to the latest version of WooCommerce might resolve the issue as our latest updates often include bug fixes and improvements.

    Please take your time and let us know the results when you’re ready. We’ll keep this thread open as you requested.

    Thank you again for your patience and cooperation.

    Thread Starter mecus55

    (@mecus55)

    Hello.
    The error appeared again. Even after updating to the latest version of WooCommerce.
    Also yesterday I installed everything from scratch to do a test. And that error appeared. I gave several times “WooCommerce transients – Clear” and maybe this triggered the error. I don’t know.
    I deleted that site and will try again.
    The problem is that before I was using WooCommerce 8.5.3 and WordPress 6.4.5. And I had only 2 lines of errors. The modules and templates were updated up to date. When I updated WordPress 6.6.2 and WooCommerce 9.2.3, 2 more error lines appeared. Of course, the template used has a patcher update and I updated the WooCommerce template in the theme.
    I will do more tests, but I don’t know for sure what the problem is. It’s too weird. It may be from WooCommerce, who knows. WordPress had many errors. For example version 6.
    I will also do tests with the Twenty Twenty-Four theme.
    I hope you can help me with this problem.

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @mecus55,

    I understand that even with the latest update and a fresh installation, the issue persists.

    In that case, we’d love this to investigate this further, please contact us at Woo.com > My Account > Support. You may need to create an account before you can access that page.
    Please include a link to this forum thread, so that we can keep track of what’s already been done.
    We will be able to help you further there.

    Thread Starter mecus55

    (@mecus55)

    Hello.
    Thank you for your help.
    I receive an email from you “Thanks for joining WooCommerce.com! To fully activate your account, we need to double check your contact information. Visit the link below to confirm your email address.”
    I click on “Confirm your email”
    And when it redirects me to the account page, I get the message “Please confirm your email address. To fully activate your account, please click the link in the email we sent to [my gmail account]. Didn’t receive it?”
    I replaced my email in this post for security purposes.
    It seems that your system has an error :).

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @mecus55,

     I’m sorry to hear that you’re having trouble confirming your email address.

    Sometimes, this happens due to browser cache issues. However, were you able to confirm your email as needed?

Viewing 15 replies - 1 through 15 (of 31 total)
  • You must be logged in to reply to this topic.