Forum

Thread tagged as: Problem, MailChimp

Mailchimp form not updating the List

The Mailchimp App is working well except it's not adding subscribers to the list.

Any hints?

Debug Message:

SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
SELECT * FROM perch2_forms WHERE formKey='subscribe' LIMIT 1
SELECT * FROM perch2_pages WHERE pagePath='/contact/index.html' LIMIT 1
INSERT INTO perch2_forms_responses(responseJSON,formID,responseIP,responseSpamData) VALUES('{\"fields\":{\"email\":{\"attributes\":{\"id\":\"email\",\"required\":\"true\",\"type\":\"email\",\"mailer\":\"email\"},\"value\":\"i@martinfreer.com\"},\"firstname\":{\"attributes\":{\"id\":\"firstname\",\"required\":\"true\",\"type\":\"text\",\"mailer\":\"FNAME\"},\"value\":\"Martin\"},\"lastname\":{\"attributes\":{\"id\":\"lastname\",\"required\":\"true\",\"type\":\"text\",\"mailer\":\"LNAME\"},\"value\":\"Freer\"},\"phone\":{\"attributes\":{\"id\":\"phone\",\"type\":\"text\",\"mailer\":\"MMERGE5\"},\"value\":\"+61410165743\"},\"address\":{\"attributes\":{\"id\":\"address\",\"type\":\"text\",\"mailer\":\"MMERGE4[addr1]\"},\"value\":\"35\"},\"address2\":{\"attributes\":{\"id\":\"address2\",\"type\":\"hidden\",\"mailer\":\"MMERGE4[addr2]\"},\"value\":\"\"},\"city\":{\"attributes\":{\"id\":\"city\",\"required\":\"true\",\"type\":\"text\",\"mailer\":\"MMERGE4[city]\"},\"value\":\"St James\"},\"state\":{\"attributes\":{\"id\":\"state\",\"required\":\"true\",\"type\":\"text\",\"mailer\":\"MMERGE4[state]\"},\"value\":\"WA\"},\"zip\":{\"attributes\":{\"id\":\"zip\",\"required\":\"true\",\"type\":\"text\",\"mailer\":\"MMERGE4[zip]\"},\"value\":\"6102\"},\"country\":{\"attributes\":{\"id\":\"country\",\"required\":\"true\",\"type\":\"select\",\"mailer\":\"MMERGE4[country]\",\"options\":\" ,Australia, Canada, Singapore, United Kingdom, United States of America, -------------, Afghanistan, Albania, Algeria, Andorra, Angola, Antigua & Deps, Argentina, Armenia, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bhutan, Bolivia, Bosnia Herzegovina, Botswana, Brazil, Brunei, Bulgaria, Burkina, Burma, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Central African Rep, Chad, Chile, People\'s Republic of China, Republic of China, Colombia, Comoros, Democratic Republic of the Congo, Republic of the Congo, Costa Rica,Croatia, Cuba, Cyprus, Czech Republic, Danzig, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fiji, Finland, France, Gabon, Gaza Strip, The Gambia, Georgia, Germany, Ghana, Greece, Grenada, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Holy Roman Empire, Honduras, Hungary, Iceland, India, Indonesia, Iran, Iraq, Republic of Ireland, Israel, Italy, Ivory Coast, Jamaica, Japan, Jonathanland, Jordan, Kazakhstan, Kenya, Kiribati, North Korea, South Korea, Kosovo, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montenegro, Morocco, Mount Athos, Mozambique, Namibia, Nauru, Nepal, Newfoundland, Netherlands, New Zealand, Nicaragua, Niger, Nigeria, Norway, Oman, Ottoman Empire, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Prussia, Qatar, Romania, Rome, Russian Federation, Rwanda, St Kitts & Nevis, St Lucia, Saint Vincent & the, Grenadines, Samoa, San Marino, Sao Tome & Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, Spain, Sri Lanka, Sudan, Suriname, Swaziland, Sweden, Switzerland, Syria, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad & Tobago, Tunisia, Turkey, Turkmenistan, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City, Venezuela, Vietnam, Yemen, Zambia, Zimbabwe\"},\"value\":\"Australia\"},\"source\":{\"attributes\":{\"id\":\"source\",\"mailer\":\"MMERGE3\",\"type\":\"select\",\"options\":\" ,Google,Facebook,LinkedIn,Instagram,Twitter,City of Rockingham,Macquarie University,UTS,Promotional Campaign,Media \\/ News,Friend,Other\"},\"value\":\"Google\"},\"vol_wwc\":{\"attributes\":{\"type\":\"checkbox\",\"id\":\"vol_wwc\",\"required\":\"true\",\"value\":\"Agrees to privacy\"},\"value\":\"Agrees to privacy\"},\"confirm\":{\"attributes\":{\"type\":\"hidden\",\"value\":\"1\",\"id\":\"confirm\",\"mailer\":\"confirm_subscribe\"},\"value\":\"1\"}},\"files\":[],\"page\":{\"id\":\"9\",\"title\":\"Register your interest\",\"path\":\"\\/contact\\/index.html\",\"navtext\":\"Be a volunteer\"}}','3','120.16.65.81','{\"fields\":[],\"environment\":{\"HTTP_ACCEPT\":\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,image\\/webp,*\\/*;q=0.8\",\"HTTP_ACCEPT_ENCODING\":\"gzip, deflate\",\"HTTP_ACCEPT_LANGUAGE\":\"en-US,en;q=0.8\",\"HTTP_CONNECTION\":\"keep-alive\",\"CONTENT_TYPE\":\"application\\/x-www-form-urlencoded\",\"CONTENT_LENGTH\":\"382\",\"HTTP_COOKIE\":\"cmsa=1; _gat=1; PHPSESSID=28e8ffbcfc13a07db0e252e3e9f3e586; _ga=GA1.2.1243433322.1420848256\",\"HTTP_HOST\":\"communitymates.org\",\"HTTP_PRAGMA\":\"no-cache\",\"HTTP_REFERER\":\"https:\\/\\/communitymates.org\\/contact\\/\",\"HTTP_USER_AGENT\":\"Mozilla\\/5.0 (Macintosh; Intel Mac OS X 10_11_1) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/47.0.2526.106 Safari\\/537.36\",\"HTTP_CACHE_CONTROL\":\"no-cache\",\"HTTP_ORIGIN\":\"https:\\/\\/communitymates.org\",\"HTTP_UPGRADE_INSECURE_REQUESTS\":\"1\",\"DOCUMENT_ROOT\":\"\\/home\\/communitymates\\/public_html\",\"REMOTE_ADDR\":\"120.16.65.81\",\"REMOTE_PORT\":\"48755\",\"SERVER_ADDR\":\"223.130.27.110\",\"SERVER_NAME\":\"communitymates.org\",\"SERVER_ADMIN\":\"webmaster@communitymates.org\",\"SERVER_PORT\":\"80\",\"REQUEST_URI\":\"\\/contact\\/index.html\",\"SCRIPT_FILENAME\":\"\\/home\\/communitymates\\/public_html\\/contact\\/index.html\",\"QUERY_STRING\":\"\",\"SCRIPT_URI\":\"https:\\/\\/communitymates.org\\/contact\\/index.html\",\"SCRIPT_URL\":\"\\/contact\\/index.html\",\"SCRIPT_NAME\":\"\\/contact\\/index.html\",\"SERVER_PROTOCOL\":\"HTTP\\/1.1\",\"SERVER_SOFTWARE\":\"LiteSpeed\",\"REQUEST_METHOD\":\"POST\",\"PHP_SELF\":\"\\/contact\\/index.html\",\"REQUEST_TIME_FLOAT\":1452655073.29,\"REQUEST_TIME\":1452655073,\"argv\":[],\"argc\":0}}')
SELECT * FROM perch2_forms_responses WHERE responseID='25' LIMIT 1
No ids to log.
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/contact/index.html' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004-002', '000-004', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/item.html
SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/contact/index.html' OR regionPage='*' ORDER BY regionPage DESC
Using template: /addons/apps/perch_mailchimp/templates/mailchimp/subscribe.html
Array
(
    [type] => 32
    [message] => PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20131226/mailparse.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20131226/mailparse.so: cannot open shared object file: No such file or directory
    [file] => Unknown
    [line] => 0
)

Template:

    <perch:form id="subscribe" app="perch_mailchimp perch_forms" double-optin="true" send-welcome="true">

    <h2>Subscribe to our mailing list</h2>
    <p>Get notified of upcoming volunteering opportunities in your area.</p>

    <perch:success>
        <h2>Thank you!</p> 
        <p>Please check your email address to confirm your signup.</p>
    </perch:success>

    <div>
        <perch:label for="email">Email <sup>*</sup></perch:label>
        <perch:input id="email" required="true" type="email" mailer="email" />
        <perch:error type="required" for="email">Required</perch:error>
    </div>
<div class="size1of2">
        <perch:label for="firstname">First name <sup>*</sup></perch:label>
        <perch:input id="firstname" required="true" type="text" mailer="FNAME" />
        <perch:error type="required" for="firstname">Required</perch:error>
    </div>
    <div class="size1of2">
        <perch:label for="lastname">Last name <sup>*</sup></perch:label>
        <perch:input id="lastname" required="true" type="text" mailer="LNAME" />
        <perch:error type="required" for="lastname">Required</perch:error>
    </div>
    <div>
        <perch:label for="phone">Phone</perch:label>
        <perch:input id="phone" type="text" mailer="MMERGE5"  />
    </div>
    <div>
        <perch:label for="address">Street Address <sup>*</sup></perch:label>
        <perch:input id="address" type="text" mailer="MMERGE4[addr1]"  />
        <perch:input id="address2" type="hidden" mailer="MMERGE4[addr2]"  />
        <perch:error type="required" for="address">Required</perch:error>
    </div>
        <div class="size1of2">
        <perch:label for="city">City/Suburb <sup>*</sup></perch:label>
        <perch:input id="city" required="true" type="text" mailer="MMERGE4[city]" />
        <perch:error type="required" for="city">Required</perch:error>
    </div>
    <div class="size1of2">
        <perch:label for="state">State/Province/Region <sup>*</sup></perch:label>
        <perch:input id="state" required="true" type="text" mailer="MMERGE4[state]" />
        <perch:error type="required" for="state">Required</perch:error>
    </div>
    <div class="size1of2">
        <perch:label for="zip">Postal / Zip Code <sup>*</sup></perch:label>
        <perch:input id="zip" required="true" type="text" mailer="MMERGE4[zip]" />
        <perch:error type="required" for="zip">Required</perch:error>
    </div>
    <div class="size1of2">
        <perch:label for="country">Country <sup>*</sup></perch:label>
        <perch:input id="country" required="true" type="select" mailer="MMERGE4[country]" options=" ,Australia, Canada, Singapore, United Kingdom, United States of America, -------------, Afghanistan, Albania, Algeria, Andorra, Angola, Antigua & Deps, Argentina, Armenia, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bhutan, Bolivia, Bosnia Herzegovina, Botswana, Brazil, Brunei, Bulgaria, Burkina, Burma, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Central African Rep, Chad, Chile, People's Republic of China, Republic of China, Colombia, Comoros, Democratic Republic of the Congo, Republic of the Congo, Costa Rica,Croatia, Cuba, Cyprus, Czech Republic, Danzig, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fiji, Finland, France, Gabon, Gaza Strip, The Gambia, Georgia, Germany, Ghana, Greece, Grenada, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Holy Roman Empire, Honduras, Hungary, Iceland, India, Indonesia, Iran, Iraq, Republic of Ireland, Israel, Italy, Ivory Coast, Jamaica, Japan, Jonathanland, Jordan, Kazakhstan, Kenya, Kiribati, North Korea, South Korea, Kosovo, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montenegro, Morocco, Mount Athos, Mozambique, Namibia, Nauru, Nepal, Newfoundland, Netherlands, New Zealand, Nicaragua, Niger, Nigeria, Norway, Oman, Ottoman Empire, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Prussia, Qatar, Romania, Rome, Russian Federation, Rwanda, St Kitts & Nevis, St Lucia, Saint Vincent & the, Grenadines, Samoa, San Marino, Sao Tome & Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, Spain, Sri Lanka, Sudan, Suriname, Swaziland, Sweden, Switzerland, Syria, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad & Tobago, Tunisia, Turkey, Turkmenistan, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City, Venezuela, Vietnam, Yemen, Zambia, Zimbabwe" />
        <perch:error type="required" for="country">Required</perch:error>
    </div>

    <div class="clear">
        <perch:label for="source">How did you hear about us?</perch:label>
        <perch:input  id="source" mailer="MMERGE3" type="select" options=" ,Google,Facebook,LinkedIn,Instagram,Twitter,City of Rockingham,Macquarie University,UTS,Promotional Campaign,Media / News,Friend,Other" />
    </div>
    <div class="radiowrapper">
            <perch:input type="checkbox" id="vol_wwc" required="true" value="Agrees to privacy" />
            I agree to the <a target="_blank" href="/assets/docs/cm_privacypolicy_20151027.pdf">Privacy policy</a> 

            <perch:error type="required" for="vol_wwc">Required</perch:error>
        </div>
        <br>
    <div>
        <perch:input type="submit" value="Submit" id="btnsubmit" />
        <perch:input type="hidden" value="1" id="confirm" mailer="confirm_subscribe" />
    </div>  

</perch:form>
Martin Freer

Martin Freer 0 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What behaviour are you seeing?

Was it working previously, or is this a new configuration?

Upon submission, I get the success message and the response is listed in the forms app. However, it doesn't update the mailchimp subscriber list in the mailchimp app nor on the mailchimp website.

It was not working previously.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Do you get the the double opt-in email?

Nope. No opt-in email.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Are there any errors in your log?

Looks like there are no PHP errors either (or any other kind)

Drew McLellan

Drew McLellan 2638 points
Perch Support

Is this on the production server? I'm wondering if the server's CA root certificates aren't up to date, which would cause an SSL failure when communicating with MailChimp's server.

There's info about that problem here: https://snippets.webaware.com.au/howto/stop-turning-off-curlopt_ssl_verifypeer-and-fix-your-php-config/

I received this response from the hosting company:

'They should be otherwise other SSLs would have issues with it. Which CA in particular are you having issues with?'

I'm guessing it's worth creating another simple list form and testing to see if it's the subscribe.html.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, always worth testing.