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

#3615 - SugarChimp does not sync to MailChimp

Closed Installation created by licence a year ago

Hi SugarChimp-Team,

the hole installation worked "perfect". The module can see the list in sugar and in mailchimp. So I think sugarchimo can connct to mailchimp. But it dies not sync a sample list of contacts to mailchimp.
I looked into the sceduler and the only thing I see where a problem can be is, there is no entry in a field where I have to enter a URL (after I clicked on edit).

my sugarCRM instance:
SugarCRM Professional, Version 7.9.2.0 (Build 1090) - onpremise

my SugarChimp
MailChimp Connection: yes
SugarChimp Version: 7.11.0a
SugarChimp Edition: ultimate

Last Ran: Has not run yet
Interval: alle5Minuten
Scheduler Status: Active view scheduler
Your Webhook URL: https://mydomain.com/index.php?module=SugarChimp&entryPoint=SugarChimpWebhook

Any ideas?

Best Regards from Munich Germany,
Daniel

  1. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello Daniel,

    I believe you've got the right idea and most everything is working and connected as expected. The problem here is that your Sugar Scheduler is not running. Schedulers are your automated, behind the scenes processes that run in SugarCRM. They need to be setup as a cron job on your server. Whoever administers your SugarCRM should be able to help you get your schedulers working.

    Let me know if you have any questions getting the schedulers up and running for SugarCRM. If you believe other schedulers are running but not SugarChimp, we can look into why that might be as well.

    Kind Regards,
    Jon

  2. licence member avatar

    licence

    a year ago

    Hi Jon,

    other schedulers are running since four years :P. I guess this is not the problem.
    Any other ideas?

    BR,
    Daniel

  3. licence member avatar

    licence

    a year ago

    Here from the sugarcrm.log

    Wed Mar 21 16:40:43 2018 [13621][1][FATAL] Job 21be4ef6-2d1e-11e8-a4c9-00505691b617 (SmartList) failed in CRON run
    Wed Mar 21 16:40:43 2018 [13621][1][FATAL] Job 21cb534e-2d1e-11e8-8f07-00505691b617 (SugarChimp) failed in CRON run
    
  4. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Alright, thanks for sharing this. Since our schedulers are failing in the CRON run, we can usually get an idea of what is happening directly from the job_queue table in Sugar. If you have access to this, you can look at the messages from the sugarchimp job failures directly from the table. Let me know if you need any help finding those. If they are not helpful, then we could look to see if we can find any errors on the php/apache logs as well.

    Let me know what you find.

    Thanks,
    Jon

  5. licence member avatar

    licence

    a year ago

    php_error.log

    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMC in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCPeople in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCCampaign in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCList in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCCleanedEmail in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpOptoutTracker in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:11:56 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCActivity in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 09:13:09 Europe/Berlin] PHP Notice:  Undefined index: SugarOutfitters_SugarChimp in /var/www/modules/SugarChimp/license/OutfittersLicense.php on line 454
    [21-Mar-2018 09:13:09 Europe/Berlin] PHP Notice:  Undefined index: SugarOutfitters_SugarChimp in /var/www/modules/SugarChimp/license/OutfittersLicense.php on line 454
    [21-Mar-2018 09:15:10 Europe/Berlin] PHP Notice:  Undefined index: contact in /var/www/modules/SugarChimp/includes/classes/SugarChimp/List.php on line 342
    [21-Mar-2018 09:15:10 Europe/Berlin] PHP Notice:  Undefined index: campaign_defaults in /var/www/modules/SugarChimp/includes/classes/SugarChimp/List.php on line 342
    [21-Mar-2018 09:16:41 Europe/Berlin] PHP Notice:  Undefined index: type in /var/www/modules/SugarChimp/includes/classes/Mailchimp/Webhooks/Receiver.php on line 54
    [21-Mar-2018 09:16:41 Europe/Berlin] PHP Notice:  Undefined index: data in /var/www/modules/SugarChimp/includes/classes/Mailchimp/Webhooks/Receiver.php on line 55
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMC in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCPeople in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCCampaign in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCList in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCCleanedEmail in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpOptoutTracker in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    [21-Mar-2018 16:44:16 Europe/Berlin] PHP Notice:  Undefined index: SugarChimpMCActivity in /var/www/modules/ModuleBuilder/parsers/MetaDataFiles.php on line 1106
    
  6. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Nothing worth noting in the PHP logs. Were you able to look at the job_queue table to see if any error messages are displaying there? These forums are public, so you might want to send any other logs over to the support@sugarchimp.com email and I can check them from there.

    Thanks,
    Jon

  7. licence member avatar

    licence

    a year ago

    Hi Jon,

    at the job_queue table I can only find a"all" the other job. But there is nothing in there about SugarChimp.

    Here you can see the config from the crons. I still miss sthe "URL" Bildschirmfoto 2018-03-21 um 17.26.33.png

  8. licence member avatar

    licence

    a year ago

    Stop Stop I was wrong.

    job_queue:

    mysql> select name, date_entered, date_modified, execute_time, status, resolution, message from job_queue where name='SugarChimp';
    +------------+---------------------+---------------------+---------------------+--------+------------+------------------------------------------+
    | name       | date_entered        | date_modified       | execute_time        | status | resolution | message                                  |
    +------------+---------------------+---------------------+---------------------+--------+------------+------------------------------------------+
    | SugarChimp | 2018-03-21 15:32:01 | 2018-03-21 15:32:01 | 2018-03-21 15:32:01 | done   | failure    | Kann Funktion SugarChimp nicht aufrufen
     |
    | SugarChimp | 2018-03-21 13:16:01 | 2018-03-21 13:16:01 | 2018-03-21 13:16:01 | done   | failure    | Kann Funktion SugarChimp nicht aufrufen
     |
    | SugarChimp | 2018-03-21 11:00:01 | 2018-03-21 11:00:01 | 2018-03-21 11:00:01 | done   | failure    | Kann Funktion SugarChimp nicht aufrufen
     |
    | SugarChimp | 2018-03-21 08:44:01 | 2018-03-21 08:45:01 | 2018-03-21 08:44:00 | done   | failure    | Kann Funktion SugarChimp nicht aufrufen
     |
    | SugarChimp | 2018-03-21 16:15:01 | 2018-03-21 16:15:01 | 2018-03-21 16:15:01 | done   | failure    | Kann Funktion SugarChimp nicht aufrufen
     |
    

    cut out


    | | SugarChimp | 2018-03-21 10:24:01 | 2018-03-21 10:24:01 | 2018-03-21 10:24:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 09:41:01 | 2018-03-21 09:41:01 | 2018-03-21 09:41:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 11:57:01 | 2018-03-21 11:57:01 | 2018-03-21 11:57:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 15:39:01 | 2018-03-21 15:39:01 | 2018-03-21 15:39:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 11:07:01 | 2018-03-21 11:07:01 | 2018-03-21 11:07:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 08:51:02 | 2018-03-21 08:51:02 | 2018-03-21 08:51:02 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 14:06:01 | 2018-03-21 14:06:01 | 2018-03-21 14:06:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 11:50:01 | 2018-03-21 11:50:01 | 2018-03-21 11:50:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 09:34:01 | 2018-03-21 09:34:01 | 2018-03-21 09:34:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 13:23:01 | 2018-03-21 13:23:01 | 2018-03-21 13:23:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 12:33:01 | 2018-03-21 12:33:01 | 2018-03-21 12:33:01 | done | failure | Kann Funktion SugarChimp nicht aufrufen | | SugarChimp | 2018-03-21 16:22:02 | 2018-03-21 16:22:02 | 2018-03-21 16:22:02 | done | failure | Kann Funktion SugarChimp nicht aufrufen | +------------+---------------------+---------------------+---------------------+--------+------------+------------------------------------------+ 499 rows in set (0.30 sec)

    The translation for "Kann Funktion SugarChimp nicht aufrufen" is something like "can not call function SugarChimp". But I don´t think this means a php/function

  9. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello,

    I think we may have found the culprit. Indeed, it is an issue calling the SugarChimp function. Can you change the Scheduler dropdown for Job away from URL and set it to "SugarChimp - send Sugar Updates to MailChimp". This "Job" selection should call function::SugarChimp(). The Smartlist scheduler needs to be changed in the same way, except to the "SugarChimp - SmartList" Job.

    I do not know why this has happened, as they should have defaulted to the correct functions originally. If you are not able to find those jobs, then we may have an installation issue where the SugarChimp did not get added correctly. Let me know.

    Thanks,
    Jon

  10. licence member avatar

    licence

    a year ago

    Good Morning Jon,

    and thats the problem. There is no job called "SugarChimp - send Sugar Updates to MailChimp". This was one of my first views.
    Bildschirmfoto 2018-03-22 um 08.54.52.png

    Can I set this job manually and how?

    BR,
    Daniel

  11. licence member avatar

    licence

    a year ago

    ...and the same is for the "SmartList".

    :(

  12. licence member avatar

    licence

    a year ago

    another info

    like you can see, if I am not in an edit-modus there is a function::SugarChimp

    Bildschirmfoto 2018-03-22 um 15.28.32.png

  13. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Can you look to see if there are files called SugarChimp.php and SmartList.php in custom/Extension/modules/Schedulers/Ext/ScheduledTasks? This is where the files that contain the SugarChimp and SmartList functions should be. If they are not there, then we need to try to reinstall SugarChimp, perhaps doing an uninstall and reinstall will work.

    Let me know what you find.

    Thanks,
    Jon

  14. licence member avatar

    licence

    a year ago

    Hi Jon,

    no these files aren´t on my server.

    Bildschirmfoto 2018-03-23 um 09.33.44.png

    I deinstalled and reinstalled the module but with no success. Can I copy manually?

    BR,
    Daniel

  15. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello Daniel,

    We can certainly copy those files over manually, however I worry that there may be issues with other pieces of the installation that have failed since this piece will not install correctly. Lets check another file that should have been updated during our installation in Sugar. If it is here, then I say we manually add the missing scheduler files and see what we get. Otherwise, we need to work on server permissions or php/apache settings because files in multiple locations are missing.

    We add lines to the custom/modules/Contacts/logic_hooks.php file. If this file is on your server, can you copy its content and paste it here to see if our SugarChimp Logic Hooks were installed for the Contacts module?

    If that looks good, then I'll email you the proper files for the scheduled tasks.

    Thanks,
    Jon

  16. daniel.hess member avatar

    daniel.hess

    a year ago

    Hi Jon,

    logic_hooks.php in custom/modules/Contacts/

    <?php
    // Do not store anything in this file that is not part of the array or the hook version.  This file will
    // be automatically rebuilt in the future.
     $hook_version = 1;
    $hook_array = Array();
    // position, file, function
    $hook_array['before_delete'] = Array();
    $hook_array['before_delete'][] = Array(50,'SugarChimp','modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php','SugarChimp_LogicHook','PersonBeforeDelete',);
    $hook_array['before_save'] = Array();
    $hook_array['before_save'][] = Array(50,'SugarChimp','modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php','SugarChimp_LogicHook','PersonUpdateBeforeSave',);
    $hook_array['after_save'] = Array();
    $hook_array['after_save'][] = Array(50,'SugarChimp','modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php','SugarChimp_LogicHook','PersonUpdateAfterSave',);
    $hook_array['after_delete'] = Array();
    $hook_array['after_delete'][] = Array(50,'SugarChimp','modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php','SugarChimp_LogicHook','PersonAfterDelete',);
    
    
    
    ?>
    
  17. daniel.hess member avatar

    daniel.hess

    a year ago

    I copied the both files into custom/Extension/modules/Schedulers/Ext/ScheduledTasks and did a quick repair...

    did not helped. the job can not be in the list of scheduled tasks...

  18. fanatical_jon member avatar

    Jon S Provider

    a year ago

    It could be an issue with the language file not being correct to show the job in the dropdown option. Either way, I think it would be best to schedule a call for early next week so that we can look at Sugar together. Can you find a time to do this here: https://calendly.com/fanaticallabs/sugarchimp-support

    I look forward to getting things cleared up.

    Kind Regards,
    Jon

  19. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello there,

    Were you able to schedule a call for us to look at things together? Are there any updates to your current situation?

    Thanks,
    Jon

  20. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello Daniel,

    I am going to update this support case here for notes on what we found on the call:

    Your SugarChimp/SmartList schedulers are failing because Sugar is "Unable to find function SugarChimp". The other custom scheduler workflow job is working just fine. We are having problems creating/deleting files on the server with the appropriate permissions. However, even after manually adding the correct files to custom/Extension/ we are still not able to get the scheduler working. (checked custom/modules/Schedulers/Ext/Scheduledtasks/ to be sure it is populated with the correct data, and it is). We also ensured the language files are populated correctly, and they are.

    I will get back to you early next week with any updates to see if we can get your scheduler working correctly. Thanks for your patience as we get this figured out.

    Kind Regards,
    Jon

  21. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    11 months ago

    Hello Daniel,

    I'm going to add to the case what we found on our last call again:

    We ran: php -f custom/modules/Schedulers/Ext/Scheduledtasks/scheduledtasks.ext.php

    That let us know that we were unable to reach the SmartList directory (failed to open stream). Checking permissions, custom directories have the setgid ('s') on them, even after running the proper chmod scripts. We then copied the data over to reset permissions without the 's', and got past that issue. Continuing down this troubleshooting path, we got stuck because the custom/include/Fanatical/Loader.php file uses a built-in Sugar function "get_custom_file_if_exists()" while fails. Our custom directory is unable to see open the built-in include/utils.php for Sugar.

    As we got off the call, you are going to look into the issue more to see if you can fix the permissions problems. If not, we will look to schedule another call next week with more things to try.

    Thanks,
    Jon

  22. fanatical_jon member avatar

    Jon S Provider

    9 months ago

    Hello Daniel,

    I'm going to go ahead and close this case out. If you are still having issues or have more questions, you can respond to this case or create a new one.

    Kind Regards,
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

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.