Website loading / Crashing on certain products.

I have found a few of the more complex products are very slow to load in.

https://staging6.glassfurniture.co.uk/glassfurniture/glass-dining-table/metal-glass-dining-tables/slim-extending-dining-table/

In particular this product above.
Do you know of any reason it might take along time to load.

Also if you search Slim – the website sometimes crashes.

https://staging6.glassfurniture.co.uk/product-category/glass-dining-table/

(PHP is set to 2G temporarily which is not sustainable or wise to do on a WP website according to my hosts)

The reason I am asking for help is this doesn’t happen on my older theme website.

https://glassfurniture.co.uk/?s=slim&post_type=product

Hope ok to ask.

Many thanks,

Hi peter-9793,

Thanks for reaching to us.

1. Our theme is optimized for speed and should not significantly slow down your website. However, it’s possible that your website’s performance is affected by the content you have added. For instance, the use of too many plugins, large unoptimized images, or other resources can slow down your website.

We recommend that you remove any unnecessary plugins and install a JS & CSS optimization plugin such as WP Rocket. Our guide on how to optimize your website using our themes can be found here: https://xtemos.com/wordpress-performance-optimization-the-ultimate-guide-in-2021/.

2. I made a test of searching and it looked fine https://prnt.sc/vVDEyndofdJX https://prnt.sc/8_kv0xGcixX-

Regards,

Hi,

Thank you fro coming back to me.
I saw the screen shot you sent through. Can you tell me if it loads in quickly once you hit return on the search rather than just the preview screen?
This is where is runs slow for me.

If you think it might be a plug in is there a way I can see which one is conflicting?

Many thanks,

Hi peter-9793,

Sorry, but your reply is a bit unclear to me. Please describe in more details, this will allow me to thoroughly investigate and address your concerns in a more efficient.

Regards,

Hi Just to follow up on this. I have a product which has approx 1500 variations. It crashes the product grid page. – please see screen shot.
I have tested why switching the theme off and it work perfectly with default theme.
The product is Slim Glass and Metal Dining Table. (switch the product off at the page loads fine)
Website server is set to some really high values as well so not a server issue

this is the screen shot

(Hi Just to follow up on this. I have a product which has approx 1500 variations. It crashes the product grid page. – please see screen shot.
I have tested why switching the theme off and it work perfectly with default theme.
The product is Slim Glass and Metal Dining Table. (switch the product off at the page loads fine)
Website server is set to some really high values as well so not a server issue)

screen shot

Attachments:

You must be logged in to view attached files.

Just a querry but is the theme loading in all the variations into the product grid. which is causing an error as it can’t cope? i’ve tried to switch this element off in the theme settings but wondering if the theme is just hiding the variants rather than removing from the page load? The actual product pages work.

https://staging6.glassfurniture.co.uk/glassfurniture/glass-dining-table/metal-glass-dining-tables/slim-rectangular-glass-dining-table/

Hi peter-9793,

This issue is non-related themes. You should deactivate all plugins (except Required Plugins) and then reactivate them one by one. This makes it very easy to isolate the plugin causing problems.

Regards,

Hi, I have disabled all plugins apart from the ones your theme requires to run. Problem is still here.

Does the shop category page try to load in all the variation buttons for each product?

I think this might be the issue as this product in particular has alot of variants (1506).

When I switch the theme over to a standard WordPress theme it all works fine. Tested with Twenty Twenty-Four.

Please can you take another look at let me know what you think the issue is? I can only make the problem go away when the theme is disabled?

I have left the site as it is so you can take a look.

https://staging6.glassfurniture.co.uk/product-category/glass-dining-table/page/2/

Hi peter-9793,

Could you please duplicate this product and add just few variations to see if it resolved?

Regards,

Hi,

I have now created a product duplication with less variations.
If you follow this link – https://staging6.glassfurniture.co.uk/product-category/glass-dining-table/
the page loads with it on and quickly.
If you follow this link – https://staging6.glassfurniture.co.uk/product-category/glass-dining-table/page/2/
it has the original on which still throws up an error on the product archives pages.

The actual product pages for both are working fine.
The original loads in well here – https://staging6.glassfurniture.co.uk/glassfurniture/glass-dining-table/metal-glass-dining-tables/slim-rectangular-glass-dining-table/

As mentioned it looks to me like the ‘quick order features’ on the product archive pages are causing the issue as the theme or associated plugin is trying to load in all variations of all products on the page? I have tried to disable this feature through the theme settings but not sure if the theme just hides the feature or removes it from the page totally?

Thanks for your help so far.

Regards, Peter

Attachments:

You must be logged in to view attached files.

Hi peter-9793,

I passed to our developer and this problem is on the server side, please contact the server support team so that they can check this problem from their side. I also found how to solve this problem https://stackoverflow.com/questions/63301495/pdoexception-packets-out-of-order-expected-0-received-1-packet-size-23

Regards,

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

Hi peter-9793,

Thanks for sharing details.

This issue related to the long long variations, which caused server timeout. WoodMart does not control it. I kindly recommend you to read this article for better understanding https://kinsta.com/knowledgebase/mysql-server-has-gone-away/ and conduct a check by activating the default WordPress Theme, such as Storefront or Twenty Twenty-Three (Appearance > Themes). This is to ascertain whether the issue you are experiencing is due to our theme or not.

Regards,

I’ve already done this and it works fine on WordPress standard themes.

Sorry just to be clear in my response. The issue appears to be with your theme only.

Hi peter-9793,

Please double check https://prnt.sc/hOY6ITxWUags

In case you want to understand how to fix it,

As we discussed above and according to hosting provider’s replies, the issue related to query of database when it tried to access or display variations. I navigated to Theme Settings > Shop > Variable products > then switched to Parent product meta option and selected Variations products meta option again https://prnt.sc/kXBFV0fnVpQt

Regards,

[Author]

Posts