• Resolved smartflex

    (@smartflex)


    Hello,

    I updated the plugin and now I can’t reconnect to square using the connect button.
    I get to the square page with the permissions but then get an unknown error on submit and it goes nowhere.
    Based on the logs, there is a problem with the access token. I can’t find anyway to get a new key – I’ve tried deleting the plugin and reinstalling it.

    Thanks!

    11-08-2019 @ 22:25:25 – Starting upgrade to v2.0.0
    11-08-2019 @ 22:25:25 – Migrating plugin settings…
    11-08-2019 @ 22:25:25 – Plugin settings migration complete.
    11-08-2019 @ 22:25:25 – Migrating gateway settings…
    11-08-2019 @ 22:25:25 – Gateway settings migration complete.
    11-08-2019 @ 22:25:25 – Migrating orders data…
    11-08-2019 @ 22:25:25 – Orders migration complete.
    11-08-2019 @ 22:25:25 – Migrating products data…
    11-08-2019 @ 22:25:25 – Products migration complete.
    11-08-2019 @ 22:25:25 – Migrating customer data.
    11-08-2019 @ 22:25:25 – 0 customers migrated
    11-08-2019 @ 22:25:25 – Upgrade to v2.0.0 complete
    11-08-2019 @ 22:25:25 – Starting upgrade to v2.0.4
    11-08-2019 @ 22:25:25 – Upgrade to v2.0.4 complete
    11-08-2019 @ 22:25:53 – Access Token Expired, attempting a refresh.
    11-08-2019 @ 22:25:53 – Refreshing connection…
    11-08-2019 @ 22:25:53 – No refresh token stored, cannot refresh connection.
    11-08-2019 @ 22:25:53 – Disconnected due to invalid authorization. Please try connecting again.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Ryan Ray, a11n

    (@ryanr14)

    Hi @smartflex,

    Very sorry for the trouble here updating your Square plugin. From the logs it looks like you were trying to update to Square version 2.0.4? Is that correct?

    If so, could you manually update the plugin to the current version at 2.0.6? This release and really the previous one (2.0.5) had fixes for this token issue.

    Once updated to the current release you should be able to connect without issues.

    Thread Starter smartflex

    (@smartflex)

    Hi @ryanr14

    I manually updated to the 2.06 plugin as suggested – but I’m still having the same issue with reconnecting to square; I press allow on the permissions screen and receive the message “An error has occurred. Please try again.”.

    The error logs aren’t showing anything so I’ve no idea if it’s still a token issue.

    I’ve included the system info below in case that helps;

    Thanks!

    
    ### WordPress Environment ###
    
    WC Version: 3.8.0
    REST API Version: ? 1.0.2
    Log Directory Writable: ?
    WP Version: 5.2.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: 7.3.11
    PHP Post Max Size: 80 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.66.0
    OpenSSL/1.0.2t
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.0.38-MariaDB
    Max Upload Size: 20 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 3.8.0
    MaxMind GeoIP Database: ?
    Total Database Size: 45.06MB
    Database Data Size: 36.38MB
    Database Index Size: 8.68MB
    wp_woocommerce_sessions: Data: 0.52MB + Index: 0.02MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 0.04MB + Index: 0.03MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    ts_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
    wp_cp_calculated_fields_form_discount_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cp_calculated_fields_form_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cp_calculated_fields_form_settings: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wp_defender_lockout: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_defender_lockout_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_frm_fields: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_frm_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_frm_items: Data: 0.25MB + Index: 0.08MB + Engine InnoDB
    wp_frm_item_metas: Data: 1.52MB + Index: 0.36MB + Engine InnoDB
    wp_hustle_modules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_hustle_modules_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_img_optm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_litespeed_optimizer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_nextend2_section_storage: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nextend2_smartslider3_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nextend2_smartslider3_slides: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_optins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_optin_meta: Data: 0.28MB + Index: 0.13MB + Engine InnoDB
    wp_options: Data: 5.16MB + Index: 0.06MB + Engine InnoDB
    wp_postmeta: Data: 4.41MB + Index: 2.61MB + Engine InnoDB
    wp_posts: Data: 1.52MB + Index: 0.22MB + Engine InnoDB
    wp_smush_dir_images: 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.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfBlockedIPLog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfConfig: Data: 1.25MB + Index: 0.00MB + Engine InnoDB
    wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfFileMods: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfHits: Data: 1.02MB + Index: 0.23MB + Engine InnoDB
    wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfKnownFileList: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfLogins: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfNotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfStatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_square_customers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    _snap_rcv_wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    _snap_rcv_wp_comments: Data: 0.47MB + Index: 0.08MB + Engine InnoDB
    _snap_rcv_wp_cp_calculated_fields_form_discount_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    _snap_rcv_wp_cp_calculated_fields_form_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    _snap_rcv_wp_cp_calculated_fields_form_settings: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    _snap_rcv_wp_defender_lockout: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    _snap_rcv_wp_defender_lockout_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    _snap_rcv_wp_frm_fields: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
    _snap_rcv_wp_frm_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _snap_rcv_wp_frm_item_metas: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
    _snap_rcv_wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _snap_rcv_wp_options: Data: 4.52MB + Index: 0.20MB + Engine InnoDB
    _snap_rcv_wp_postmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    _snap_rcv_wp_posts: Data: 1.52MB + Index: 0.22MB + Engine InnoDB
    _snap_rcv_wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    _snap_rcv_wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    _snap_rcv_wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _snap_rcv_wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    _snap_rcv_wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    _snap_rcv_wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (17) ###
    
    301 Redirects: by WebFactoryLtd – 0.4
    BJ Lazy Load: by Bj?rn Johansen
    Aron Tornberg
    angrycreative – 1.0.9
    
    Custom Sidebars Pro: by WPMU DEV – 3.2.3
    Display Posts: by Bill Erickson – 3.0.2
    Formidable Forms Pro: by Strategy11 – 4.03.03
    Formidable Forms: by Strategy11 – 4.03.03
    Smart Slider 3 Pro: by Nextend – 3.3.22
    Recent Custom Posts Type Widget: by Ve Bailovity (Incsub) – 2.1.2
    Snapshot Pro: by WPMU DEV – 3.2.1.3
    WC Hide Shipping Methods: by Rynaldo Stoltz – 1.3
    WooCommerce Square: by WooCommerce – 2.0.6 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.8.0
    Wordfence Security: by Wordfence – 7.4.1
    Defender Pro: by WPMU DEV – 2.2.2
    WP Media folder: by Joomunited – 4.9.5
    SmartCrawl: by WPMU DEV – 2.4.2
    WPMU DEV Dashboard: by WPMU DEV – 4.7.3.5
    
    ### Inactive Plugins (20) ###
    
    Advanced Custom Fields: by Elliot Condon – 5.8.6
    Advanced Custom Fields: Options Page: by Elliot Condon – 2.0.1
    Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.0.1
    Akismet Anti-Spam: by Automattic – 4.1.3
    Calculated Fields Form: by CodePeople – 1.0.339
    Debug Objects: by Frank Bültge – 2.5.0
    Duplicate Page: by mndpsingh287 – 4.0
    Enable Media Replace: by ShortPixel – 3.3.6
    File Manager: by Aftabul Islam – 5.1.9
    Go Live Update Urls: by OnPoint Plugins – 5.2.12
    Hustle Pro: by WPMU DEV – 4.0.3
    LiteSpeed Cache: by LiteSpeed Technologies – 2.9.9
    Menu Social Icons: by Paul Clark – 1.3.10
    Send System Info: by Matt Cromwell – 1.3
    Server Info: by Usman Ali Qureshi – 2.5.3
    Smush Pro: by WPMU DEV – 3.3.1
    Upcoming Events Lists: by Sayful Islam – 1.3.3
    WordPress Importer: by wordpressdotorg – 0.6.4
    WordPress Media Select Bulk Downloader: by webwave GmbH – 1.0.0
    WP Server Stats: by Saumya Majumder – 1.6.8
    
    ### 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)
    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: –
    
    ### WC Pages ###
    
    Shop base: #3505 - /shop/
    Cart: #3506 - /cart/
    Checkout: #3507 - /checkout/
    My account: #3508 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Sage Theme
    Version: 1.2
    Author URL: https://www.ads-software.com/
    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: –
    
    ### Square ###
    
    Environment: Production
    Tokenization Enabled: 
    Debug Mode: Save to Log
    
    ### Action Scheduler ###
    
    Complete: 18
    Oldest: 2019-11-08 22:29:43 +0000
    Newest: 2019-11-08 23:33:08 +0000
    
    Pending: 0
    Oldest: –
    Newest: –
    
    Canceled: 1
    Oldest: 2019-11-08 23:25:49 +0000
    Newest: 2019-11-08 23:25:49 +0000
    
    In-progress: 0
    Oldest: –
    Newest: –
    
    Failed: 0
    Oldest: –
    Newest: –
    
    
    OneNEWS.com

    (@indoonenews00107media)

    Help For this problem.

    Plugin Support con

    (@conschneider)

    Engineer

    Howdy @smartflex,

    Thanks for the system status report. From the top of my head I reckon we might have a cache problem (even when activated most caching plugins leave their files) or some security plugin is interfering.

    Could you spin up a quick test site and see if that connects ok? Furthermore here is a REST API log plugin: https://www.ads-software.com/plugins/wp-rest-api-log/

    **Before you do that, please do make a full backup!**

    Does anything show in the logs when you try and connect with it?

    Kind regards,

    Thread Starter smartflex

    (@smartflex)

    Hi @conschneider

    I added woocommerce and the square plugin to a different install of wp on the same server – and had the same issue. How can I troubleshoot the connection from the server level?

    (It’s a litespeed / cpanel server running on a google cloud instance if that helps at all.)

    I did try with all security / caching off but that didn’t help. On your suggestions I completely deleted the Litespeed plugin (the only caching) and still had the problem.

    I installed the rest api log – but after failing to connect to square, there was nothing in the log :/

    Thank you kindly!

    Thread Starter smartflex

    (@smartflex)

    *bump*

    Hello – it’s been a couple days so I wasn’t sure if I should bump this or not?

    Again; everything was working fine, no changes on the server level that I am aware of – but I’m happy to troubleshoot in whatever direction you can point me?

    Thanks,

    Plugin Support con

    (@conschneider)

    Engineer

    Hi again,

    The empty logs are not helping ;).
    Let’s try one other environment to rule out the server configuration. Are you able to test on a local environment that has a more “standard” tech stack with Apache or Nginx?

    Other than that any chance for you to access server logs? The PHP error logs and access logs would be helpful (really anything at that point).

    Kind regards,

    Thread Starter smartflex

    (@smartflex)

    Solved,

    The issue is the type of square account that is being used. It was an admin account which was used previously, but apparently it must now be the owner account.

    Logged-in with the owner account and no error connecting.

    Hope this helps someone else!

    Plugin Support Ryan Ray, a11n

    (@ryanr14)

    Hi @smartflex,

    Thank you for letting us know, that is super helpful to be aware of and something I hadn’t considered causing issues!

    I’ll mark this thread as resolved now. If you have any further questions, let us know!

    Plugin Support Ryan Ray, a11n

    (@ryanr14)

    Howdy @indoonenews00107media,

    I’d seen you were having the same issue, does the solution from @smartflex also help solve your troubles?

    If not, would you mind creating a new thread here for us to help out with? Thank you!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘No refresh token stored – can not connect to square’ is closed to new replies.