SugarChimp

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

Hi Jon,

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

BR, Daniel

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

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

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

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

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"

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

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

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.

Can I set this job manually and how?

BR, Daniel

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

:(

another info

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

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

Hi Jon,

no these files aren´t on my server.

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

BR, Daniel

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

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[&#039;before_delete&#039;] = Array();
$hook_array[&#039;before_delete&#039;][] = Array(50,&#039;SugarChimp&#039;,&#039;modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php&#039;,&#039;SugarChimp_LogicHook&#039;,&#039;PersonBeforeDelete&#039;,);
$hook_array[&#039;before_save&#039;] = Array();
$hook_array[&#039;before_save&#039;][] = Array(50,&#039;SugarChimp&#039;,&#039;modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php&#039;,&#039;SugarChimp_LogicHook&#039;,&#039;PersonUpdateBeforeSave&#039;,);
$hook_array[&#039;after_save&#039;] = Array();
$hook_array[&#039;after_save&#039;][] = Array(50,&#039;SugarChimp&#039;,&#039;modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php&#039;,&#039;SugarChimp_LogicHook&#039;,&#039;PersonUpdateAfterSave&#039;,);
$hook_array[&#039;after_delete&#039;] = Array();
$hook_array[&#039;after_delete&#039;][] = Array(50,&#039;SugarChimp&#039;,&#039;modules/SugarChimp/includes/classes/SugarChimp/LogicHook.php&#039;,&#039;SugarChimp_LogicHook&#039;,&#039;PersonAfterDelete&#039;,);



?>

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

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

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

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

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

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