Forum

Thread tagged as: Question, Error, MailChimp

MailChimp App sync / database problems

1. Some lists are not synced

There are 7 lists. Only 3 of them shows up in MailChimp App. Looking at debug, the lists that don't make it have 11 values but there are 9 only columns. Here is an excerpt:

Importing list: 34d8ab44d2
INSERT INTO perch2_mailchimp_lists(listMailChimpID,listTitle,listMemberCount,listMemberCountSinceLastSend,listUnsubsSinceLastSend,listOpenRate,listClickRate,listLastSend,listCreated) VALUES('34d8ab44d2','Nyhetsbrev automatiserade fordon',1117,7,0,31,518691588785,6,2571716272861,'2016-10-11 06:01:51','2015-08-24 13:32:18')
Invalid query: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1

Why is this happening? What can I do?

2. Subscribers not syncing

My form is only collecting email, not names. Subscribers didn't show in MailChimp app because 'subscriberFirstName' and 'subscriberLastName' in the database table 'perch2_mailchimp_subscribers' didn't allow NULL. I fixed that myself by changing standard value to NULL, but thought I should let you know.
Tim Kinali

Tim Kinali 0 points

  • 4 years ago
Tim Kinali

Tim Kinali 0 points

4 years ago

Here's the diagnostics.

SUMMARY INFORMATION

Perch: 2.8.32, PHP: 5.6.25, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $, with PDO
Server OS: FreeBSD, apache2handler
Installed apps: content (2.8.32), assets (2.8.32), categories (2.8.32), perch_mailchimp (3.0.1)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_mailchimp', );
PERCH_LOGINPATH: /admin
PERCH_PATH: /www/webvol13/zc/ghszejk9h4ubjsp/smartisverige.se/public_html/admin
PERCH_CORE: /www/webvol13/zc/ghszejk9h4ubjsp/smartisverige.se/public_html/admin/core
PERCH_RESFILEPATH: /www/webvol13/zc/ghszejk9h4ubjsp/smartisverige.se/public_html/admin/resources
Image manipulation: GD Imagick
PHP limits: Max upload 50M, Max POST 50M, Memory: 128M, Total max file upload: 50M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
HTTP_HOST: smartisverige.se
DOCUMENT_ROOT: /www/webvol13/zc/ghszejk9h4ubjsp/smartisverige.se/public_html
REQUEST_URI: /admin/core/settings/diagnostics/
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
Drew McLellan

Drew McLellan 2638 points
Perch Support

4 years ago

I shall take a look.
Tim Kinali

Tim Kinali 0 points

4 years ago

Did you have a chance to look into this Drew?
Drew McLellan

Drew McLellan 2638 points
Perch Support

4 years ago

Not yet, sorry, it is on my list!