douglashaugen

I have changed the theme from Avada to WordPress Twenty Twenty-Three. I have deactivated all plugins except WooCommerce and WooCommerce Square. I have purged the Cloudflare cache. I have increased the max_execution_time to 2500 seconds. Still, I’m getting failures on wc_square_job_runner.

1. 
   2023-11-06 15:12:23 +0000
   action created
2. 2023-11-06 15:12:48 +0000
   action started via Async Request
3. 2023-11-06 15:12:48 +0000
   action failed via Async Request: Call to a member function get_meta() on bool

I have also reverted back to PHP 7.4 and back to 8.0. The Update section of Square plugins settings still says Syncing now, but shows nothing has synced since October 30, even though I continue to add products since then.

WooCommerce is the system of record in sync settings.

Should I disconnect WooCommerce from Square, and then connect again? Is there risk of this causing duplicates in either WooCommerce or Square?

Yes, it’s only on new products that I can tell. I published several products on October 30, which synced fine. Then, I deleted one new product in WooCommerce that I realized was a duplicate, and since then, no other new products are making it to Square.

The Square update section has indicated that it’s syncing for days, and you can see in this screenshot that it hasn’t actually upstreamed anything since October 30. https://app.screencast.com/5zEFRfyfkHmfz

There are no recent fatal error logs.

wc_square_background_sync_cron continues to say “Complete,” but wc_square_job_runner continues to say “Failed” as you can see in this screenshot: https://app.screencast.com/xdF9PtAwtv9oL

I’ve gone through the troubleshooting guide already, and checked on those possible solutions, but they don’t apply to me.

Thank you so much for any insight you could provide

` WordPress Environment

WordPress address (URL): https://silversagelifestyle.com
Site address (URL): https://silversagelifestyle.com
WC Version: 8.2.1
REST API Version: ? 8.2.1
WC Blocks Version: ? 11.1.2
Action Scheduler Version: ? 3.6.3
Log Directory Writable: ?
WP Version: 6.3.2
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: 8.0.30
PHP Post Max Size: 256 MB
PHP Time Limit: 1200
PHP Max Input Vars: 2000
cURL Version: 7.87.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 10.5.20-MariaDB-cll-lve-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.2.1
WC Database Prefix: wp_
Total Database Size: 257.94MB
Database Data Size: 194.78MB
Database Index Size: 63.16MB
wp_woocommerce_sessions: Data: 10.84MB + Index: 0.30MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + 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.17MB + Index: 0.08MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 1.82MB + Index: 0.81MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 12.68MB + Index: 3.73MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.36MB + Index: 0.66MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 13.71MB + Index: 9.33MB + Engine MyISAM
wp_admin_columns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_cache: Data: 0.66MB + Index: 0.14MB + Engine MyISAM
wp_aioseo_notifications: Data: 0.08MB + Index: 0.01MB + Engine MyISAM
wp_aioseo_posts: Data: 9.43MB + Index: 0.18MB + Engine MyISAM
wp_awb_critical_css: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cart_notices: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_comments: Data: 1.52MB + Index: 0.58MB + Engine InnoDB
wp_cp_feeds: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ewwwio_images: Data: 11.72MB + Index: 3.75MB + Engine MyISAM
wp_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_form_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_form_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_form_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.32MB + Index: 0.02MB + Engine MyISAM
wp_layerslider: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_mailchimp_jobs: Data: 0.24MB + Index: 0.01MB + Engine MyISAM
wp_mc4wp_log: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_mclean_refs: Data: 0.45MB + Index: 0.13MB + Engine MyISAM
wp_mclean_scan: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_optins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_optin_meta: Data: 0.11MB + Index: 0.02MB + Engine MyISAM
wp_options: Data: 10.50MB + Index: 1.56MB + Engine InnoDB
wp_popover_ip_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_postmeta: Data: 63.59MB + Index: 21.06MB + Engine InnoDB
wp_posts: Data: 7.52MB + Index: 2.61MB + Engine InnoDB
wp_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_feeds: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_feed_caches: Data: 0.12MB + Index: 0.01MB + Engine MyISAM
wp_sbi_instagram_feeds_posts: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_sbi_instagram_feed_locator: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_instagram_posts: Data: 0.72MB + Index: 0.00MB + Engine MyISAM
wp_sbi_sources: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.28MB + Index: 0.13MB + Engine MyISAM
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 0.36MB + Engine InnoDB
wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_tinvwl_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_tinvwl_lists: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_tm_taskmeta: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 19.55MB + Index: 13.03MB + Engine InnoDB
wp_users: Data: 2.52MB + Index: 0.91MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.27MB + Index: 0.30MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_addresses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_operational_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.15MB + Index: 0.13MB + Engine MyISAM
wp_wc_order_stats: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.42MB + Index: 0.50MB + Engine MyISAM
wp_wc_rate_limits: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + 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.03MB + Index: 0.02MB + Engine MyISAM
wp_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfConfig: Data: 2.76MB + Index: 0.01MB + Engine MyISAM
wp_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfFileMods: Data: 9.36MB + Index: 1.11MB + Engine MyISAM
wp_wfHits: Data: 0.93MB + Index: 0.11MB + Engine MyISAM
wp_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfIssues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wfKnownFileList: Data: 6.80MB + Index: 0.34MB + Engine MyISAM
wp_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfLogins: Data: 0.37MB + Index: 0.07MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNotifications: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
wp_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfSecurityEvents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfStatus: Data: 0.22MB + Index: 0.09MB + Engine MyISAM
wp_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfWafFailures: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_square_customers: Data: 0.06MB + Index: 0.06MB + Engine MyISAM
wp_wpmailsmtp_debug_events: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmcleaner: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_yoast_indexable: Data: 1.89MB + Index: 0.31MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.17MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.15MB + Index: 0.03MB + Engine MyISAM Post Type Counts

amn_smtp: 1
attachment: 4443
avada_portfolio: 11
fusion_element: 1
inc_popup: 2
mc4wp-form: 3
nav_menu_item: 44
oembed_cache: 1
page: 25
post: 9
product: 2322
product_variation: 3490
revision: 174
shop_bogof_rule: 2
shop_coupon: 18
shop_order: 712
shop_order_refund: 111
slide: 9
wpcf7_contact_form: 1 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (39)

Afterpay Gateway for WooCommerce: by Afterpay – 3.7.0
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3
Cloudflare: by Cloudflare
Inc. – 4.12.2

Code Snippets: by Code Snippets Pro – 3.5.0
Connects - Mailchimp Addon: by Brainstorm Force – 2.2.4
Contact Form 7: by Takayuki Miyoshi – 5.8.2
Convert Plus: by Brainstorm Force – 3.5.24
Enable Media Replace: by ShortPixel – 4.1.4
Excerpt Tools: by Marcus Downing and Zack Kakia – 0.7
Facebook for WooCommerce: by Facebook – 3.1.2
Featured Images in RSS for Mailchimp & More (Premium): by 5 Star Plugins – 1.6.2
Avada Builder: by ThemeFusion – 3.11.2
Avada Core: by ThemeFusion – 5.11.2
Avada Custom Branding: by ThemeFusion – 1.2
reCaptcha by BestWebSoft: by BestWebSoft – 1.73
Site Kit by Google: by Google – 1.111.1
Instagram Feed Pro Business: by Smash Balloon – 6.3.3
Jetpack: by Automattic – 12.7.1
Mailchimp for WooCommerce: by Mailchimp – 3.2
MC4WP: Mailchimp for WordPress: by ibericode – 4.9.9
MC4WP: Mailchimp for WordPress Premium: by ibericode – 4.9.5
Media File Renamer: Rename Files (Manual, Auto & AI): by Jordy Meow – 5.7.1
One User Avatar: by One Designs – 2.4.0
Safe SVG: by 10up – 2.2.1
Simple Image Sizes: by Rahe – 3.2.2
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.23.10.1

WooCommerce Free Shipping Per Product: by WPRuby – 1.2.4
WooCommerce Cart Notices: by SkyVerge – 1.14.0 (update to version 1.15.0 is available)
WooCommerce Google Analytics Integration: by WooCommerce – 1.8.8
WP WooCommerce Mailchimp: by Saint Systems – 2.4.12
Product SKU Generator for WooCommerce: by SkyVerge – 2.5.0
WooCommerce Shipping & Tax: by WooCommerce – 2.3.7
WooCommerce Square: by WooCommerce – 4.3.0
WooCommerce: by Automattic – 8.2.1
Wordfence Security: by Wordfence – 7.10.5
Yoast SEO: by Team Yoast – 21.5
WP Mail SMTP: by WP Mail SMTP – 3.9.0
WP-Optimize Premium - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.21

Yoast SEO: Local: by Team Yoast and Arjan Snaterse – 15.0 Inactive Plugins (4)

All in One SEO: by All in One SEO Team – 4.4.9.2
Health Check & Troubleshooting: by The www.remarpro.com community – 1.7.0
WooCommerce Buy One Get One Free: by Oscar Gare – 3.7.0 (update to version 4.1.4 is available)
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5 Dropin Plugins (1)

advanced-cache.php: advanced-cache.php Must Use Plugins (1)

Health Check Troubleshooting Mode: by – 1.9.1 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: ?
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: #3678 - /whats-new/
Cart: #1292 - /cart/
Checkout: #1293 - /checkout/
My account: #1294 - /my-account/
Terms and conditions: #1321 - /terms-conditions/ Theme

Name: Avada Child
Version: 1.0.0
Author URL: https://theme-fusion.com
Child Theme: ?
Parent Theme Name: Avada
Parent Theme Version: 7.11.2
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/checkout/thankyou.php
Avada/woocommerce/loop/loop-start.php
Avada/woocommerce/single-product/add-to-cart/variable.php
Avada-Child-Theme/woocommerce/single-product/meta.php
Avada-Child-Theme/woocommerce/single-product/price.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: Off 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
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
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-11-01 13:14:19 -07:00
Options: ?
Notes: 195
Onboarding: completed Action Scheduler

Complete: 9,834
Oldest: 2023-09-30 14:26:46 -0700
Newest: 2023-10-31 13:18:27 -0700

Failed: 29,324
Oldest: 2022-08-16 19:22:49 -0700
Newest: 2023-10-31 14:21:17 -0700

Pending: 9
Oldest: 2023-10-31 14:26:17 -0700
Newest: 2023-11-07 12:18:27 -0800 Status report information

Generated at: 2023-10-31 14:24:35 -07:00
`

This just happened to me as well. The IP address it gives (68.65.122.134) is not my IP address. The email to unlock the site doesn’t work. It opens a page that says:

{“error”:”Bad Request”,”message”:”Invalid input.”}

This is for https://integraphy.co