This topic has 14 replies, 2 voices, and was last updated 10 years by 
-
-
Having trouble with the Newsletter widget. My two lists are not showing up in the widget dropdown. Getting…
Error: Could not connect (ERR 0: php_network_getaddresses: getaddrinfo failed: Name or service not known)
My MailChimp API is entered in:
– Settings / PMPro MailChimp
– Settings / AutoChimp
– SweetDate / MiscellaneousMy two lists ARE showing up in both PMPro MailChimp and AutoChimp, just not in the widget. Therefore it errors out on the website subscribing to the newsletter… http://goo.gl/GDTH1T
Any ideas? I updated the template. Thanks!
Found this doing some research, but can’t seem to find what “sample config file” they’re talking about to change. Any idea? Other responses indicate a blocked port from our host.
“So after googling the error a little bit it appears that perhaps there is an issue with the url we are trying to hit when processing through the API. So the link in the example config file which I did not change is the following: http://api.mailchimp.com/1.3/. Is this the correct url that the api should be using?
So I switched the url from…
http://api.mailchimp.com/1.3/
to
http://us4.api.mailchimp.com/1.3/…and I am no longer getting that error.”
I finally found a version of this link in framework/widgets/mailchimp/MCAPI.php on line 42. Adding us4 to the link doesn’t change anything.
$this->apiUrl = parse_url(“http://api.mailchimp.com/” . $this->version . “/?output=php”);
// $this->apiUrl = parse_url(“http://us4.api.mailchimp.com/” . $this->version . “/?output=php”);Just talked to my host to see if there may be a blocked port that Mailchimp might be using. They said no, and no one has heard of this problem. They did say if they knew what port it’s supposed to be using, they would whitelist it for me. They said it looks like it’s using port 80 which would obviously never be blocked. Any ideas? Want to launch the site and this is delaying it. Thanks!
Also just found that the “us4” needs to be the what the end of your API key is… mine is us7. Doesn’t help. Still errors out when subscribing, and lists are not showing up in the widget.
My guess is there’s something wrong with this file…
/framework/widgets/mailchimp/widget_mailchimp.php
Just noticed this daily error in the admin error_log…
[04-Feb-2014 23:17:08 UTC] PHP Warning: fsockopen() [function.fsockopen]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/athedat5/public_html/wp-content/plugins/pmpro-mailchimp/includes/MCAPI.class.php on line 2426
[04-Feb-2014 21:59:34 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY id’ at line 1 for query SELECT * FROM ORDER BY id made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, pmpromc_init, pmpromc_getPMProLevels
[03-Feb-2014 16:25:01 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/athedat5/public_html/wp-content/themes/sweetdate/framework/widgets/widget_mailchimp.php on line 178
This one in the root error_log…
[04-Feb-2014 19:48:37 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/athedat5/public_html/wp-content/plugins/buddypress/bp-members/bp-members-template.php:993) in /home/athedat5/public_html/wp-includes/pluggable.php on line 896
Hi and sorry for the late reply
I think this plugins might cause you trouble pmpro-mailchimp, try disabling it and make sure to set your mailchimp data in Sweetdate – Miscellaneous
We haven’t seen this kind of problems until now. Also you host could block the fsockopen php function.Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution---
@ SeventhQueen we do our best to have super happy customers. Thanks for being our customer.Thanks Abe. I already deleted both pmpro-mailchimp and autochimp plugins. Key has been set in Miscellaneous from the beginning. My host says the fsockopen php function is unblocked. Still errors out. I’m currently on a chat with them, they’re taking a further look.
Error: Could not connect (ERR 0: php_network_getaddresses: getaddrinfo failed: Name or service not known)
The host says their level of support was unable to determine the cause of the error, and is going to create a ticket for me and escalate it. Any other ideas?
This is what Support says… seems like there’s a double “us7” put into the link.
Thank you for your patience regarding this matter. Indeed this seems to be related to your widget which is trying to connect to a hostname that doesn’t exist:
[06-Feb-2014 22:27:28 UTC] PHP Warning: fsockopen() [function.fsockopen]: unable to connect to us7.us7.api.mailchimp.com:80 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home/athedat5/public_html/wp-content/themes/sweetdate/framework/widgets/mailchimp/MCAPI.class.php on line 2850
As you can see from the above log, your widget is trying to access us7.us7.api.mailchimp.com but this domain doesn’t exist:
fmartinica@core:~$ host us7.us7.api.mailchimp.com
Host us7.us7.api.mailchimp.com not found: 3(NXDOMAIN)Can you please contact ailchimp.com and ask them which should be the correct hostname for api.mailchimp.com and modify the settings accordingly?
I see the problem… I didn’t change this line back your original version in MCAPI.class.php. Now it works!
// $this->apiUrl = parse_url(“http://api.mailchimp.com/” . $this->version . “/?output=php”);
$this->apiUrl = parse_url(“http://us7.api.mailchimp.com/” . $this->version . “/?output=php”);The widget now shows my two lists to pick from. Back in business! Thanks!
Great getyler2, I am glad it works for you
Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution---
@ SeventhQueen we do our best to have super happy customers. Thanks for being our customer.
You must be logged in to reply to this topic.
