Hi. I have installed WooCommerce in my WordPress site and started seeing issues. Intermittent database connection issues which go away if refreshed. However, WooCommerce Payments plugin I couldn’t complete setup, was getting http 520 error. Searching around, seems its coming from Cloudfare, so went ahead and temporarily paused Cloudfare on that site. Now when I try again completing the setup, I get this error: "There was a problem connecting this site to WordPress.com: “The Jetpack server was unable to communicate with your site “xyz” [IXR -32300: transport error: http_request_failed cURL error 52: Empty reply from server]”.
Not sure now what that is. I can send my site url in a DM. Please help.
Ok, I am not using Jetpack anywhere directly. So, I think it is being used by WooCommerce or any other plugin internally? I will try deactivating WooCommerce temporarily and see if it goes away
WooCommerce Payments plugin uses JetPack internally and communicates via their (slow) CDN. Meanwhile with the existing security system, using online payment gateways might not work the way expected, as those payment processing servers might not be able to reach your online store to update order statues via webhook.
In this case, consider using offline methods or gateways that do not involve the use of webhooks. Alternatively, you can always upgrade,
Thanks for the information and clarity! I have removed the plugin and will try to find alternatives. Do you know of any that I can use?
Meanwhile, I reenabled WooCommerce and immediately see if says “database needs to be updated” and creates scheduled tasks. Once I click on the task for force run I see the database error " Error establishing a database connection.
This either means that the username and password information in your wp-config.php file is incorrect or that contact with the database server at sql106.byetcluster.com could not be established. This could mean your host’s database server is down.
Are you sure you have the correct username and password?
Are you sure you have typed the correct hostname?
Are you sure the database server is running?"
If I deactivate the plugin, there are no such errors.
I am seeing this after I upgraded to WordPress 6.3.4, so probably the plugin is not compatible with latest WP or some of the activities it is trying to do is not being allowed by the hosting environment? How can I confirm?
The fact that you can login WordPress already shows your database is working, however there’s a limit as to how much connection your site can make to the database. If WordPress already takes one, WooCommerce is likely to take the other quota and subsequent operations will fail due to connection rejected hence the error message.
WooCommerce works completely fine with the latest version of WordPress, and yes it requires database updates from time to time. However there are limitations on InfinityFree hosting, meaning the database can only spend a portion of effort on your site, you can simply keep retrying over time to gradually complete the update. Your site will work just fine over the process.
There are no alternatives for Jetpack as it is not a useful plugin in my opinion for the time being, and there won’t be alternatives for something not being useful.
Thank you, chiucs123. That makes sense and possibly InfinityFree hosting has reduced the connections available per website/app for more availability to other apps/websites. I guess I will need to find alternatives to hosting my store.