Cesar R

Yeah I am not sure either. This happened one before and we had to update all the variations manually.

I have deactivated the “Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.20”

I don’t see any immediate change.

Yes let me check.

The products are created in WC first and then synced with square.

Just to confirm this happened to about all the products with variations.

The only plugin that I can think can make this kind of overwrite is the “WooCommerce Square” plugin

Yeah I tried, and nothing happened.

I don’t have any fatal error logs.

Not sure what has been updated recently, I think it was after one of the WC updates earlier last week.

Switching the theme does not do anything as the variation were update at the product level.

Thank you,

Here is the system report

______________________________________

WordPress Environment

WordPress address (URL): https://rockosonlinestore.com
Site address (URL): https://rockosonlinestore.com
WC Version: 7.6.0
REST API Version: ?</img> 7.6.0
WC Blocks Version: ?</img> 9.8.4
Action Scheduler Version: ?</img> 3.5.4
Log Directory Writable: ?</img>
WP Version: 6.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_US
External object cache: –

Server Environment

Server Info: LiteSpeed
PHP Version: 7.4.33
PHP Post Max Size: 512 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.87.0
OpenSSL/1.1.1p

SUHOSIN Installed: –
MySQL Version: 8.0.33
Max Upload Size: 512 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.6.0
WC Database Prefix: wpcu_
Total Database Size: 44.11MB
Database Data Size: 34.50MB
Database Index Size: 9.61MB
wpcu_woocommerce_sessions: Data: 0.76MB + Index: 0.02MB + Engine MyISAM
wpcu_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpcu_woocommerce_order_itemmeta: Data: 0.19MB + Index: 0.14MB + Engine MyISAM
wpcu_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_actionscheduler_actions: Data: 1.69MB + Index: 1.07MB + Engine MyISAM
wpcu_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_actionscheduler_logs: Data: 1.60MB + Index: 1.18MB + Engine MyISAM
wpcu_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpcu_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_cartflows_ca_cart_abandonment: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wpcu_cartflows_ca_email_history: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_cartflows_ca_email_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_cartflows_ca_email_templates_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_comments: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
wpcu_itsec_bans: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpcu_itsec_dashboard_events: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpcu_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpcu_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpcu_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpcu_itsec_logs: Data: 3.02MB + Index: 0.48MB + Engine InnoDB
wpcu_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_itsec_temp: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpcu_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_loginizer_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_options: Data: 5.34MB + Index: 0.22MB + Engine MyISAM
wpcu_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_postmeta: Data: 14.95MB + Index: 3.53MB + Engine MyISAM
wpcu_posts: Data: 1.62MB + Index: 0.56MB + Engine MyISAM
wpcu_term_relationships: Data: 0.13MB + Index: 0.25MB + Engine MyISAM
wpcu_term_taxonomy: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpcu_termmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpcu_terms: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
wpcu_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpcu_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_usermeta: Data: 0.57MB + Index: 0.38MB + Engine MyISAM
wpcu_users: Data: 0.06MB + Index: 0.04MB + Engine MyISAM
wpcu_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_customer_lookup: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpcu_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_order_product_lookup: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpcu_wc_order_stats: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpcu_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpcu_wc_product_meta_lookup: Data: 0.29MB + Index: 0.29MB + Engine MyISAM
wpcu_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpcu_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_woocommerce_square_customers: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
wpcu_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpcu_yoast_indexable: Data: 3.13MB + Index: 0.50MB + Engine MyISAM
wpcu_yoast_indexable_hierarchy: Data: 0.09MB + Index: 0.20MB + Engine MyISAM
wpcu_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpcu_yoast_primary_term: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpcu_yoast_seo_links: Data: 0.02MB + Index: 0.01MB + Engine MyISAM

Post Type Counts

astra_adv_header: 1
astra-advanced-hook: 1
attachment: 3289
custom_css: 3
customize_changeset: 3
fl-builder-template: 2
nav_menu_item: 16
page: 11
post: 7
product: 791
product_variation: 1203
revision: 88
shop_coupon: 23
shop_order: 193
shop_order_refund: 3
wp_global_styles: 1
wpforms: 1

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (21)

ManageWP - Worker: by GoDaddy – 4.9.17
Astra Pro: by Brainstorm Force – 4.1.4
Beaver Builder Plugin (Standard Version): by The Beaver Builder Team – 2.6.3.3
Ultimate Addons for Beaver Builder: by Brainstorm Force – 1.35.4
iThemes Security: by iThemes – 8.1.6
Bulk Edit Products, Prices & Attributes for Woocommerce: by ELEXtensions – 1.1.0
ThumbPress - Stop Generating Unnecessary Thumbnails: by Codexpert
Inc – 4.0.4

Loginizer: by Softaculous – 1.7.8
Menu Image: by Freshlight Lab – 3.0.8
Barcode Label Printing for WooCommerce and others plugins - (basic): by UkrSolution – 3.4.5
PW WooCommerce Gift Cards: by Pimwick
LLC – 1.238

Simple Image Sizes: by Rahe – 3.2.2
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.24
Orders Tracking for WooCommerce: by VillaTheme – 1.2.3
Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.20
WooCommerce PayPal Payments: by WooCommerce – 2.0.4
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.5.2
WooCommerce Shipping & Tax: by WooCommerce – 2.2.4
WooCommerce Square: by WooCommerce – 3.7.1
WooCommerce: by Automattic – 7.6.0
Yoast SEO: by Team Yoast – 20.5

Inactive Plugins (2)

LiteSpeed Cache: by LiteSpeed Technologies – 5.4
Sassy Social Share: by Team Heateor – 3.3.51

Must Use Plugins (1)

ManageWP - Worker Loader: by GoDaddy – 1.0.0

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)
pw gift card (pw-gift-card)
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: ?</img>
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #33 - /shop/
Cart: #35 - /cart-2/
Checkout: #36 - /checkout-2/
My account: #37 - /my-account-2/
Terms and conditions: ?</img> Page visibility should be public

Theme

Name: Astra Child
Version: 1.0.0
Author URL: https://crtechsign.com/
Child Theme: ?</img>
Parent Theme Name: Astra
Parent Theme Version: 4.1.3
Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
WooCommerce Support: ?</img>

Templates

Overrides: –

WooCommerce PayPal Payments

Onboarded: ?</img>
Shop country code: US
WooCommerce currency supported: ?</img>
Advanced Card Processing available in country: ?</img>
Pay Later messaging available in country: ?</img>
Webhook status: ?</img>
Vault enabled: ?</img>
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Tracking enabled: –

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
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: block-editor-feature-enabled
minified-js
new-product-management-experience
product-variation-management
settings

Daily Cron: ?</img> Next scheduled: 2023-04-24 23:02:45 -05:00
Options: ?</img>
Notes: 36
Onboarding: completed

Action Scheduler

Complete: 9,114
Oldest: 2023-03-24 16:13:55 +0000
Newest: 2023-04-24 15:41:45 +0000

Pending: 5
Oldest: 2023-04-24 15:45:40 +0000
Newest: 2023-04-30 21:57:40 +0000

Status report information

Generated at: 2023-04-24 10:44:49 -05:00
`

After some research it seems the SQL database is not playing nicely with the PHP version. but I haven’t find a way to correct that part.

Yes, that was one of the first things I did, according to them, they do not see any issues on their end.

Thank you anyways.

After checking with Query Monitor I see this:

caller: WP_Term_Query->get_terms()
Componet:Component
Error Message:Lost connection to MySQL server during query
Error Code:2013
Query:
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
WHERE tt.taxonomy IN (‘post_tag’)
AND tt.count > 0
ORDER BY t.name ASC

Yeah I still get the error with the plugins deactivated. The error seems to be generated at them moment when I click the create new post button and when I click the publish button.

[17-Aug-2018 19:04:28 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (wp_posts.post_author = 1) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC LIMIT 2030, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[17-Aug-2018 19:06:43 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[17-Aug-2018 19:06:58 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

Thru your File manager on cPanel.

I am interested in something like this as well.

Thank you, we are still working on it, how ever I was able to resolve the issue using a static page as my home page.