Database Error Commands Out of Sync
-
Has anyone encountered anything similar to the below?
It’s a regular occurring error. Customers are able to checkout as normal but occasionally a failed order will be changed to processing. I have PayPal Standard and WooCommerce Stripe Gateway as my payment gateways, and only Stripe orders are effected.
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\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->is_enqueued, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
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 = ‘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
WordPress database error Commands out of sync; you can’t run this command now for query UPDATEwp_options
SEToption_value
= ‘1719577391’ WHEREoption_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
[29-May-2024 12:23:11 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key
,session_value
,session_expiry
) VALUES
// I’ve deleted an array of order data here. It shows the products, shipping option etc.
ON DUPLICATE KEY UPDATEsession_value
= VALUES(session_value
),session_expiry
= VALUES(session_expiry
) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_dataThe page I need help with: [log in to see the link]
- The topic ‘Database Error Commands Out of Sync’ is closed to new replies.