Reply To: Website loading / Crashing on certain products.

Please see my response from siteground extended paid research.
Can you please advise on how to resolve this theme related issue.

Kind Regards

Peter

———-
Server Supports response

Hello Peter,

Thank you for contacting us!

I was able to replicate the issue and monitored the site’s PHP error logs during this time. The issue is most likely related to a very long query related to the Woodmart swatches cache. Below I’ll paste the beginning of the query:
[29-Mar-2024 20:42:16 UTC] WordPress database error MySQL server has gone away for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_woodmart_swatches_cache_168221’,

The query is most likely related to a caching feature that stores product swatches in the database – inside a transient (temporary) record. However, products with a lot of swatches/variants cause the query to become too large, which results in a database error, followed by the error on the site’s frontend.

I’m afraid I wasn’t able to find a suitable way to disable the theme’s swatch/variant caching mechanism. If you’re still in contact with the theme’s developer, please ask them how this can be achieved. If the solution requires any assistance from our end, please feel free to reach us back.

Best Regards,

Svetoslav Vasev
Senior Technical Support