• Resolved dc8734

    (@dc8734)


    This is related to the post below:

    https://www.ads-software.com/support/topic/square-disconnecting/

    We are having issues with the Square plugin disconnecting every month. In WooCommerce – Status – Scheduled Actions – Failed, we can see that wc_square_refresh_connection failed with this information:

    action failed via Async Request: Scheduled action for wpforms_pro_admin_entries_export_remove_old_export_files will not be executed as no callbacks are registered.

    Under Pending, we can see wc_square_refresh_connection is scheduled for every 12 hours.

    This is happening every month and we have to manually go in and reconnect with Square.

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support omarfpg a11n

    (@omarfpg)

    Hi @dc8734,

    Can you let us know more about this behavior? Does it happen every 30 or 45 days? The Square token should last for 30 days plus 15 days grace period. The refresh connection should take care of this, so you don’t have to, though. After reconnecting manually, it works without issues, correct?

    The error message you shared mentions WPForms. Can you share an uncropped screenshot of your failed scheduled actions where the wc_square_refresh_connection action is shown to learn more?

    In the meantime, we’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

    • System Status Report?which you can find via WooCommerce > Status > Get system report > Copy for support.
    • Fatal error logs?(if any) under WooCommerce > Status > Logs.
      You could copy and paste your reply here or paste it via?https://gist.github.com/?and send the link here.

    Once we have more information, we’ll be able to assist you further.

    All the best,
    -Omar

    Thread Starter dc8734

    (@dc8734)

    Thank you for the quick response. It has happened only twice, so I can’t say for sure on the frequency. It does work without issues once we reconnect manually.

    Our site also uses WPForms and WPForms Square plugin.

    Below is a link to the screenshot of the wc_square_refresh_connection action:

    https://wilmettehistory.org/whm-failed.jpg

    There are no fatal errors in the logs. Below is the System Status Report from WooCommerce.

    WordPress Environment
    
    WordPress address (URL): https://wilmettehistory.org
    Site address (URL): https://wilmettehistory.org
    WC Version: 8.6.1
    REST API Version: ? 8.6.1
    WC Blocks Version: ? 11.8.0-dev
    Action Scheduler Version: ? 3.7.1
    Log Directory Writable: ?
    WP Version: 6.4.3
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: – Server Environment
    
    Server Info: Apache
    PHP Version: 7.4.33
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 8.2.1
    OpenSSL/3.1.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.44-48-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? Database
    
    WC Database Version: 8.5.2
    WC Database Prefix: naj_
    Total Database Size: 89.56MB
    Database Data Size: 82.02MB
    Database Index Size: 7.54MB
    naj_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    naj_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    naj_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_woocommerce_order_itemmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    naj_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    naj_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_actionscheduler_actions: Data: 0.23MB + Index: 0.22MB + Engine InnoDB
    naj_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_actionscheduler_logs: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
    naj_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    naj_automatewoo_customers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    naj_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    naj_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    naj_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    naj_automatewoo_log_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    naj_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    naj_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_comments: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    naj_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_options: Data: 7.03MB + Index: 0.14MB + Engine InnoDB
    naj_postmeta: Data: 3.03MB + Index: 1.97MB + Engine InnoDB
    naj_posts: Data: 67.23MB + Index: 0.45MB + Engine InnoDB
    naj_ptp_tables: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_realmedialibrary: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_realmedialibrary_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_realmedialibrary_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_realmedialibrary_tmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_sgs_log_events: Data: 2.02MB + Index: 2.02MB + Engine InnoDB
    naj_sgs_log_visitors: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
    naj_tabulizer_data_source: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_tabulizer_data_source_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_tabulizer_data_source_cache_key_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_tabulizer_data_source_cache_properties: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_tabulizer_data_source_publishing_preferences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_tabulizer_user_permissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_tabulizer_user_preferences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_tec_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_tec_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    naj_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_term_relationships: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    naj_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    naj_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    naj_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    naj_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    naj_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    naj_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    naj_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    naj_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    naj_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    naj_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    naj_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    naj_woocommerce_square_customers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    naj_wpforms_entries: Data: 0.11MB + Index: 0.02MB + Engine InnoDB
    naj_wpforms_entry_fields: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    naj_wpforms_entry_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    naj_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    naj_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    naj_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    naj_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts
    
    acf-field: 5
    acf-field-group: 1
    attachment: 626
    avada_faq: 9
    avada_portfolio: 5
    aw_workflow: 2
    custom_css: 1
    exhibition: 1
    fusion_element: 41
    fusion_form: 3
    fusion_icons: 2
    fusion_tb_layout: 5
    fusion_tb_section: 19
    nav_menu_item: 49
    oembed_cache: 1
    oral_histories: 99
    page: 91
    post: 15
    product: 37
    product_variation: 24
    revision: 2723
    shop_order: 133
    shop_order_refund: 8
    slide: 1
    tablepress_table: 1
    tec_tc_ticket: 2
    ticket-meta-fieldset: 1
    tribe_events: 27
    tribe_organizer: 2
    tribe_rsvp_attendees: 100
    tribe_rsvp_tickets: 6
    tribe_venue: 1
    tribe_wooticket: 182
    wp_global_styles: 2
    wp_navigation: 1
    wpforms: 8 Security
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ? Active Plugins (22)
    
    Advanced Custom Fields: by WP Engine – 6.2.7
    AutomateWoo: by WooCommerce – 5.5.21
    Custom Post Type UI: by WebDevStudios – 1.15.1
    Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
    Enable Media Replace: by ShortPixel – 4.1.5
    Event Tickets Plus: by The Events Calendar – 5.9.2
    Event Tickets: by The Events Calendar – 5.8.2
    Avada Builder: by ThemeFusion – 3.11.6
    Avada Core: by ThemeFusion – 5.11.6
    Media Library Organizer: by Optimole – 1.6.0
    We’re Open!: by Noah Hearle
    Design Extreme – 1.61
    
    Posts Table Pro: by Barn2 Plugins – 3.1.3
    Speed Optimizer: by SiteGround – 7.4.6
    Security Optimizer: by SiteGround – 1.4.12
    Tabulizer: by Dimitrios Mourloukos – 6.5.1
    The Events Calendar: by The Events Calendar – 6.3.3.1
    WooCommerce Google Analytics Integration: by WooCommerce – 1.8.14
    WooCommerce Square: by WooCommerce – 4.5.1
    WooCommerce: by Automattic – 8.6.1
    WPForms Google Sheets: by WPForms – 2.0.1
    WPForms Square: by WPForms – 1.9.0
    WPForms: by WPForms – 1.8.7.2 Inactive Plugins (6)
    
    Advanced Custom Fields PRO: by Delicious Brains – 5.12.2
    Posts Table with Search & Sort: by Barn2 Plugins – 1.4.5
    SiteGround Central: by SiteGround – 2.0.4
    The Events Calendar PRO: by The Events Calendar – 5.14.5
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 2.23.14.26
    
    User Role Editor: by Vladimir Garagulya – 4.64.2 Settings
    
    API Enabled: ?
    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)
    variable subscription (variable-subscription)
    
    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 Woo.com: –
    Enforce Approved Product Download Directories: –
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: – WC Pages
    
    Shop base: #520 - /shop/
    Cart: #585 - /cart/
    Checkout: #586 - /checkout/
    My account: #587 - /my-account-2/
    Terms and conditions: ? Page not set Theme
    
    Name: Wilmette Historical Museum
    Version: 1.0.0
    Author URL: https://theme-fusion.com
    Child Theme: ?
    Parent Theme Name: Avada
    Parent Theme Version: 7.11.6
    Parent Theme Author URL: https://themeforest.net/user/ThemeFusion
    WooCommerce Support: ? Templates
    
    Overrides: Avada/woocommerce/cart/cart.php
    Avada/woocommerce/checkout/form-pay.php
    Avada/woocommerce/checkout/review-order.php
    Avada/woocommerce/single-product/short-description.php
    Avada/woocommerce/single-product/tabs/additional-information.php
    Avada/woocommerce/single-product/tabs/description.php Square
    
    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Save to Log Admin
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    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-variation-management
    product-virtual-downloadable
    product-external-affiliate
    product-grouped
    product-linked
    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: customize-store
    minified-js
    new-product-management-experience
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    
    Daily Cron: ? Next scheduled: 2024-03-02 16:34:43 -06:00
    Options: ?
    Notes: 175
    Onboarding: completed Action Scheduler
    
    Complete: 627
    Oldest: 2024-01-30 15:43:00 -0600
    Newest: 2024-03-01 11:36:55 -0600
    
    Failed: 8
    Oldest: 2023-03-24 06:59:23 -0500
    Newest: 2024-02-02 13:20:13 -0600
    
    Pending: 13
    Oldest: 2024-03-01 17:02:08 -0600
    Newest: 2024-03-08 11:36:55 -0600 Status report information
    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @dc8734,

    Thanks again for sharing more details on this.

    Thank you for the quick response. It has happened only twice, so I can’t say for sure on the frequency. It does work without issues once we reconnect manually.

    You can try to install?this plugin as?it can report some common cron issues so you will get some information about any failed cron jobs.

    The other option is to have a staging site with all your plugins activated, leaving out the WPForms plugin to see if the issue will be replicated.

    I hope this helps.

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WooCommerce Square Plugin disconnecting’ is closed to new replies.