Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#655 - sync problem with sugarcrm
Hi, i cannot sync a mailchimp list in Sugarcrm anymore :
I've created a new list in mailchimp and sync to sugar : the list is created in sugarcrm.
when i 'added new subscription in the mailchimp list nothing append in sugarcrm.
this is the log from sugarcrm.log :
Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: Instantiate SugarChimp_Scheduler Driver SugarChimp_Scheduler_MailchimpToSugarCRM Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver::start Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver->start_timer timer started at 1405348501 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver->start_timer elapsed time is empty Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver::start License is good. Run it! Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Original Start time 1405348501 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Current time 1405348501 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Time since last check 0 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Elapsed time 0 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Time used 0 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_MailchimpToSugarCRM->run Running... Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Original Start time 1405348501 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Current time 1405348501 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Time since last check 0 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Elapsed time 0 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver Time used 0 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_MailchimpToSugar->get_next_mailchimp_list_id get oldest job: SELECT mailchimp_list_id FROM sugarchimp_mc ORDER BY date_entered ASC LIMIT 0,1 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_MailchimpToSugarCRM->run mailchim_list_id: 042844ac22 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:error:1405348501: SugarChimp_Scheduler_MailchimpToSugarCRM->run There are no target lists for mailchimp list id: 042844ac22 Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:debug:1405348501: SugarChimp_Scheduler_Driver::end Mon Jul 14 14:35:01 2014 [17137][1][FATAL] SugarChimp:fatal:1405348501: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => There are no target lists that match the mailchimp list id: 042844ac22 )
Mon Jul 14 14:35:02 2014 [17137][1][FATAL] Job 7332873f-c780-2531-07a5-53c3eac4bb8b (SugarChimp) failed in CRON run
thank you in advance for help
-
"SugarChimp is working great. We're able to sync all of our lists and subscriber fields between MailChimp and SugarCRM. SugarChimp Support also did a great job supporting us as we were setting everything up."
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
9 years ago
Hi Stephane, sorry for the issue.
I would first recommend installing the latest version of SugarChimp 7.0.12 over your current version and trying again. You can find it by going to your purchases on SugarOutfitters in the top-right corner. Simply install the new version through module loader and do not uninstall the old version. There were some changes made around this functionality for your Sugar version.
After you install the new version, follow these steps to re-sync your list: https://www.sugaroutfitters.com/docs/SugarChimp/force-a-list-re-sync
If that doesn't clear it up, let me know and we can schedule a screenshare to sort it all out.
Thanks!
9 years ago
Hi,
thank you for the info
i have installed last version of the plugin without uninstall the old version. and resync the list ( i have created a new one and add subscribers "contacts" type) but no contact are push to sugar new contact or existing contact.)
thank you for your help
9 years ago
I see in our logs that your site_url in your config is listed as 'localhost'. Are you running this Sugar instance from a local instance?
For SugarChimp to work properly, the MailChimp servers will need access to your Sugar instance.
9 years ago
Hi, this is options from config.php from crm instance the CRM are from a web server.
'site_url' => 'http://crm.test.educaloi.qc.ca/', 'sugar_version' => '6.5.8', 'host_name' => 'educaloi.qc.ca',
and the last sugar log
Tue Jul 15 14:06:01 2014 [7009][1][FATAL] Job 2bd95b2d-8a9a-ba5d-6644-53c53524c0cc (Run Nightly Process Bounced Campaign Emails) failed in CRON run Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: Instantiate SugarChimp_Scheduler Driver SugarChimp_Scheduler_MailchimpToSugarCRM Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver::start Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver->start_timer timer started at 1405433222 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver->start_timer elapsed time is empty Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver::start License is good. Run it! Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Original Start time 1405433222 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Current time 1405433222 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Time since last check 0 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Time used 0 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_MailchimpToSugarCRM->run Running... Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Original Start time 1405433222 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Current time 1405433222 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Time since last check 0 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver Time used 0 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_MailchimpToSugar->get_next_mailchimp_list_id get oldest job: SELECT mailchimp_list_id FROM sugarchimp_mc ORDER BY date_entered ASC LIMIT 0,1 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_MailchimpToSugarCRM->run mailchim_list_id: 042844ac22 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:error:1405433222: SugarChimp_Scheduler_MailchimpToSugarCRM->run There are no target lists for mailchimp list id: 042844ac22 Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Scheduler_Driver::end Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:fatal:1405433222: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => There are no target lists that match the mailchimp list id: 042844ac22 )
Tue Jul 15 14:07:02 2014 [7033][1][FATAL] SugarChimp:debug:1405433222: SugarChimp_Helper::get_error_email_address found email in settings: plamothe@solutionsmetrix.com Tue Jul 15 14:07:02 2014 [7033][1][FATAL] Job d544317b-9ab9-8432-c396-53c535d3776b (SugarChimp) failed in CRON run Tue Jul 15 14:08:01 2014 [7069][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini! Tue Jul 15 14:08:01 2014 [7069][1][FATAL] Job 2ee600c3-e737-89f4-012f-53c535539e02 (Run Nightly Process Bounced Campaign Emails) failed in CRON run Tue Jul 15 14:09:02 2014 [7082][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini! Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: Instantiate SugarChimp_Scheduler Driver SugarChimp_Scheduler_MailchimpToSugarCRM Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver::start Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver->start_timer timer started at 1405433342 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver->start_timer elapsed time is empty Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver::start License is good. Run it! Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Original Start time 1405433342 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Current time 1405433342 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Time since last check 0 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Time used 0 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_MailchimpToSugarCRM->run Running... Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Original Start time 1405433342 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Current time 1405433342 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Time since last check 0 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver Time used 0 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_MailchimpToSugar->get_next_mailchimp_list_id get oldest job: SELECT mailchimp_list_id FROM sugarchimp_mc ORDER BY date_entered ASC LIMIT 0,1 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_MailchimpToSugarCRM->run mailchim_list_id: 042844ac22 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:error:1405433342: SugarChimp_Scheduler_MailchimpToSugarCRM->run There are no target lists for mailchimp list id: 042844ac22 Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:debug:1405433342: SugarChimp_Scheduler_Driver::end Tue Jul 15 14:09:02 2014 [7082][1][FATAL] SugarChimp:fatal:1405433342: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array
thank you in advance
9 years ago
Thanks for the clarification. It looks like what's happening is that you have old data in the queue that is trying to be processed, but since the data in the queue is from a Sugar Target List that is no longer synced, it won't send that data to MailChimp. I can tell this because of the error "There are no target lists that match the mailchimp list id: 042844ac22".
Try this: In your Sugar instance, go to http://crm.test.educaloi.qc.ca/index.php?module=SugarChimp&action=admin and click the 'empty table' button. Go to http://crm.test.educaloi.qc.ca/index.php?module=SugarChimp&action=adminmc and do the same thing. This will clear the queue completely. Then try forcing a re-sync one more time using these instructions: https://www.sugaroutfitters.com/docs/SugarChimp/force-a-list-re-sync
I appreciate your help on this issue. If this doesn't work we'll schedule a screenshare so I can look at your system. Thanks!
9 years ago
The links are not displayed properly, but the link looks correct when you click on them.
To be clear, here are the places you should go to in your system:
index.php?module=SugarChimp&action=admin index.php?module=SugarChimp&action=adminmc
9 years ago
Hi,
thank you for your help its working now after yours steps.
9 years ago
Great to hear! Thanks for the follow up!