Yes, the database is named suitecrm.
After upping the level to debug the SuiteCRM log (attached) contains the following after a call to cron (but no necessarily related to cron):
Fri Jun 16 16:39:54 2017 [16982][1][b][FATAL] SugarPHPMailer encountered an error: An outgoing mail server is not configured to send emails. Please configure an outgoing mail server or select an outgoing mail server for the mail account that you are using in Settings >> Mail Account.[/b]
Fri Jun 16 16:39:54 2017 [16982][1][FATAL] SugarPHPMailer encountered an error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
Fri Jun 16 16:49:44 2017 [17937][1][[b]FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteR/modules is not a file or a dir.[/b]
Fri Jun 16 16:49:44 2017 [17937][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/Suite7/modules is not a file or a dir.
Sun Jun 18 12:03:02 2017 [26236][1][b][DEBUG] SugarBean.load_relationships, Error Loading relationship (assigned_user_id)[/b]
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query:UPDATE job_queue
SET `assigned_user_id`='1',`name`='Process Workflow Tasks',`date_modified`='2017-06-18 11:03:02',`scheduler_id`='53c5567e-1136-3de0-d39b-5943fb40c924',`execute_time`='2017-06-18 11:03:00',`status`='done',`resolution`='success',`message`='Warning [2]:[b] Invalid argument supplied for foreach() in /storage/www/suitecrm/modules/AOW_WorkFlow/AOW_WorkFlow.php on line 124\n',`target`='function::processAOW_Workflow',`data`=NULL,`requeue`=0,`retry_count`=NULL,`failure_count`=NULL,`job_delay`=0,`client`='CRON14b87127b43138534880f2310a66c966:26236',`percent_complete`=NULL
WHERE job_queue.id = '14bd91ef-4a4b-d4f5-dcfa-59465d6970cc' AND deleted=0[/b]
Sun Jun 18 12:03:02 2017 [26236][1][b][DEBUG] SugarBean.load_relationships, Error Loading relationship (aor_scheduled_reports_aor_reports)[/b]
I donāt see any errors about cache.
I could not find a Settings >> Mail Account. to add email configuration into and this error is from a couple of days ago and I assume occurred during the early install. I have email configured in:
Email settings
Inbound email (bounce handler)
Outbound email accounts has a system entry
and the following was found in suitecrm.log regarding schedulers:
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] --------------------------------------------> at cron.php <--------------------------------------------
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Using SugarCronJobs as CRON driver
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query:SELECT id FROM job_queue WHERE status='running' AND date_modified <= '2017-06-17 11:03:02'
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query Execution Time:0.00024890899658203
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] get_full_list: order_by = '' and where = 'schedulers.status='Active' AND NOT EXISTS(SELECT id FROM job_queue WHERE scheduler_id=schedulers.id AND status!='done')'
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] SugarBean[Scheduler].load_relationships, Loading relationship (created_by_link).
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] SugarBean[Scheduler].load_relationships, Loading relationship (modified_user_link).
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list_query: query is SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , 'Users' modified_by_name_mod FROM schedulers LEFT JOIN users jt0 ON jt0.id=schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON schedulers.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where (schedulers.status='Active' AND NOT EXISTS(SELECT id FROM job_queue WHERE scheduler_id=schedulers.id AND status!='done')) AND schedulers.deleted=0
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query: SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , 'Users' modified_by_name_mod FROM schedulers LEFT JOIN users jt0 ON jt0.id=schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON schedulers.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where (schedulers.status='Active' AND NOT EXISTS(SELECT id FROM job_queue WHERE scheduler_id=schedulers.id AND status!='done')) AND schedulers.deleted=0
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query Execution Time:0.00045299530029297
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list_query: result is mysqli_result Object
(
[current_field] => 0
[field_count] => 22
[lengths] =>
[num_rows] => 12
[type] => 0
)
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): id = 53c5567e-1136-3de0-d39b-5943fb40c924
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): name = Process Workflow Tasks
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): job = function::processAOW_Workflow
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): date_time_start = 2015-01-01 13:45:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): job_interval = *::*::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): last_run = 2017-06-18 11:02:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(53c5567e-1136-3de0-d39b-5943fb40c924): catch_up = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): id = 54831814-aba5-1b4a-2dc6-5943fbfd410a
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): name = Run Report Generation Scheduled Tasks
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): job = function::aorRunScheduledReports
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): date_time_start = 2015-01-01 10:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): job_interval = *::*::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): last_run = 2017-06-18 11:02:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(54831814-aba5-1b4a-2dc6-5943fbfd410a): catch_up = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): id = 56cead4e-821e-f618-c5a2-5943fb7be418
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): name = Prune Tracker Tables
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): job = function::trimTracker
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): date_time_start = 2015-01-01 12:30:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): job_interval = 0::2::1::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(56cead4e-821e-f618-c5a2-5943fb7be418): catch_up = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): id = 578fb2eb-1f72-83cb-2c0b-5943fb3177fa
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): name = Check Inbound Mailboxes
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): job = function::pollMonitoredInboxesAOP
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): date_time_start = 2015-01-01 19:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): job_interval = *::*::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): last_run = 2017-06-18 11:02:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(578fb2eb-1f72-83cb-2c0b-5943fb3177fa): catch_up = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): id = 5835a9ad-e7d5-d0fa-e22a-5943fbb58962
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): name = Run Nightly Process Bounced Campaign Emails
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): job = function::pollMonitoredInboxesForBouncedCampaignEmails
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): date_time_start = 2015-01-01 06:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): job_interval = 0::2-6::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): last_run = 2017-06-18 05:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5835a9ad-e7d5-d0fa-e22a-5943fbb58962): catch_up = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): id = 58d9f806-6d43-3ff8-04b6-5943fb992118
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): name = Run Nightly Mass Email Campaigns
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): job = function::runMassEmailCampaign
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): date_time_start = 2015-01-01 19:30:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): job_interval = 0::2-6::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): last_run = 2017-06-18 05:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(58d9f806-6d43-3ff8-04b6-5943fb992118): catch_up = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): id = 59bdefe0-b740-510e-e290-5943fbe50ae7
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): name = Perform Lucene Index
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): job = function::aodIndexUnindexed
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): date_time_start = 2015-01-01 18:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): job_interval = 0::0::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): last_run = 2017-06-17 23:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(59bdefe0-b740-510e-e290-5943fbe50ae7): catch_up = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): id = 5a0ef5b7-475c-ee0d-48bd-5943fb389890
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): name = Optimise AOD Index
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): job = function::aodOptimiseIndex
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): date_time_start = 2015-01-01 09:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): job_interval = 0::*/3::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): last_run = 2017-06-18 11:00:02
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5a0ef5b7-475c-ee0d-48bd-5943fb389890): catch_up = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): id = 5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): name = Run Email Reminder Notifications
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): job = function::sendEmailReminders
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): date_time_start = 2015-01-01 17:30:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): job_interval = *::*::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): last_run = 2017-06-18 11:02:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5ab6ae31-62b8-0bd9-09fe-5943fbc2c3c0): catch_up = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): id = 5b02da69-f50c-596f-a51c-5943fbda2a51
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): name = Clean Jobs Queue
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): job = function::cleanJobQueue
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): date_time_start = 2015-01-01 15:15:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): job_interval = 0::5::*::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): last_run = 2017-06-18 04:00:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b02da69-f50c-596f-a51c-5943fbda2a51): catch_up = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): id = 5b96c12c-690d-2a82-48d4-5943fb52b386
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): name = Removal of documents from filesystem
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): job = function::removeDocumentsFromFS
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): date_time_start = 2015-01-01 13:30:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): job_interval = 0::3::1::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5b96c12c-690d-2a82-48d4-5943fb52b386): catch_up = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): id = 5beded22-0422-b87f-4d57-5943fb74a86b
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): deleted = 0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): date_entered = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): date_modified = 2017-06-16 15:39:18
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): created_by = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): created_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): modified_user_id = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): modified_by_name = gavin
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): name = Prune SuiteCRM Feed Tables
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): job = function::trimSugarFeeds
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): date_time_start = 2015-01-01 09:30:01
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): job_interval = 0::2::1::*::*
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): status = Active
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] process_full_list: Scheduler(5beded22-0422-b87f-4d57-5943fb74a86b): catch_up = 1
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Schedulers::process_record
Sun Jun 18 12:03:02 2017 [26236][1][INFO] -----> Scheduler found [ 12 ] ACTIVE jobs
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->Schedulers->deriveDBDateTimes() got an object of type: Scheduler
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->got * day
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->got * months
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->got * dates
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->got * hours
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->got * mins
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Constraints: start: 2015-01-01 13:45:01 from: 1970-01-01 00:00:00 end: 2017-06-19 11:03:03 to: 2017-06-19 11:03:03 now: 2017-06-18 11:03:02
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] ----->Scheduler found valid job (Process Workflow Tasks) for time GMT(2017-06-18 11:03:00)
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Get One: |SELECT id FROM users WHERE id = '1' AND is_admin = 1 AND deleted = 0 AND status = 'Active'|
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Limit Query:SELECT id FROM users WHERE id = '1' AND is_admin = 1 AND deleted = 0 AND status = 'Active' Start: 0 count: 1
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query:SELECT id FROM users WHERE id = '1' AND is_admin = 1 AND deleted = 0 AND status = 'Active' LIMIT 0,1
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query Execution Time:7.1048736572266E-5
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Hook called: Users::before_retrieve
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query Execution Time:5.0067901611328E-5
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query Execution Time:4.1007995605469E-5
Sun Jun 18 12:03:02 2017 [26236][1][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link).
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Sun Jun 18 12:03:02 2017 [26236][1][INFO] Query Execution Time:4.8160552978516E-5