Forum

Thread tagged as: Problem, Addons, MailChimp

Add-on MailChimp error importing subscriber list

I'm encountering an error when importing the subscriber list from mailchimp.

The Error in the Diagnostic report is:

Array
(
    [type] => 2
    [message] => fopen(https://us10.api.mailchimp.com/export/1.0/list?apikey=XX&id=b283603204): failed to open stream: no suitable wrapper could be found
    [file] => /var/www/web/perch/addons/apps/perch_mailchimp/PerchMailchimp_Util.class.php
    [line] => 37
)

It only happens on the live website, both localhost and preview site work as expected with same details. Guessing it could be server config issue but I'm not sure where to start looking.

Any help/pointers appreciated.

Thanks
Graham Shedden

Graham Shedden 0 points

  • 5 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

5 years ago

Can we see your Diagnostics Report please?
Graham Shedden

Graham Shedden 0 points

5 years ago

It's too big to paste in here. Can I mail it instead?
Graham Shedden

Graham Shedden 0 points

5 years ago

This is the part at the bottom:


INSERT INTO perch2_mailchimp_stats(title,total,yesterday,today) VALUES('RMSpumptools Contacts',2167,0,0)
[1] SELECT * FROM perch2_mailchimp_history WHERE historyDate = '2016-05-25' LIMIT 1
INSERT INTO perch2_mailchimp_history(historyDate,historyTotal) VALUES('2016-05-25',0)
Queries: 10
Memory: 4.2288

Array
(
    [type] => 2
    [message] => fopen(https://us4.api.mailchimp.com/export/1.0/list?apikey=XX&id=d11c9060d7): failed to open stream: no suitable wrapper could be found
    [file] => /var/www/web/perch/addons/apps/perch_mailchimp/PerchMailchimp_Util.class.php
    [line] => 37
)
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

You can find your diagnostic report under Settings > Diagnostics. It's not long.

You should rotate your MailChimp API key as you've now made it public.
Graham Shedden

Graham Shedden 0 points

5 years ago

Thanks

Report:


    Perch: 2.8.25, PHP: 5.5.35, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: XX $, with PDO
    Server OS: Linux, cgi-fcgi
    Installed apps: content (2.8.25), assets (2.8.25), categories (2.8.25), perch_blog (5.0), perch_forms (1.8.3), perch_mailchimp (2.0.1)
    App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_blog', 'perch_mailchimp', 'perch_forms', );
    PERCH_LOGINPATH: /perch
    PERCH_PATH: /var/www/web/perch
    PERCH_CORE: /var/www/web/perch/core
    PERCH_RESFILEPATH: /var/www/web/perch/resources
    Image manipulation: GD
    PHP limits: Max upload 128M, Max POST 128M, Memory: 128M, Total max file upload: 128M
    F1: dc1fef2ad0fcd9f943c02ebb43d85dbc
    Resource folder writeable: Yes
    DOCUMENT_ROOT: /var/www/web
    SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
    REQUEST_URI: /perch/core/settings/diagnostics/
    HTTP_HOST: www.XX.com
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

There's a newer version of the MailChimp app that you'll need to update to. The version you've got is based on an old API that is being turned off.
Graham Shedden

Graham Shedden 0 points

5 years ago

Thanks Drew, Updated and all working perfectly. Nice update to the MailChimp App BTW.