Sync taking forever and multiple errors
-
It seems for the past few weeks if I run a manual sync it is taking 2 to 4 hours to complete… if it completes at all. 8 out of 10 times it fails.
When I look into the square logs I keep getting:
Product sync failed. API response data is missingI am also getting this in the fatal error logs:
2021-07-20T00:22:34+00:00 CRITICAL Uncaught Error: Call to a member function getObjects() on null in /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/includes/Sync/Interval_Polling.php:85
Stack trace:
#0 /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/includes/Sync/Stepped_Job.php(114): WooCommerce\Square\Sync\Interval_Polling->update_category_data()
#1 /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/includes/Sync/Stepped_Job.php(55): WooCommerce\Square\Sync\Stepped_Job->do_next_step()
#2 /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/includes/Handlers/Background_Job.php(172): WooCommerce\Square\Sync\Stepped_Job->run()
#3 /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/includes/Handlers/Background_Job.php(123): WooCommerce\Square\Handlers\Background_Job->process_job(Object(WooCommerce\Square\Sync\Interval_Polling))
#4 /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/vendor/skyverge/wc-plugin-framework/woocommerce/utilities/class-sv-wp-backgroun in /home/phodlnmy/public_html/wp-content/plugins/woocommerce-square/includes/Sync/Interval_Polling.php on line 85I have shut off all plugins and used the storefront theme and I am still getting the same errors with just this plugin turned on.
I also noticed that some times during the manual sync my business location looses connection as well and then I have to disconnect from square and reconnect for me to select the location again and save it.
-
Hey there @nierc001,
Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Here is the system status report.
### WordPress Environment ### WordPress address (URL): https://www.a1swag.com Site address (URL): https://www.a1swag.com WC Version: 5.5.1 REST API Version: ✔ 5.5.1 WC Blocks Version: ✔ 5.3.2 Action Scheduler Version: ✔ 3.2.1 WC Admin Version: ✔ 2.4.1 Log Directory Writable: ✔ WP Version: 5.8 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: ✔ ### Server Environment ### Server Info: Apache PHP Version: 7.4.21 PHP Post Max Size: 24 MB PHP Time Limit: 1200 PHP Max Input Vars: 3000 cURL Version: 7.77.0 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 5.7.35 Max Upload Size: 24 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.0.0 WC Database Prefix: _BLY_ Total Database Size: 1621.86MB Database Data Size: 1504.10MB Database Index Size: 117.76MB _BLY_woocommerce_sessions: Data: 0.30MB + Index: 0.01MB + Engine MyISAM _BLY_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_order_items: Data: 2.46MB + Index: 1.13MB + Engine MyISAM _BLY_woocommerce_order_itemmeta: Data: 13.82MB + Index: 10.43MB + Engine MyISAM _BLY_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_actionscheduler_actions: Data: 5.17MB + Index: 2.33MB + Engine MyISAM _BLY_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_actionscheduler_logs: Data: 3.82MB + Index: 2.74MB + Engine MyISAM _BLY_categorymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_comments: Data: 6.66MB + Index: 3.38MB + Engine MyISAM _BLY_dokan_announcement: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_dokan_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB _BLY_dokan_refund: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_dokan_vendor_balance: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_dokan_withdraw: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_ebay_accounts: Data: 0.04MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_auctions: Data: 73.11MB + Index: 1.22MB + Engine MyISAM _BLY_ebay_categories: Data: 1.83MB + Index: 1.08MB + Engine MyISAM _BLY_ebay_jobs: Data: 0.62MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_log: Data: 715.93MB + Index: 2.83MB + Engine MyISAM _BLY_ebay_messages: Data: 4.16MB + Index: 0.04MB + Engine MyISAM _BLY_ebay_orders: Data: 173.77MB + Index: 0.59MB + Engine MyISAM _BLY_ebay_payment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_profiles: Data: 0.16MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_shipping: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_sites: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_stocks_log: Data: 21.59MB + Index: 0.13MB + Engine MyISAM _BLY_ebay_store_categories: Data: 0.01MB + Index: 0.01MB + Engine MyISAM _BLY_ebay_transactions: Data: 225.01MB + Index: 1.29MB + Engine MyISAM _BLY_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_member_catmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_oliver_pos_bridge_sync_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_options: Data: 49.65MB + Index: 3.90MB + Engine MyISAM _BLY_pmxe_exports: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM _BLY_pmxe_posts: Data: 0.03MB + Index: 0.01MB + Engine MyISAM _BLY_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_portfolio_catmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_postmeta: Data: 116.18MB + Index: 60.04MB + Engine MyISAM _BLY_posts: Data: 23.43MB + Index: 4.32MB + Engine MyISAM _BLY_product_catmeta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM _BLY_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_termmeta: Data: 0.62MB + Index: 0.44MB + Engine MyISAM _BLY_terms: Data: 0.38MB + Index: 0.63MB + Engine MyISAM _BLY_term_relationships: Data: 1.63MB + Index: 3.67MB + Engine MyISAM _BLY_term_taxonomy: Data: 0.35MB + Index: 0.34MB + Engine MyISAM _BLY_usermeta: Data: 0.28MB + Index: 0.11MB + Engine MyISAM _BLY_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM _BLY_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM _BLY_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_wc_category_lookup: Data: 0.07MB + Index: 0.11MB + Engine MyISAM _BLY_wc_customer_lookup: Data: 1.07MB + Index: 1.04MB + Engine MyISAM _BLY_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wc_order_product_lookup: Data: 1.22MB + Index: 1.02MB + Engine MyISAM _BLY_wc_order_stats: Data: 0.87MB + Index: 0.58MB + Engine MyISAM _BLY_wc_order_tax_lookup: Data: 0.29MB + Index: 0.40MB + Engine MyISAM _BLY_wc_product_meta_lookup: Data: 0.57MB + Index: 0.53MB + Engine MyISAM _BLY_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfconfig: Data: 0.45MB + Index: 0.02MB + Engine MyISAM _BLY_wfcrawlers: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wffilemods: Data: 22.60MB + Index: 4.29MB + Engine MyISAM _BLY_wfhits: Data: 0.07MB + Index: 0.01MB + Engine MyISAM _BLY_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfissues: Data: 0.23MB + Index: 0.04MB + Engine MyISAM _BLY_wfknownfilelist: Data: 12.50MB + Index: 1.33MB + Engine MyISAM _BLY_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wflogins: Data: 0.09MB + Index: 0.02MB + Engine MyISAM _BLY_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _BLY_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_wfpendingissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfstatus: Data: 0.08MB + Index: 0.03MB + Engine MyISAM _BLY_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wmfo_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_square_customers: Data: 0.02MB + Index: 0.04MB + Engine MyISAM _BLY_woo_square_integration_deleted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_woo_square_integration_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_wotv_woo_track_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wpforms_tasks_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM _BLY_wsal_metadata: Data: 0.01MB + Index: 0.02MB + Engine MyISAM _BLY_wsal_occurrences: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wsal_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_yoast_indexable: Data: 19.79MB + Index: 4.10MB + Engine MyISAM _BLY_yoast_indexable_hierarchy: Data: 0.58MB + Index: 1.92MB + Engine MyISAM _BLY_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_yoast_primary_term: Data: 0.40MB + Index: 0.45MB + Engine MyISAM _BLY_yoast_seo_links: Data: 1.22MB + Index: 0.69MB + Engine MyISAM _BLY_yoast_seo_meta: Data: 0.29MB + Index: 0.25MB + Engine MyISAM ### Post Type Counts ### attachment: 9314 custom_css: 1 customize_changeset: 7 faq: 5 nav_menu_item: 72 oembed_cache: 22 page: 29 pickup_location: 1 porto_builder: 20 post: 2 product: 7785 revision: 2170 shop_order: 15268 shop_order_refund: 225 wpcf7_contact_form: 6 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (29) ### Akismet Anti-Spam: by Automattic – 4.1.10 Code Snippets: by Code Snippets Pro – 2.14.1 Contact Form 7: by Takayuki Miyoshi – 5.4.2 Dynamic Featured Image: by Ankit Pokhrel – 3.7.0 Flexible Shipping PRO: by WP Desk – 2.5.1 Flexible Shipping: by WP Desk – 4.7.0 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.18.0 Jetpack: by Automattic – 9.9.1 WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0 Maintenance: by WebFactory Ltd – 4.03 Porto Theme - Functionality: by P-Themes – 2.1.3 Slider Revolution: by ThemePunch – 6.4.11 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.59 W3 Total Cache: by BoldGrid – 2.1.5 Webcraftic Updates manager: by Webcraftic – 1.1.2 Woo Coming Soon: by Fahad Mahmood – 1.3.4 Woo Manage Fraud Orders: by Prasidhda Malla – 2.2.1 Orders Tracking for WooCommerce: by VillaTheme – 1.1.8.5 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.2 WooCommerce Shipping & Tax: by WooCommerce – 1.25.17 WooCommerce Square: by WooCommerce – 2.1.6 WooCommerce: by Automattic – 5.5.1 Yoast SEO: by Team Yoast – 16.7 WP Content Copy Protection & No Right Click: by wp-buy – 3.4.1 WP Crontrol: by John Blackbourn & crontributors – 1.10.0 WP Last Modified Info: by Sayan Datta – 1.7.7 WP-Lister Pro for eBay: by WP Lab – 2.9.7 WP Rollback: by Impress.org – 1.7.1 YITH Pre-Order for WooCommerce: by YITH – 1.3.5 ### Inactive Plugins (7) ### Bluehost: by Bluehost – 2.2.3 Dokan: by weDevs – 3.2.8 Product Sales Report for WooCommerce: by Aspen Grove Studios – 1.5.1 WooCommerce Admin: by WooCommerce – 2.4.4 Woo Stickers by Webline: by Weblineindia – 1.1.5 WP File Manager: by mndpsingh287 – 7.1.1 WPForms Lite: by WPForms – 1.6.8 ### Dropin Plugins (4) ### advanced-cache.php: advanced-cache.php db-error.php: db-error.php maintenance.php: maintenance.php object-cache.php: object-cache.php ### Must Use Plugins (1) ### SSO: by Garth Mortensen Mike Hansen – 0.3 ### 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: #9 - /shop/ Cart: #10 - /cart/ Checkout: #11 - /checkout/ My account: #12 - /my-account/ Terms and conditions: #2777 - /terms-of-use/ ### Theme ### Name: Porto Child Version: 1.1 Author URL: https://www.portotheme.com/ Child Theme: ✔ Parent Theme Name: Porto Parent Theme Version: 6.1.3 Parent Theme Author URL: http://www.portotheme.com/ WooCommerce Support: ✔ ### Templates ### Overrides: porto/woocommerce/archive-product.php porto/woocommerce/cart/cart-empty.php porto/woocommerce/cart/cart-shipping.php porto/woocommerce/cart/cart-totals.php porto/woocommerce/cart/cart.php porto/woocommerce/cart/cross-sells.php porto/woocommerce/cart/mini-cart.php porto/woocommerce/cart/proceed-to-checkout-button.php porto/woocommerce/cart/shipping-calculator.php porto/woocommerce/checkout/form-billing.php porto/woocommerce/checkout/form-checkout.php porto/woocommerce/checkout/form-coupon.php porto/woocommerce/checkout/form-login.php porto/woocommerce/checkout/form-pay.php porto/woocommerce/checkout/form-shipping.php porto/woocommerce/checkout/payment-method.php porto/woocommerce/checkout/payment.php porto/woocommerce/checkout/review-order.php porto/woocommerce/checkout/thankyou.php porto/woocommerce/content-product-cat.php porto/woocommerce/content-product.php porto/woocommerce/content-single-product.php porto/woocommerce/content-widget-product.php porto/woocommerce/global/form-login.php porto/woocommerce/global/quantity-input.php porto/woocommerce/global/wrapper-start.php porto/woocommerce/loop/add-to-cart.php porto/woocommerce/loop/loop-end.php porto/woocommerce/loop/loop-start.php porto/woocommerce/loop/no-products-found.php porto/woocommerce/loop/orderby.php porto/woocommerce/loop/pagination.php porto/woocommerce/loop/rating.php porto/woocommerce/loop/sale-flash.php porto/woocommerce/myaccount/dashboard.php porto/woocommerce/myaccount/downloads.php porto/woocommerce/myaccount/form-add-payment-method.php porto/woocommerce/myaccount/form-edit-account.php porto/woocommerce/myaccount/form-edit-address.php porto/woocommerce/myaccount/form-login.php porto/woocommerce/myaccount/form-lost-password.php porto/woocommerce/myaccount/form-reset-password.php porto/woocommerce/myaccount/lost-password-confirmation.php porto/woocommerce/myaccount/my-account.php porto/woocommerce/myaccount/my-address.php porto/woocommerce/myaccount/my-downloads.php porto/woocommerce/myaccount/my-orders.php porto/woocommerce/myaccount/navigation.php porto/woocommerce/myaccount/orders.php porto/woocommerce/myaccount/payment-methods.php porto/woocommerce/myaccount/view-order.php porto/woocommerce/order/form-tracking.php porto/woocommerce/order/order-details-customer.php porto/woocommerce/order/order-details.php porto/woocommerce/order/order-downloads.php porto/woocommerce/order/tracking.php porto/woocommerce/single-product/add-to-cart/simple.php porto/woocommerce/single-product/add-to-cart/variable.php porto/woocommerce/single-product/meta.php porto/woocommerce/single-product/product-attributes.php porto/woocommerce/single-product/product-image.php porto/woocommerce/single-product/product-thumbnails.php porto/woocommerce/single-product/rating.php porto/woocommerce/single-product/related.php porto/woocommerce/single-product/review-meta.php porto/woocommerce/single-product/review-rating.php porto/woocommerce/single-product/review.php porto/woocommerce/single-product/sale-flash.php porto/woocommerce/single-product/short-description.php porto/woocommerce/single-product/tabs/tabs.php porto/woocommerce/single-product/title.php porto/woocommerce/single-product/up-sells.php porto/woocommerce/single-product-reviews.php ### Square ### Environment: Production Tokenization Enabled: – Debug Mode: Off ### Action Scheduler ### Complete: 21,638 Oldest: 2021-07-16 14:10:08 +0000 Newest: 2021-07-21 18:10:09 +0000 Pending: 10 Oldest: 2021-07-21 19:01:45 +0000 Newest: 2021-07-27 03:31:41 +0000 ### Status report information ### Generated at: 2021-07-21 13:21:12 -05:00
Hi @nierc001,
Thanks for the status report. From report, it looks like you are running
WooCommerce Square: by WooCommerce – 2.1.6
.
Please upgrade to the latest version(2.5.3) of the plugin. Ideally, upgrading to the latest version should fix the issues. As always please update after taking backups of your site.
Do keep us posted on how this works out for you.
Nope still the same thing.
Hi @nierc001
Thanks for trying. Can you please share the System Status Report again here, since the plugin is now updated?
Steps to do that, once again:
You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Please enable debug within the Square Settings page
Link to image: https://docs.woocommerce.com/wp-content/uploads/2016/07/woocommerce-square-settings-1.pngOnce done, try forcing a sync and see if you get any new logs within
**WP Admin → WooCommerce → Status → Logs**If you do, please copy that log here.
Here is the new status report:
### WordPress Environment ### WordPress address (URL): https://www.a1swag.com Site address (URL): https://www.a1swag.com WC Version: 5.5.1 REST API Version: ✔ 5.5.1 WC Blocks Version: ✔ 5.3.2 Action Scheduler Version: ✔ 3.2.1 WC Admin Version: ✔ 2.4.1 Log Directory Writable: ✔ WP Version: 5.8 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: ✔ ### Server Environment ### Server Info: Apache PHP Version: 7.4.21 PHP Post Max Size: 24 MB PHP Time Limit: 1200 PHP Max Input Vars: 3000 cURL Version: 7.78.0 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 5.7.35 Max Upload Size: 24 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.0.0 WC Database Prefix: _BLY_ Total Database Size: 1643.13MB Database Data Size: 1523.03MB Database Index Size: 120.10MB _BLY_woocommerce_sessions: Data: 0.30MB + Index: 0.01MB + Engine MyISAM _BLY_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_order_items: Data: 2.51MB + Index: 1.15MB + Engine MyISAM _BLY_woocommerce_order_itemmeta: Data: 14.06MB + Index: 10.61MB + Engine MyISAM _BLY_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_actionscheduler_actions: Data: 6.01MB + Index: 2.76MB + Engine MyISAM _BLY_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_actionscheduler_logs: Data: 4.34MB + Index: 3.14MB + Engine MyISAM _BLY_admin_columns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_categorymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_comments: Data: 6.76MB + Index: 3.43MB + Engine MyISAM _BLY_dokan_announcement: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_dokan_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB _BLY_dokan_refund: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_dokan_vendor_balance: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_dokan_withdraw: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_ebay_accounts: Data: 0.04MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_auctions: Data: 77.00MB + Index: 1.24MB + Engine MyISAM _BLY_ebay_categories: Data: 1.83MB + Index: 1.08MB + Engine MyISAM _BLY_ebay_jobs: Data: 0.78MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_log: Data: 715.93MB + Index: 2.95MB + Engine MyISAM _BLY_ebay_messages: Data: 4.24MB + Index: 0.04MB + Engine MyISAM _BLY_ebay_orders: Data: 176.35MB + Index: 0.60MB + Engine MyISAM _BLY_ebay_payment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_profiles: Data: 0.16MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_shipping: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_sites: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_ebay_stocks_log: Data: 21.59MB + Index: 0.13MB + Engine MyISAM _BLY_ebay_store_categories: Data: 0.01MB + Index: 0.01MB + Engine MyISAM _BLY_ebay_transactions: Data: 228.27MB + Index: 1.31MB + Engine MyISAM _BLY_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_member_catmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_oliver_pos_bridge_sync_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_options: Data: 54.11MB + Index: 3.90MB + Engine MyISAM _BLY_pmxe_exports: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM _BLY_pmxe_posts: Data: 0.03MB + Index: 0.01MB + Engine MyISAM _BLY_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_portfolio_catmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_postmeta: Data: 118.08MB + Index: 60.86MB + Engine MyISAM _BLY_posts: Data: 23.87MB + Index: 4.39MB + Engine MyISAM _BLY_product_catmeta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM _BLY_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_termmeta: Data: 0.62MB + Index: 0.44MB + Engine MyISAM _BLY_terms: Data: 0.38MB + Index: 0.63MB + Engine MyISAM _BLY_term_relationships: Data: 1.63MB + Index: 3.67MB + Engine MyISAM _BLY_term_taxonomy: Data: 0.35MB + Index: 0.34MB + Engine MyISAM _BLY_usermeta: Data: 0.28MB + Index: 0.12MB + Engine MyISAM _BLY_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM _BLY_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM _BLY_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_wc_category_lookup: Data: 0.07MB + Index: 0.11MB + Engine MyISAM _BLY_wc_customer_lookup: Data: 1.09MB + Index: 1.06MB + Engine MyISAM _BLY_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wc_order_product_lookup: Data: 1.24MB + Index: 1.03MB + Engine MyISAM _BLY_wc_order_stats: Data: 0.88MB + Index: 0.59MB + Engine MyISAM _BLY_wc_order_tax_lookup: Data: 0.30MB + Index: 0.41MB + Engine MyISAM _BLY_wc_product_meta_lookup: Data: 0.59MB + Index: 0.57MB + Engine MyISAM _BLY_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfconfig: Data: 0.45MB + Index: 0.02MB + Engine MyISAM _BLY_wfcrawlers: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wffilemods: Data: 22.60MB + Index: 4.29MB + Engine MyISAM _BLY_wfhits: Data: 0.07MB + Index: 0.01MB + Engine MyISAM _BLY_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfissues: Data: 0.23MB + Index: 0.04MB + Engine MyISAM _BLY_wfknownfilelist: Data: 12.50MB + Index: 1.33MB + Engine MyISAM _BLY_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wflogins: Data: 0.09MB + Index: 0.02MB + Engine MyISAM _BLY_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _BLY_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _BLY_wfpendingissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wfstatus: Data: 0.08MB + Index: 0.03MB + Engine MyISAM _BLY_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wmfo_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_woocommerce_square_customers: Data: 0.02MB + Index: 0.04MB + Engine MyISAM _BLY_woo_square_integration_deleted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_woo_square_integration_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _BLY_wotv_woo_track_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wpforms_tasks_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM _BLY_wsal_metadata: Data: 0.01MB + Index: 0.02MB + Engine MyISAM _BLY_wsal_occurrences: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_wsal_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _BLY_yoast_indexable: Data: 20.07MB + Index: 4.14MB + Engine MyISAM _BLY_yoast_indexable_hierarchy: Data: 0.59MB + Index: 1.95MB + Engine MyISAM _BLY_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _BLY_yoast_primary_term: Data: 0.41MB + Index: 0.46MB + Engine MyISAM _BLY_yoast_seo_links: Data: 1.25MB + Index: 0.71MB + Engine MyISAM _BLY_yoast_seo_meta: Data: 0.29MB + Index: 0.25MB + Engine MyISAM ### Post Type Counts ### attachment: 9510 custom_css: 1 faq: 5 nav_menu_item: 73 oembed_cache: 30 page: 29 pickup_location: 1 porto_builder: 20 post: 1 product: 7916 revision: 2193 shop_order: 15490 shop_order_refund: 227 wpcf7_contact_form: 6 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (29) ### Akismet Anti-Spam: by Automattic – 4.1.10 Code Snippets: by Code Snippets Pro – 2.14.1 Contact Form 7: by Takayuki Miyoshi – 5.4.2 Dynamic Featured Image: by Ankit Pokhrel – 3.7.0 Flexible Shipping PRO: by WP Desk – 2.6.0 Flexible Shipping: by WP Desk – 4.7.1 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.18.0 Jetpack: by Automattic – 9.9.1 WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0 Maintenance: by WebFactory Ltd – 4.03 Porto Theme - Functionality: by P-Themes – 2.1.5 Slider Revolution: by ThemePunch – 6.4.11 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.59 W3 Total Cache: by BoldGrid – 2.1.5 Webcraftic Updates manager: by Webcraftic – 1.1.2 Woo Coming Soon: by Fahad Mahmood – 1.3.4 Woo Manage Fraud Orders: by Prasidhda Malla – 2.3.0 Orders Tracking for WooCommerce: by VillaTheme – 1.1.8.5 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.2 WooCommerce Shipping & Tax: by WooCommerce – 1.25.17 WooCommerce Square: by WooCommerce – 2.5.3 WooCommerce: by Automattic – 5.5.1 (update to version 5.5.2 is available) Yoast SEO: by Team Yoast – 16.8 WP Content Copy Protection & No Right Click: by wp-buy – 3.4.1 WP Crontrol: by John Blackbourn & crontributors – 1.10.0 WP Last Modified Info: by Sayan Datta – 1.7.7 WP-Lister Pro for eBay: by WP Lab – 2.9.7 WP Rollback: by Impress.org – 1.7.1 YITH Pre-Order for WooCommerce: by YITH – 1.3.5 ### Inactive Plugins (7) ### Bluehost: by Bluehost – 2.2.3 Dokan: by weDevs – 3.2.9 Product Sales Report for WooCommerce: by Aspen Grove Studios – 1.5.1 WooCommerce Admin: by WooCommerce – 2.4.4 Woo Stickers by Webline: by Weblineindia – 1.1.5 WP File Manager: by mndpsingh287 – 7.1.2 WPForms Lite: by WPForms – 1.6.8.1 ### Dropin Plugins (4) ### advanced-cache.php: advanced-cache.php db-error.php: db-error.php maintenance.php: maintenance.php object-cache.php: object-cache.php ### Must Use Plugins (1) ### SSO: by Garth Mortensen Mike Hansen – 0.3 ### 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: #9 - /shop/ Cart: #10 - /cart/ Checkout: #11 - /checkout/ My account: #12 - /my-account/ Terms and conditions: #2777 - /terms-of-use/ ### Theme ### Name: Porto Child Version: 1.1 Author URL: https://www.portotheme.com/ Child Theme: ✔ Parent Theme Name: Porto Parent Theme Version: 6.1.3 Parent Theme Author URL: http://www.portotheme.com/ WooCommerce Support: ✔ ### Templates ### Overrides: porto/woocommerce/archive-product.php porto/woocommerce/cart/cart-empty.php porto/woocommerce/cart/cart-shipping.php porto/woocommerce/cart/cart-totals.php porto/woocommerce/cart/cart.php porto/woocommerce/cart/cross-sells.php porto/woocommerce/cart/mini-cart.php porto/woocommerce/cart/proceed-to-checkout-button.php porto/woocommerce/cart/shipping-calculator.php porto/woocommerce/checkout/form-billing.php porto/woocommerce/checkout/form-checkout.php porto/woocommerce/checkout/form-coupon.php porto/woocommerce/checkout/form-login.php porto/woocommerce/checkout/form-pay.php porto/woocommerce/checkout/form-shipping.php porto/woocommerce/checkout/payment-method.php porto/woocommerce/checkout/payment.php porto/woocommerce/checkout/review-order.php porto/woocommerce/checkout/thankyou.php porto/woocommerce/content-product-cat.php porto/woocommerce/content-product.php porto/woocommerce/content-single-product.php porto/woocommerce/content-widget-product.php porto/woocommerce/global/form-login.php porto/woocommerce/global/quantity-input.php porto/woocommerce/global/wrapper-start.php porto/woocommerce/loop/add-to-cart.php porto/woocommerce/loop/loop-end.php porto/woocommerce/loop/loop-start.php porto/woocommerce/loop/no-products-found.php porto/woocommerce/loop/orderby.php porto/woocommerce/loop/pagination.php porto/woocommerce/loop/rating.php porto/woocommerce/loop/sale-flash.php porto/woocommerce/myaccount/dashboard.php porto/woocommerce/myaccount/downloads.php porto/woocommerce/myaccount/form-add-payment-method.php porto/woocommerce/myaccount/form-edit-account.php porto/woocommerce/myaccount/form-edit-address.php porto/woocommerce/myaccount/form-login.php porto/woocommerce/myaccount/form-lost-password.php porto/woocommerce/myaccount/form-reset-password.php porto/woocommerce/myaccount/lost-password-confirmation.php porto/woocommerce/myaccount/my-account.php porto/woocommerce/myaccount/my-address.php porto/woocommerce/myaccount/my-downloads.php porto/woocommerce/myaccount/my-orders.php porto/woocommerce/myaccount/navigation.php porto/woocommerce/myaccount/orders.php porto/woocommerce/myaccount/payment-methods.php porto/woocommerce/myaccount/view-order.php porto/woocommerce/order/form-tracking.php porto/woocommerce/order/order-details-customer.php porto/woocommerce/order/order-details.php porto/woocommerce/order/order-downloads.php porto/woocommerce/order/tracking.php porto/woocommerce/single-product/add-to-cart/simple.php porto/woocommerce/single-product/add-to-cart/variable.php porto/woocommerce/single-product/meta.php porto/woocommerce/single-product/product-attributes.php porto/woocommerce/single-product/product-image.php porto/woocommerce/single-product/product-thumbnails.php porto/woocommerce/single-product/rating.php porto/woocommerce/single-product/related.php porto/woocommerce/single-product/review-meta.php porto/woocommerce/single-product/review-rating.php porto/woocommerce/single-product/review.php porto/woocommerce/single-product/sale-flash.php porto/woocommerce/single-product/short-description.php porto/woocommerce/single-product/tabs/tabs.php porto/woocommerce/single-product/title.php porto/woocommerce/single-product/up-sells.php porto/woocommerce/single-product-reviews.php ### Square ### Environment: Production Tokenization Enabled: – Debug Mode: Off ### Action Scheduler ### Complete: 24,835 Oldest: 2021-07-16 14:10:08 +0000 Newest: 2021-08-03 03:11:22 +0000 Pending: 10 Oldest: 2021-08-03 03:32:03 +0000 Newest: 2021-08-10 03:10:18 +0000 ### Status report information ### Generated at: 2021-08-02 22:11:49 -05:00
After upgrading to the newest version I am still getting this error in the logs:
08-02-2021 @ 22:13:25 – Product sync failed. API response data is missing
08-02-2021 @ 22:13:25 – Completed step cycle: square_sor_sync (0.11s)
08-02-2021 @ 22:13:49 – RequestWhen running the older version I would make it to 100% and it would fail now I can’t make it past 13%
and it keeps loosing my location. So I have to select my location again click save and do it again.
I noticed that there is a mismatch between the WooCommerce Plugin version (5.5.1) and WooCommerce database version in your site (Version 5.0.0) .
You may want to take a full backup of your site files, and database, and then update the database to the latest version from the tool available within
**WP Admin → WooCommerce → Status → Tools**After you do this, I suggest disconnect and reconnect of Square from the payment settings. Try a sync after that, while you keep logging on, and then let me know how that goes.
The database won’t always match the core version of WC. It even says “The database version for WooCommerce. Note that it may not match WooCommerce core version and that is normal.” Even after updating the database through the link provided it still reads 5.0/
Got to 13% again and it failed. Same error in the logs:
Product sync failed. API response data is missing
We’d like to take a deeper look.
Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.
Please include a link to this forum thread, so that we can keep track of what’s already been done.
We will be able to help you further there.
- The topic ‘Sync taking forever and multiple errors’ is closed to new replies.