Blank Orders with Pending Payment Status error? Need Help!

  • bashsmusic

    (@bashsmusic)


    9 months ago

    We run a small business, and our payment system has recently started failing. When customers try to pay at the end of checkout, they get the following error message at the top:

    “There was an error processing your order. Please check for any charges in your payment method and review your order history before placing the order again.”

    This happens with payment method PayPal. Even though they were functioning perfectly for years. we’re seeing orders marked as “pending payment” with no customer information (all fields black). We have no idea how or why this is happening. Any help would be greatly appreciated!
    Below is screen show of what I see and debug log.

    ScreenShot: https://ibb.co/kg3t8qH

    Debug Below:

    [25-Jun-2024 04:45:36 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpaw_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, QM_DB->query
    [25-Jun-2024 04:45:36 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpaw_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, QM_DB->query
    [25-Jun-2024 04:45:36 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpaw_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, QM_DB->query
    [25-Jun-2024 04:45:36 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpaw_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, QM_DB->query
    [25-Jun-2024 04:45:36 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wpaw_options (option_name, option_value, autoload) VALUES (‘action_scheduler_lock_async-request-runner’, ‘667a4b70156050.07271713|1719290796’, ‘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, QM_DB->query
    [25-Jun-2024 04:45:36 UTC] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wpaw_options SET option_value = ‘1721882736’ 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, QM_DB->query

    • This topic was modified 9 months ago by bashsmusic. Reason: added more info
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Blank Orders with Pending Payment Status error? Need Help!’ is closed to new replies.

Tags