• I get “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.” when placing an order on my website. My clients don’t get to confirm their orders but I get them in the back-end.
    I have run tests to find any conflicting plugins and haven’t found any. I tried to change the theme but still got the same results. I removed all payment processing plugins and left cash on delivery and I still have the same problem. Please help me out. This has lowered my sales

    Please find below my woo commerce system report

    `
    ### WordPress Environment ###

    WordPress address (URL): https://dev.umarperfumes.in
    Site address (URL): https://dev.umarperfumes.in
    WC Version: 9.0.0
    Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
    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_US
    External object cache: ✔

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 8.1.27
    PHP Post Max Size: 2 GB
    PHP Time Limit: 360
    PHP Max Input Vars: 5000
    cURL Version: 7.87.0
    OpenSSL/1.1.1w

    SUHOSIN Installed: –
    MySQL Version: 10.11.7-MariaDB-cll-lve
    Max Upload Size: 2 GB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    WC Database Version: 9.0.0
    WC Database Prefix: wp_
    Total Database Size: 21.32MB
    Database Data Size: 17.00MB
    Database Index Size: 4.32MB
    wp_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 1.48MB + Index: 0.73MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
    wp_cartflows_ca_cart_abandonment: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_options: Data: 6.09MB + Index: 0.16MB + Engine InnoDB
    wp_postmeta: Data: 2.52MB + Index: 0.69MB + Engine InnoDB
    wp_posts: Data: 3.50MB + Index: 0.22MB + Engine InnoDB
    wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.09MB + Index: 0.08MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_orders: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
    wp_wc_orders_meta: Data: 0.13MB + Index: 0.23MB + Engine InnoDB
    wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 262
    blocks: 11
    cartflows_flow: 1
    cartflows_step: 2
    customize_changeset: 3
    elementor_library: 1
    featured_item: 8
    nav_menu_item: 62
    page: 79
    post: 3
    product: 89
    product_variation: 145
    revision: 198
    shop_coupon: 3
    shop_order_placehold: 70
    wp_global_styles: 2
    wp_navigation: 1
    wp_template: 2
    wpcf7_contact_form: 5

    ### Security ###

    Secure connection (HTTPS): ✔
    Hide errors from visitors: ❌Error messages should not be shown to visitors.

    ### Active Plugins (7) ###

    Query Monitor: by John Blackbourn – 3.16.3
    Debug Bar: by wordpressdotorg – 1.1.6
    LiteSpeed Cache: by LiteSpeed Technologies – 6.2.0.1
    WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.27
    WooCommerce: by Automattic – 9.0.0
    WP Debugging: by Andy Fragen – 2.11.24
    YITH WooCommerce Wishlist: by YITH – 3.35.0

    ### Inactive Plugins (9) ###

    1 Razorpay: Signup for FREE PG: by Team Razorpay – 4.6.7
    CartFlows: by CartFlows Inc – 2.0.8
    Contact Form 7: by Takayuki Miyoshi – 5.9.6
    Elementor: by Elementor.com – 3.22.1
    Nextend Social Login: by Nextendweb – 3.1.13
    Pinterest for WooCommerce: by WooCommerce – 1.3.24
    Rank Math SEO with AI SEO Tools: by Rank Math – 1.0.221
    Site Kit by Google: by Google – 1.129.0
    Spectra: by Brainstorm Force – 2.13.7

    ### Dropin Plugins () ###

    db.php: Query Monitor Database Class (Drop-in)
    object-cache.php: object-cache.php

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

    Disable Auto Updates: by –

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: INR (₹)
    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: 105 KB

    ### WC Pages ###

    Shop base: #6 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    Terms and conditions: #81 - /terms-and-condition/

    ### Theme ###

    Name: Twenty Twenty-Four
    Version: 1.1
    Author URL: https://wordpress.org
    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: ❌ Not declared

    ### Templates ###

    Overrides: /home/u990034307/domains/umarperfumes.in/public_html/dev/wp-content/plugins/woocommerce/templates/block-notices/error.php
    /home/u990034307/domains/umarperfumes.in/public_html/dev/wp-content/plugins/woocommerce/templates/block-notices/notice.php
    /home/u990034307/domains/umarperfumes.in/public_html/dev/wp-content/plugins/woocommerce/templates/block-notices/success.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-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
    pattern-toolkit-full-composability
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    launch-your-store
    product-editor-template-system

    Daily Cron: ✔ Next scheduled: 2024-06-20 12:38:47 +05:30
    Options: ✔
    Notes: 86
    Onboarding: completed

    ### Action Scheduler ###

    Complete: 2,441
    Oldest: 2024-05-20 16:52:58 +0530
    Newest: 2024-06-20 15:40:09 +0530

    Failed: 47
    Oldest: 2024-03-09 18:13:51 +0530
    Newest: 2024-06-20 15:40:03 +0530

    Pending: 10
    Oldest: 2024-06-20 16:40:03 +0530
    Newest: 2024-06-29 11:59:29 +0530


    ### Status report information ###

    Generated at: 2024-06-20 15:40:18 +05:30
    • This topic was modified 2 months, 1 week ago by faizk86.

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support carolm29 (woo-hc)

    (@carolm29)

    Hey there, @faizk86! Thanks for contacting us. I’m happy to help you.

    To confirm, you ran a conflict test and this issue is happening with Cash On Delivery on a website with only WooCommerce active and a default theme such as Storefront or Twenty Twenty-Four, correct?

    I found another thread where the user had this error and it was an issue with their host. They did mention the host had issues with one specific plugin, which you don’t seem to use, Google Analytics Pro, but can you please reach out to your host and check if everything is okay on their end or if there’s something going on that can be causing this?

    Please let us know how it goes.

    Have a wonderful day!

    Hello,

    We are facing the same problem.
    We are getting multiple orders because customers keep clicking on Purchase button and facing this error.

    We get order on the backend side, but no email is sent as confirmation.

    Customer is facing this error message on our checkout page:

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

    I dont know how to do that.
    This problem started to happen day or two before today.

    Plugin Support carolm29 (woo-hc)

    (@carolm29)

    Hey, @balavander!

    Per WordPress forum guidelines, would you mind opening up a new thread for this so that we can keep things organized and offer more personalized support for you? We’ll be happy to help you out with this over there!

    Have a wonderful day!

    Thread Starter faizk86

    (@faizk86)

    @carolm29 sure i will check with my host and let you know, and also we aren’t using analytics pro.

    Plugin Support Rajesh K. (woo-hc)

    (@rajeshml)

    Hello @faizk86,

    Thanks for the updating us on this. Please let us know how it goes with the host.

    Cheers!

    Thread Starter faizk86

    (@faizk86)

    @rajeshml @carolm29 i found this in my log
    ] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1722060449’ 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, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_option

    Plugin Support Shameem (woo-hc)

    (@shameemreza)

    Hi @balavander

    We get order on the backend side, but no email is sent as confirmation.

    This is an SMTP-related issue! Installing a plugin like WP Mail SMTP and configuring your mail server will resolve the issue.

    If you need, please review our email sending FAQ for help, troubleshooting steps and solutions here: https://woo.com/document/email-faq/

    Hi @faizk86

    WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1722060449’ 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, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_option

    The Command out-of-sync error occurred in the three cases below.

    • If you are using the cache or security plugin.
    • If the memory size is exhausted.
    • If the memory size is exhausted.

    Can you please try the below steps to identify the issue?

    • If you use any cache, security plugin or server cache, please disable it and check it again.
    • Check if your site database memory size is exhausted or not. To do so, you can increase your WP Memory Limit from 256 MB to 512 MB or higher.
    • Switch to a default theme like Storefront or Twenty Twenty-Four, disable all other plugins except WooCommerce, and check whether the issue is resolved.

    If the issue remains, or you have any other questions or need further assistance, please don’t hesitate to ask. Looking forward to hearing from you!

    Thread Starter faizk86

    (@faizk86)

    @shameemreza as per your instruction i did the steps and i got this errors.

    [06-Jul-2024 10:50:23 UTC] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1722855023’ 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
    [06-Jul-2024 14:45:36 UTC] Cron reschedule event error for hook: litespeed_task_imgoptm_pull, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {“schedule”:”litespeed_filter”,”args”:[],”interval”:60}
    [06-Jul-2024 14:46:09 UTC] Cron reschedule event error for hook: litespeed_task_lqip, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {“schedule”:”litespeed_filter”,”args”:[],”interval”:60}
    [06-Jul-2024 14:46:21 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3.
    [06-Jul-2024 14:46:21 UTC] The Automattic\WooCommerce\Admin\API\Options::get_options function is deprecated since version 6.3.

    Plugin Support Shameem (woo-hc)

    (@shameemreza)

    Hi @faizk86

    Thanks for following the instructions and sharing updates.

    Cron reschedule event error for hook: litespeed_task_imgoptm_pull, Error code: invalid_schedule, Error message: Event schedule does not exist

    This suggests that the cache plugin is still active on your site or server. Can you check again and make sure no cache is active? Also, check whether your hosting server has any corn issues. If needed, you can contact your hosting provider for assistance with this.

    WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1722855023’ 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

    The error you’re seeing suggests that there’s still a cache issue. Could you try disabling all plugins except for WooCommerce, temporarily switch your theme to Twenty Twenty-Four and see if the problem continues?

    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
    • Product lookup tables – Regenerate
    • Regenerate the product attributes lookup table – Regenerate

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

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

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