#1429 - Sync not functioning from Mailchimp
hi Guys,
I'm unable to get the sync to function from mailchimp. the webhook shows this error, despite saying its set-up properly.
SugarChimp Webhook Receiver is setup properly! Notice: Undefined index: type in /home/rbins/public_html/modules/SugarChimp/includes/classes/Mailchimp/Webhooks/Receiver.php on line 19 Notice: Undefined index: data in /home/rbins/public_html/modules/SugarChimp/includes/classes/Mailchimp/Webhooks/Receiver.php on line 20
9 years ago
Hi there, notices in PHP applications aren't uncommon. In your production CRM environment, we recommend you turn off PHP Notices in your php.ini file. This will clear out the notices. You can change the error_reporting to something like this:
error_reporting = E_ALL & ~E_NOTICE
After making the change to your php.ini make sure to restart Apache.
9 years ago
Right however are these notices the cause of the sync not working?
for instance, when I add someone as a subscriber to one of my lists, they have never been imported into sugar or added to a target list. the sync seems to only go one way.
9 years ago
And I have checked the cron job history, it is executing regularly.
9 years ago
The notices won't cause any issues, but to be safe turn them off.
If the sync doesn't seem to be working the first thing to check is the Health Status page on Admin->SugarChimp. See if there are any pending syncs in the queue and if everything else looks good. It may be that your schedulers in SugarCRM aren't set up to run or just haven't ran yet. When you add a subscriber to a synced list in MailChimp it adds it to a queue in Sugar to sync.
If nothing seems to pop up there just email a screenshot of your Health Status page to support@sugarchimp.com.
9 years ago
Nothing shows up in the healthcheck and there is nothing in the queue. I've had the integration for a few weeks now and its never executed an actual sync.
9 years ago
We'll get you set up and running. If things don't work there is always a reason.
Do you happen to have the server behind a firewall where MailChimp can't connect to Sugar? Which direction does the sync work? Sugar to MailChimp or the other way around? Can you try forcing a list resync? https://www.sugaroutfitters.com/docs/SugarChimp/how-to-re-sync-a-list
9 years ago
I'm running 7.18, this maybe the problem. upgrading now.
9 years ago
Let me know how that goes. That could very well be it!
9 years ago
Can't finish the sync, getting a 500 HTTP error. I'm checking the logs now.
9 years ago
I have a pretty long list of logs here since i turned on debug in health status. where should I send it? I don't want to publicly post this.
9 years ago
You can send them to support@sugarchimp.com. It's a holiday week here, so we will try the best we can this week. Next week we may need to set up some time for a screen share to work through any existing issues. Hopefully we can spot something through the logs that will get you running as you should be this week.
9 years ago
Hello, just checking in on this. Have you sent the logs to our support email yet?
Thanks!
9 years ago
Hello, following up on this SugarChimp support case again. Were you able to get things working? I can still take a look at the log if you want to send it over. Thanks!
9 years ago
Hi again, I'd love to help if you still need anything. Either leave a comment or shoot us an email at support@sugarchimp.com.
I'm going to close this case down for now though. Thanks!
9 years ago
Hi Sugarchimp support,
We were able to solve this initial issue but i need to open a new ticket. yesterday the Sugarchimp integration went haywire on our system and started making 5 api calls per second to Mailchimp, which ultimately crashed out Sugarcrm instance due to overloading the server. Sugarchimp mistakenly tried to sync two lists with over 375000 records, which makes no sense because we didn't even have that many records in the system in the first place. Due to this my CTO removed Sugarchimp to restore access to the system for staff.
Any help would be greatly appreciated as right now we will have to cancel the subscription unless we can figure out what happened. It used 10 gbs of bandwidth in less than 3 hours somehow through these API calls.
9 years ago
Hi, I'm not sure exactly what is going on. I'm going to reach out via our support email and ask more questions. Will get this up and running for you soon. Be looking for the email. Thanks!