• Resolved jbender929

    (@jbender929)


    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
    `
Viewing 1 replies (of 1 total)
  • Hi @jbender929

    Thanks for reaching out!

    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.

    I understand that you are using the premium plugin, WooCommerce Subscriptions for orders affected by your issue here.

    If you have a valid subscription with us, can you please open a support request for us to investigate further about your issue?

    Please include a link to this forum thread for us to check what has been done so far.

    Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘Orders not completing correctly’ is closed to new replies.