No refresh token stored – can not connect to square
-
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.
-
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.
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: –
Help For this problem.
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,
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!
*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,
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,
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!
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!
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!
- The topic ‘No refresh token stored – can not connect to square’ is closed to new replies.