by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Cancel at any time!
Free Trial

#655 - sync problem with sugarcrm

Closed Bug? created by stephane 4 years ago

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

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    4 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!

  2. stephane member avatar

    stephane

    4 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

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      4 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.

  3. stephane member avatar

    stephane

    4 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

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      4 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!

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      4 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

  4. stephane member avatar

    stephane

    4 years ago

    Hi,

    thank you for your help its working now after yours steps.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SugarChimp is exactly what we needed, it syncs nicely between MailChimp and Sugar. The added MailChimp dashlet is very sophisticated. Works great – thank you!"

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.