WooCommerce latest version takes a lot of time in loading a page

Hi @sajiddesigner,

Let’s see if there is an error on the WooCommerce Logs. Kindly provide us the following:

• 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.
• Error log: share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Thanks!

Hello @rainfallnixfig
I can’t access system status because as soon as I enable WooCommerce, entire sites stops working. No page is loading. Both frontend and wp dashboard keeps loading if WooCommerce is enabled. I have to disable WooCommerce by changing directory name using cpanel or FTP and changing directory name from WooCommerce to something else, site starts working fine.

Hi, @sajiddesigner

Thank you for the additional information. I hope we can help point you in the right direction here.

For the core WooCommerce software to run on your site, certain server requirements must be met. Can you please go over the following resources and make sure that your site is set up accordingly?

• Server Recommendations
• Recommended PHP configuration limits

It’s best that you go over that with help from your hosting provider.

Please give that a go and keep us updated!

Hello @dcka and thank you for your recommendations.
My Server details are:
PHP: 7.4
memory_limit: 1GB
HTTP Support: YEs
upload_max_filesize = 1GB
post_max_size = 1GB
max_input_time = 1500
max_input_vars = 2000

You can check all server details at: https://erzamasoud.com/test.php
All PHP and server settings are optimal. Currently Woo Commerce is enabled and you can test site at https://erzamasoud.com/
If i disable Woo Commerce, then site will work fine.

I think no one is around to look into this right now.
I am disabling WooCommerce for now and hiding php info as well. Let me know, when someone in your team comes again and i will activate WooCommerce plugin and create php info file for you guys.

Hi there,

you can test site at https://erzamasoud.com/
If i disable Woo Commerce, then site will work fine.

Here is what I see currently: https://d.pr/i/7wvTea

Looks like the claue addons are missing some dependency: https://d.pr/i/EArnWI

Let me know, when someone in your team comes again

Can you setup a staging site? That way everyone can always take a look.

Kind regards,

@conschneider
You are too late my friend.
Issue was with Woo Commerce and Database settings. I have fixed it. You took the screenshot when i was fixing the issue.

Here are the details of the issue so you guys can reproduce and fix it later:

1- I have installed WordPress.
2- Installed Claue theme.
3- Installed Claue theme required plugins including WooCommerce.
4- WooCommerce Asked me to update Database.
5- I have click on Update Database button and it was completed successfully.
6- I have visited Website frontpage and it stopped showing any content. and it kept loading for 10-15 minutes.

Now issue occurred at step 5. When i have updated database, it changed DB Engine for all tables from MyISAM to InnoDB. As a result, Queries were stuck in between and woocommerce was not getting timely response from DB after writing session to DB.
I have fixed this by changing DB Engine for tables to MyISAM again and it has fixed the issue.

I hope that above observations and action items may help others with similar issues in future.
Now its for you guys to check why Woocommerce was changing DB engine for tables.

Thanks for you time team.

Sajid