Orders not completing correctly
-
Recently I have noticed an increase in subscriptions being set to pending/cancelled and it appears to be caused by an order not completing correctly. The payment is going through, and the order shows as completed but I get an error in the Order Notes.
Normally after the order is approved it shows that the order is changed from Pending to Completed. But on some transactions I’m seeing the error in the image. I’ve noticed that the error shows up when the billing email address is different from users account email address. This first started happening after updating to v7.2.0 on December 20th, 2022. Prior to that we didn’t have any issues emails not matching.
I’ve searched all over to see if that error is coming from Woocommerce/ Woocommerce Subscriptions or my payment gateway plugin. I haven’t been able to find anything about the error message.
This is all that shows in the logs:
2023-01-03T01:21:38+00:00 ERROR Status transition of order #559514 errored! 2023-01-03T01:27:45+00:00 ERROR Status transition of order #559516 errored! 2023-01-03T01:31:29+00:00 ERROR Status transition of order #559519 errored! 2023-01-03T02:11:33+00:00 ERROR Status transition of order #559526 errored! 2023-01-03T03:08:55+00:00 ERROR Status transition of order #559531 errored! 2023-01-03T03:51:43+00:00 ERROR Status transition of order #559545 errored! 2023-01-03T03:53:48+00:00 ERROR Status transition of order #559547 errored! 2023-01-03T05:03:17+00:00 ERROR Status transition of order #559560 errored! 2023-01-03T05:06:16+00:00 ERROR Status transition of order #559562 errored! 2023-01-03T05:07:12+00:00 ERROR Status transition of order #559564 errored! 2023-01-03T05:09:33+00:00 ERROR Status transition of order #559566 errored! 2023-01-03T05:30:09+00:00 ERROR Status transition of order #559573 errored! 2023-01-03T08:10:29+00:00 ERROR Status transition of order #559593 errored! 2023-01-03T09:37:16+00:00 ERROR Status transition of order #559601 errored! 2023-01-03T09:40:38+00:00 ERROR Status transition of order #559604 errored! 2023-01-03T09:41:23+00:00 ERROR Status transition of order #559606 errored! 2023-01-03T14:19:50+00:00 ERROR Status transition of order #559610 errored! 2023-01-03T15:05:52+00:00 ERROR Status transition of order #559752 errored! 2023-01-03T15:10:25+00:00 ERROR Status transition of order #559766 errored! 2023-01-03T15:22:49+00:00 ERROR Status transition of order #559770 errored!
That’s just for today. That’s what multiple days of logs show.
This is causing subscriptions to stay on pending until a certain time has passed, then it switches to cancelled.
Any help would be appreciated.
` ### WordPress Environment ### WordPress address (URL): https://xxxxxxxxxxxxxx.org Site address (URL): https://xxxxxxxxxxxxxx.org WC Version: 7.2.2 REST API Version: ?</img> 7.2.2 WC Blocks Version: ?</img> 8.9.2 Action Scheduler Version: ?</img> 3.5.3 Log Directory Writable: ?</img> WP Version: 6.1.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ?</img> Language: en_US External object cache: ?</img> ### Server Environment ### Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 100 MB PHP Time Limit: 3600 PHP Max Input Vars: 10000 cURL Version: 7.58.0 OpenSSL/1.1.1 SUHOSIN Installed: – MySQL Version: 5.7.39-42-log Max Upload Size: 50 MB Default Timezone is UTC: ?</img> fsockopen/cURL: ?</img> SoapClient: ?</img> DOMDocument: ?</img> GZip: ?</img> Multibyte String: ?</img> Remote Post: ?</img> Remote Get: ?</img> ### Database ### WC Database Version: 7.2.2 WC Database Prefix: wp_ Total Database Size: 2536.19MB Database Data Size: 1351.51MB Database Index Size: 1184.68MB wp_woocommerce_sessions: Data: 3.02MB + Index: 0.08MB + 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: 25.56MB + Index: 9.52MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 217.78MB + Index: 119.33MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + 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: 35.44MB + Index: 34.34MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 24.52MB + Index: 16.25MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 99.64MB + Index: 75.20MB + Engine InnoDB wp_eorf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_eorf_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_formmaker_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_blocked: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_display_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_formmaker_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_query: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_submits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_formmaker_themes: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_formmaker_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_hkb_analytics_search_atomic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_hkb_exits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_hkb_visits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_hkb_voting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 13.38MB + Index: 0.45MB + Engine InnoDB wp_pmxe_exports: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 741.00MB + Index: 792.83MB + Engine InnoDB wp_posts: Data: 117.64MB + Index: 67.08MB + Engine InnoDB wp_shopmagic_automation_outcome: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_shopmagic_automation_outcome_logs: Data: 1.52MB + Index: 0.02MB + Engine InnoDB wp_shopmagic_guest: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_shopmagic_guest_meta: Data: 0.25MB + Index: 0.14MB + Engine InnoDB wp_shopmagic_marketing_lists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_shopmagic_tracked_emails: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_shopmagic_tracked_emails_clicks: Data: 0.02MB + Index: 0.02MB + 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: 1.52MB + Index: 1.52MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_usermeta: Data: 45.58MB + Index: 42.14MB + Engine InnoDB wp_users: Data: 2.52MB + Index: 4.55MB + Engine InnoDB wp_wcepp_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 1.52MB + Index: 1.91MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 1.52MB + Index: 3.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 7.52MB + Index: 9.06MB + Engine InnoDB wp_wc_order_stats: Data: 6.52MB + Index: 5.55MB + 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.34MB + Index: 0.77MB + 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_wfu_dbxqueue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfu_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfu_userdata: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wplc_chat_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 978 braintree_log: 1 custom_css: 3 epkb_post_type_1: 102 fmemailverification: 1 form-maker: 1 home_slider: 3 is_search_form: 2 joomsport_match: 9 joomsport_player: 12 joomsport_season: 2 joomsport_team: 4 nav_menu_item: 46 nectar_slider: 9 page: 134 popup: 7 popup_theme: 8 post: 10 product: 276 revision: 3 shop_coupon: 60255 shop_order: 140609 shop_order_refund: 96 shop_subscription: 158769 shopmagic_automation: 199 sp_calendar: 1 sp_column: 8 sp_list: 1 sp_metric: 2 sp_outcome: 3 sp_performance: 4 sp_player: 3 sp_result: 3 sp_staff: 1 sp_statistic: 4 sp_table: 1 sp_team: 2 team: 45 vc_settings_preset: 3 wpcf7_contact_form: 2 ### Security ### Secure connection (HTTPS): ?</img> Hide errors from visitors: ?</img> ### Active Plugins (45) ### Ivory Search: by Ivory Search – 5.4.10 Akismet Anti-Spam: by Automattic – 5.0.2 Authorize.Net WooCommerce Addon: by Syed Nazrul Hassan – 1.0.6 Brain Honey Integrator: by Ammon Lee – 1.0.0 CA Integrator: by Ammon Lee – 1.0.0 Classic Editor: by WordPress Contributors – 1.6.2 Contact Form 7: by Takayuki Miyoshi – 5.7.1 WooCommerce Coupon Generator: by Jeroen Sormani – 1.2.0 Disable Comments: by WPDeveloper – 2.4.2 Knowledge Base for Documents and FAQs: by Echo Plugins – 9.20.0 Enable Media Replace: by ShortPixel – 4.0.1 FileBird Lite: by Ninja Team – 5.1 Form Maker: by 10Web Form Builder Team – 1.15.7 Site Kit by Google: by Google – 1.90.0 Indeed My Team (Visual Composer Version): by indeed – 3.2 Jetpack: by Automattic – 11.6 Salient WPBakery Page Builder: by Michael M - WPBakery.com | Modified by ThemeNectar – 6.6.0 Order / Coupon / Subscription Export Import Plugin for WooCommerce: by WebToffee – 2.4.9 Order Export & Order Import for WooCommerce: by WebToffee – 2.2.9 Popup Maker: by Popup Maker – 1.17.1 POWr Countdown Timer: by POWr.io – 1.6.3 Salient Core: by ThemeNectar – 1.8.2 Salient Demo Importer: by ThemeNectar – 1.3 Salient Home Slider: by ThemeNectar – 1.4 Salient Nectar Slider: by ThemeNectar – 1.7 Salient Portfolio: by ThemeNectar – 1.7 Salient Shortcodes: by ThemeNectar – 1.5 Salient Social: by ThemeNectar – 1.2 Salient Widgets: by ThemeNectar – 1.2 ShopMagic Advanced Filters: by WP Desk – 2.1.0 ShopMagic for WooCommerce: by WP Desk – 3.0.6 ShopMagic for WooCommerce Subscriptions: by WP Desk – 1.6.0 Simple Banner: by Ryan Petersen – 2.12.2 User Menus: by Code Atlantic – 1.3.1 User Switching: by John Blackbourn & contributors – 1.7.0 Import Export WordPress Users and WooCommerce Customers: by WebToffee – 2.3.6 WooCommerce Order Status Control: by SkyVerge – 1.15.0 WooCommerce Subscriptions: by WooCommerce – 4.7.0 WooCommerce: by Automattic – 7.2.2 WP Bulk Delete: by Xylus Themes – 1.2.3 WP File Manager: by mndpsingh287 – 7.1.7 LiveChat: by LiveChat – 4.5.8 WP Mail SMTP: by WPForms – 3.7.0 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.10 Wordpress User Integration: by Ammon Lee – 1.0.0 ### Inactive Plugins (10) ### Akismet: by Automattic – 2.5.6 Alligator Popup: by cubecolour – 1.2.1 BAW Login/Logout menu: by Juliobox – 1.3.3 Enable jQuery Migrate Helper: by The WordPress Team – 1.3.0 Import and export users and customers: by codection – 1.21.3 Manual Credit Card Processing for WooCommerce: by WooDev – 1.6.1 Quick Reports for WooCommerce: by theDotstore – 2.7.1 Search and Navigation Popup: by WP OnlineSupport Essential Plugin – 1.1.1 Simple Require Login: by timmcdaniels – 0.2 Woocommerce Cart Limit: by Webman Technologies – 1.2 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php object-cache.php: Memcached Redux ### Must Use Plugins (5) ### Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0 WP Engine Cache Plugin: by WP Engine – 1.1.0 WP Engine Seamless Login Plugin: by WP Engine – 1.6.0 WP Engine Security Auditor: by wpengine – 1.0.10 WP Engine System: by WP Engine – 5.0.1 ### Settings ### API Enabled: ?</img> Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) subscription (subscription) 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: ?</img> Enforce Approved Product Download Directories: – Order datastore: WC_Order_Data_Store_CPT ### WC Pages ### Shop base: #7 - /shop/ Cart: #8 - /cart/ Checkout: #7169 - /checkout/ My account: #7158 - /my-account/ Terms and conditions: #37821 - /terms-and-conditions/ ### Theme ### Name: Salient Child Theme Version: 0.1 Author URL: Child Theme: ?</img> Parent Theme Name: Salient Parent Theme Version: 13.0.5 Parent Theme Author URL: https://themeforest.net/user/themenectar WooCommerce Support: ?</img> ### Templates ### Overrides: salient/woocommerce/cart/mini-cart.php salient/woocommerce/checkout/form-checkout.php salient/woocommerce/checkout/review-order.php salient/woocommerce/checkout/terms.php salient/woocommerce/content-product.php salient/woocommerce/content-single-product.php salient/woocommerce/loop/add-to-cart.php salient/woocommerce/loop/loop-start.php salient/woocommerce/myaccount/form-login.php version 6.0.0 is out of date. The core version is 7.0.1 salient/woocommerce/single-product/product-image.php salient/woocommerce/single-product/rating.php salient/woocommerce/single-product/tabs/description.php salient/woocommerce/single-product/tabs/tabs.php salient/woocommerce/single-product/title.php salient/woocommerce/single-product-reviews.php Outdated Templates: ?</img> Learn how to update ### Subscriptions ### WCS_DEBUG: ?</img> No Subscriptions Mode: ?</img> Live Subscriptions Live URL: https://xxxxxxxxxxxxxx.org Subscription Statuses: trash: 30 auto-draft: 8 wc-active: 6757 wc-expired: 141445 wc-pending: 27 wc-on-hold: 7734 wc-cancelled: 2768 WooCommerce Account Connected: ?</img> Yes Active Product Key: ?</img> Yes Report Cache Enabled: ?</img> Yes Cache Update Failures: ?</img> 0 failure ### Store Setup ### Country / State: United States (US) — Utah ### Subscriptions by Payment Gateway ### Authorize.Net Cards Settings: trash: 23 wc-active: 4941 wc-cancelled: 934 wc-expired: 35780 wc-on-hold: 79 wc-pending: 12 ### Payment Gateway Support ### Authorize.Net Cards Settings: products refunds ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks 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 Daily Cron: ?</img> Next scheduled: 2023-01-04 19:46:26 +00:00 Options: ?</img> Notes: 112 Onboarding: completed ### Action Scheduler ### Complete: 97,330 Oldest: 2022-12-05 14:35:36 +0000 Newest: 2023-01-03 22:48:15 +0000 Failed: 1,904 Oldest: 2020-04-05 20:25:18 +0000 Newest: 2022-12-20 17:33:10 +0000 Pending: 5,815 Oldest: 2023-01-03 22:49:56 +0000 Newest: 2024-01-03 22:31:00 +0000 ### Status report information ### Generated at: 2023-01-03 22:50:14 +00:00 `
- The topic ‘Orders not completing correctly’ is closed to new replies.