Error connecting store to Mailchimp

Hi @khchick, Sorry to hear you’re having issues with the plugin, we definitely want to try to help out. Just to get a handle on the situation you’re experiencing, could you provide a few more pieces of information to help us understand the issue?

– What plugin version are you using?
– What version of PHP are you using?
– Are there any log errors in the plugin’s logs tab for the most recent day (when it’s set to standard or debug)?
– If you’re using the current version of the plugin, it utilizes a queue powered by Action Scheduler. It depends on WP_CRON to be activated with your hosting provider. Can you confirm it’s enabled?
– If you’re using a host that makes use of CPU throttling, can you check to see if you’ve hit your limit after initiating the sync?
– Do you have any caching plugins or services running?
– If you’ve uninstalled/reinstalled, can you verify that the store had first been removed from the Connected site’s area in Mailchimp before reinstalling?
– If you have a large number of plugins being used, you may need to bump up your memory limit on your server (1GB for example) to accommodate the initial sync.

Thanks in advance for these details. I’ll keep an eye out for your reply.

Thanks for your response @khungate. Let me try to provide the required info for reference:

What plugin version are you using?
– 2.3.2

What version of PHP are you using?
– PHP 7.3 (ea-php73)

Are there any log errors in the plugin’s logs tab for the most recent day (when it’s set to standard or debug)?
– There isn’t a plugin log tab, how should I find the log?
??
If you’re using the current version of the plugin, it utilizes a queue powered by Action Scheduler. It depends on WP_CRON to be activated with your hosting provider. Can you confirm it’s enabled?
– Yes it is enabled

If you’re using a host that makes use of CPU throttling, can you check to see if you’ve hit your limit after initiating the sync?
– I’m not able to check yet, but it surely said connected, and asked me to wait while it’s loading the next step

Do you have any caching plugins or services running?
– No

If you’ve uninstalled/reinstalled, can you verify that the store had first been removed from the Connected site’s area in Mailchimp before reinstalling?
– Yes

If you have a large number of plugins being used, you may need to bump up your memory limit on your server (1GB for example) to accommodate the initial sync.
– It’s more than that currently

Thanks again for your support.

@khchick the CURL response with a 0 in the error message means that we’re having trouble communicating with Mailchimp’s API for some reason. Typically this means it’s related to Akamai ( the Mailchimp API Gateway ) and we might be in a bit of a situation where you’ll need to change from a shared host to a dedicated host on your website hosting.

Can you please confirm the hosting provider, along with whether or not you’re on a shared server or a dedicated server? Shared IP address vs. a dedicated IP address?

Also another thing that you should do during troubleshooting along this path is to reference this post to run a command in the terminal which will tell us whether or not your server itself is blacklisted or if it’s only happening while you’re using PHP CURL. This is a little more advanced for some, but you could also have your web host run this for you in order to help troubleshoot a problem.

If you do get a response this way from the API, just be careful on what you paste back here – as your api key would be listed… we just want to see if you can communicate with the server.

Hi @ryanhungate Thanks for your reply.

I’m using shared hosting. Does that mean this problem will not be resolved in a short while at least before the next major update?

Is there a workaround apart from switching to a dedicated server?

@khchick sorry for the delay – unfortunately this probably won’t be something the plugin can resolve in your current hosting environment. We’ve seen this happen when folks are using a Windows server too. By chance are you using a Windows machine?

Can you please verify the version of CURL that you’re using? Have you tried that link that we mentioned above to run the GET request from the command line just to see if your server is being blocked?

We’ll look out for your response here thanks!

Hi @ryanhungate
Thanks for following up. I’m reaching out to my hosting service provider to test the CURL connection.

Meanwhile I want to more info on the incident, but not sure how I can attach screen caps for these:
1. It showed connected in WP
2. But after the page is reloaded it showed error 1793, with a blank error message below
3. In my Mailchimp account it also showed a successful API call

Will keep you posted. Thanks!

hey @khchick just wanted to reach out to see if you’re still having trouble with the plugin, or if the hosting provider has been able to resolve your shared IP situation?

Thanks @ryanhungate for following up. Unfortunately they said they can’t run CURL on shared hosting account, and advised me to upload a patch for the plugin. I guess that means I have to wait until it is updated?

Can you let me know if there’s any other possibility given that the API call is recorded as successful in my MailChimp account? Could it not be connection issue?

Thanks.

@khchick can you please have them verify that your CA Cert is in the right place? They should know what that means. We need to verify that you can make a successful request FROM your server to Mailchimp, and this is the first troubleshooting that we would do.

They should be able to run a CURL command for you even though you’re on a shared host, they should be able to help with this verification.

Thanks we’ll look out for your response

Hi @ryanhungate , I’ve reached out to the theme provider they have resolved the issue for the me by installing MC4WP: Mailchimp for WordPress plugin (which is required apparently, but not sure why there is already a “MailChimp” tab in the menu before, which I’ve been using).

Anyway thanks for all the help! This ticket can be closed.