Forum

Thread tagged as: MailChimp

Mail chimp Subscribe not working

Hi,

I've installed mail chimp, all seems ok, lists and campings are listed in perch. but, when I submit a new subscription. it does not register new subscriber, in mail chimp.

the API key is correct. and is running live in a subdomain

I have debug on, and no errors are shown.

Plus looking at perch live database no new subscribers in perch or in mail chimp.

any ideas why?

form

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

    <perch:success>
        <br>
        <p>Thank you!</p>
        <p>You are subscribed to our newsletter</p>
    </perch:success>

    <div align="center">
        <perch:label for="email">Email</perch:label>
        <perch:input id="email" required="true" type="email" mailer="email" class="form-control required email" />
        <perch:error type="required" for="email">Required</perch:error>
    </div>
    <div align="center">
        <perch:label for="firstname">First name</perch:label>
        <perch:input id="firstname" required="true" type="text" mailer="FNAME" class="form-control" />
        <perch:error type="required" for="firstname">Required</perch:error>
    </div>
    <div align="center">
        <perch:label for="lastname">Last name</perch:label>
        <perch:input id="lastname" required="true" type="text" mailer="LNAME" class="form-control" />
        <perch:error type="required" for="lastname">Required</perch:error>
    </div>
    <div align="center">
        <perch:input type="submit" value="Subscribe" id="btnsubmit" class="btn btn-pill btn-sm btn-default waves-effect waves-light"/>
        <perch:input type="hidden" value="1" id="confirm" mailer="confirm_subscribe" />
        <perch:input type="hidden" id="list" value="your list ID goes here" mailer="list" />
    </div>  

</perch:form>


Perch information Perch: 3.0.8 Production mode: Production (100) Installed apps: content (3.0.8), assets (3.0.8), categories (3.0.8), perch_blog (5.5.1), perch_mailchimp (3.1) DB driver: PDO DB tables: perch3_blog_authors (2), perch3_blog_comments (0), perch3_blog_index (156), perch3_blog_posts (2), perch3_blog_posts_to_tags (0), perch3_blog_sections (1), perch3_blog_tags (0), perch3_blogs (1), perch3_categories (7), perch3_category_counts (2), perch3_category_sets (2), perch3_content_index (1517), perch3_content_items (345), perch3_content_regions (348), perch3_mailchimp_campaigns (1), perch3_mailchimp_imports (0), perch3_mailchimp_lists (1), perch3_mailchimp_subscribers (2), perch3_mailchimp_subscriptions (2), perch3_mailchimp_webhooks (1), perch3_menu_items (10), perch3_navigation (0), perch3_navigation_pages (0), perch3_page_templates (1), perch3_pages (7), perch3_resource_log (1252), perch3_resource_tags (2), perch3_resources (222), perch3_resources_to_tags (4), perch3_settings (29), perch3_user_passwords (0), perch3_user_privileges (38), perch3_user_role_privileges (2), perch3_user_roles (2), perch3_users (2) Users: 2 App runtimes: <?php $apps_list = ['perch_blog','perch_mailchimp' ]; Scheduled tasks for perch_blog: delete_spam_comments (1440 mins) Scheduled tasks for perch_mailchimp: import_data (1 mins) Editor plug-ins: H1: 49b4ae9f1999c75aea345cf1911658d7 L1: 71d12f843811743f7fff94e1371f0a05 F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7 headerColour: #ffffff content_singlePageEdit: 1 helpURL: siteURL: / hideBranding: 1 content_collapseList: 1 lang: en-gb installedAt: 3.0.8 update_3.0.8: done latest_version: on_sale_version: headerScheme: light dashboard: 0 hide_pwd_reset: 0 keyboardShortcuts: 0 content_hideNonEditableRegions: 0 content_frontend_edit: 0 content_skip_region_list: 0 logoPath: /perch/resources/logo.png perch_blog_update: 5.0.1 perch_blog_post_url: post.php?s={postSlug} perch_blog_site_name: perch_blog_slug_format: %Y-%m-%d-{postTitle} perch_blog_akismet_key: perch_blog_max_spam_days: 0 perch_blog_comment_notify: 0 perch_mailchimp_api_key: dd767a357e115f259cade209c18f35c9-us16 perch_mailchimp_campaign_url: /mailchimp/campaign/{campaignSlug} perch_mailchimp_secret: 2b436f1 PERCH_DEVELOPMENT: 10 PERCH_STAGING: 50 PERCH_PRODUCTION: 100 PERCH_DB_USERNAME: db78335_michaela2 PERCH_DB_SERVER: internal-db.s78335.gridserver.com PERCH_DB_DATABASE: db78335_michaela2 PERCH_DB_PREFIX: perch3_ PERCH_TZ: UTC PERCH_EMAIL_FROM: info@michaelasalon.com PERCH_EMAIL_FROM_NAME: Michaela Mitoi PERCH_LOGINPATH: /perch PERCH_PATH: /nfs/c05/h06/mnt/78335/domains/salon.tonymonckton.co.uk/html/perch PERCH_CORE: /nfs/c05/h06/mnt/78335/domains/salon.tonymonckton.co.uk/html/perch/core PERCH_RESFILEPATH: /nfs/c05/h06/mnt/78335/domains/salon.tonymonckton.co.uk/html/perch/resources PERCH_RESPATH: /perch/resources PERCH_HTML5: 1 PERCH_RUNWAY: PERCH_ERROR_MODE: DIE PERCH_DATE_LONG: %d %B %Y PERCH_DATE_SHORT: %d %b %Y PERCH_TIME_SHORT: %H:%M PERCH_TIME_LONG: %H:%M:%S PERCH_RUNWAY_ROUTED: PERCH_STRONG_PASSWORDS: PERCH_ASSET_VERSION: 5163d57ff611b3cf853b PERCH_DEBUG: PERCH_PREVIEW_ARG: preview PERCH_TEMPLATE_PATH: /nfs/c05/h06/mnt/78335/domains/salon.tonymonckton.co.uk/html/perch/templates PERCH_TEMPLATE_FILTERS: PERCH_DEFAULT_DOC: index.php PERCH_DEFAULT_EXT: .php PERCH_PRODUCTION_MODE: 100 PERCH_XHTML_MARKUP: PERCH_RWD: 1 PERCH_HTML_ENTITIES: PERCH_SSL: PERCH_STRIPSLASHES: PERCH_PROGRESSIVE_FLUSH: 1 PERCH_PARANOID: PERCH_FORCE_SECURE_COOKIES: PERCH_DEFAULT_BUCKET: default PERCH_TRANSLATION_ASSIST: PERCH_PASSWORD_MIN_LENGTH: 6 PERCH_MAX_FAILED_LOGINS: 10 PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR PERCH_VERIFY_UPLOADS: PERCH_PRIV_ASSIST: PERCH_CUSTOM_EDITOR_CONFIGS: PERCH_AUTH_PLUGIN: PERCH_DB_CHARSET: utf8 PERCH_DB_PORT: PERCH_DB_SOCKET: PERCH_APPS_EDITOR_PLUGIN: markitup PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown Hosting settings PHP: 5.6.21 Zend: 2.6.0 OS: Linux SAPI: cgi-fcgi Safe mode: not detected MySQL client: 5.5.53 MySQL server: 5.1.63-rel13.4 Free disk space: 3.70 TB Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, session, intl, json, ldap, mbstring, mcrypt, standard, mysqlnd, mysqli, mysql, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, imap, SimpleXML, soap, sockets, exif, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, mhash GD: Yes ImageMagick: No PHP max upload size: 20M PHP max form post size: 20M PHP memory limit: 2048M Total max uploadable file size: 20M Resource folder writeable: Yes Session timeout: 24 minutes Native JSON: Yes Filter functions: Yes Transliteration functions: Yes PWD: /etc/apache2/gs-bin SCRIPT_NAME: /perch/core/settings/diagnostics/index.php REQUEST_URI: /perch/core/settings/diagnostics/?extended QUERY_STRING: extended REQUEST_METHOD: GET SERVER_PROTOCOL: HTTP/1.1 GATEWAY_INTERFACE: CGI/1.1 REMOTE_PORT: 49946 SCRIPT_FILENAME: /home/78335/domains/salon.tonymonckton.co.uk/html/perch/core/settings/diagnostics/index.php SERVER_ADMIN: webmaster@salon.tonymonckton.co.uk DOCUMENT_ROOT: /home/78335/domains/salon.tonymonckton.co.uk/html REMOTE_ADDR: 86.181.161.21 SERVER_PORT: 80 SERVER_ADDR: 70.32.68.91 SERVER_NAME: salon.tonymonckton.co.uk SERVER_SOFTWARE: Apache/2.2.22 SERVER_SIGNATURE: <address>Apache/2.2.22 Server at salon.tonymonckton.co.uk Port 80</address> PATH: /usr/local/bin:/usr/bin:/bin HTTP_ACCEPT_ENCODING: gzip, deflate HTTP_ACCEPT_LANGUAGE: en-us HTTP_REFERER: https://salon.tonymonckton.co.uk/perch/core/settings/diagnostics/ HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/603.2.5 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.5 HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_UPGRADE_INSECURE_REQUESTS: 1 HTTP_CONNECTION: close HTTP_COOKIE: PHPSESSID=9d76ec192215586d7f49f9386501f046; cmsa=1; _ga=GA1.3.1605129546.1470844572 HTTP_HOST: salon.tonymonckton.co.uk PHPRC: /home/78335/etc/ SITE_HTMLROOT: /home/78335/domains/salon.tonymonckton.co.uk/html SITE_CGIROOT: /home/78335/cgi-bin SITE_ROOT: /home/78335 DATABASE_SERVER: internal-db.s78335.gridserver.com ACCESS_DOMAIN: s78335.gridserver.com WM_UCONTROL_XMLRPC_SERVER: https://10.0.0.13 proxy_nokeepalive: 1 force_proxy_request_1_0: 1 SCRIPT_URI: https://salon.tonymonckton.co.uk/perch/core/settings/diagnostics/ SCRIPT_URL: /perch/core/settings/diagnostics/ UNIQUE_ID: WWcLDkYgRBYAAAxK8RoAAAA8 FCGI_ROLE: RESPONDER PHP_SELF: /perch/core/settings/diagnostics/index.php REQUEST_TIME_FLOAT: 1499925262.8136 REQUEST_TIME: 1499925262 argc: 1
Tony Monckton

Tony Monckton 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What does debug show after submitting the form?

this debug info. after pressing submit/subscribe button

before; perch_mailchimp_form()

Debug Message - Perch 3.0.8
[29] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_mailchimp_lists WHERE listMailChimpID='your list ID goes here' LIMIT 1
after; perch_mailchimp_form()

Debug Message - Perch 3.0.8
[29] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_mailchimp_lists WHERE listMailChimpID='your list ID goes here' LIMIT 1
Using template: /templates/mailchimp/forms/subscribe.html

it says "WHERE listMailChimpID='your list ID goes here' "

tony

my php code is:


<?php print "before; perch_mailchimp_form<br><br>"; PerchUtil::output_debug(); perch_mailchimp_form('forms/subscribe'); print "after; perch_mailchimp_form<br><br>"; PerchUtil::output_debug(); ?>

In the template, subscribe.html, I added the listID

the listID i got from perch/mailchimp/lists

<perch:input type="hidden" id="list" value="479f78bbd4" mailer="list" />

but the new subscriber did not show up. in perch or mailchimp.com

debug:

Debug Message - Perch 3.0.8
[29] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_mailchimp_lists WHERE listMailChimpID='479f78bbd4' LIMIT 1
Subscribing to: Michaela Mitoi Hair & Beauty Salon
Using template: /templates/mailchimp/forms/subscribe.html

tony

look into perch database table perch3_mailchimp_subscribers the new subscriber is there, but does not display in perch cms or mailchimp

all new subscribers are set as 'pending' in table perch3_mailchimp_subscriptions

and are not added to mail chimp.com

it doesn't sent email to verify email.

Drew McLellan

Drew McLellan 2638 points
Perch Support

How often is your task scheduler running?

Hi Drew,

how can I set this up, to sent emails to new subscribers. after they submit form for double-opsin, email verfication.

many thanks

tony

Drew McLellan

Drew McLellan 2638 points
Perch Support

How often is your task scheduler running? If it's not running you'll have problems with this.

I have run the scheduler using URL method.

in perch/scheduled tasks

FAILED perch_mailchimp import_data Unknown. 17 Jul 2017 13:02:42 1s

tony

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, do you get any errors in your error log?