We have SugarCRM 5.0.0c running on CentOS / Apache / MySQL. When we try to do a email campaign to 12,000 people we are getting the following error in the /var/log/httpd:
[Wed May 21 12:17:35 2008] [error] [client 216.240.30.23] PHP Notice: Undefined variable: btracker in /d2/www/websites/crm.carolinarailhawks.com/website/modules/EmailMan/EmailMan.php on line 703, referer: http://crm.carolinarailhawks.com/ind...n&action=index
[Wed May 21 12:17:55 2008] [error] [client 216.240.30.23] PHP Notice: Undefined variable: btracker in /d2/www/websites/crm.carolinarailhawks.com/website/modules/EmailMan/EmailMan.php on line 683, referer: http://crm.carolinarailhawks.com/ind...n&action=index
[Wed May 21 12:17:55 2008] [error] [client 216.240.30.23] PHP Notice: Undefined variable: btracker in /d2/www/websites/crm.carolinarailhawks.com/website/modules/EmailMan/EmailMan.php on line 703, referer: http://crm.carolinarailhawks.com/ind...n&action=index
[Wed May 21 12:18:15 2008] [error] [client 216.240.30.23] PHP Notice: Undefined variable: btracker in /d2/www/websites/crm.carolinarailhawks.com/website/modules/EmailMan/EmailMan.php on line 683, referer: http://crm.carolinarailhawks.com/ind...n&action=index
[Wed May 21 12:18:15 2008] [error] [client 216.240.30.23] PHP Notice: Undefined variable: btracker in /d2/www/websites/crm.carolinarailhawks.com/website/modules/EmailMan/EmailMan.php on line 703, referer: http://crm.carolinarailhawks.com/ind...n&action=index
The sugarcrm.log shows the following during the same period:
[root@dhi28 website]# tail -f sugarcrm.log
Wed May 21 12:26:01 2008,791 [22224] INFO SugarCRM - Query Execution Time:0.00074799999999997
Wed May 21 12:26:01 2008,798 [22224] INFO SugarCRM - Update schedulers: Update schedulers set deleted='0', date_modified='2008-05-21 16:26:01', created_by=null, name='Check Inbound Mailboxes', job='function:ollMonitoredInboxes', date_time_start='2005-01-01 22:45:00', date_time_end='2021-01-01 04:59:00', job_interval='*::*::*::*::*', time_from=null, time_to=null, last_run='2008-05-21 16:26:00', status='Active', catch_up='0' WHERE ID = 'be9bf8cd-6a30-b71b-9e04-47a66810d1f3'
Wed May 21 12:26:01 2008,798 [22224] INFO SugarCRM - Save: Update schedulers set deleted='0', date_modified='2008-05-21 16:26:01', created_by=null, name='Check Inbound Mailboxes', job='function:ollMonitoredInboxes', date_time_start='2005-01-01 22:45:00', date_time_end='2021-01-01 04:59:00', job_interval='*::*::*::*::*', time_from=null, time_to=null, last_run='2008-05-21 16:26:00', status='Active', catch_up='0' WHERE ID = 'be9bf8cd-6a30-b71b-9e04-47a66810d1f3'
Wed May 21 12:26:01 2008,799 [22224] INFO SugarCRM - Query:Update schedulers set deleted='0', date_modified='2008-05-21 16:26:01', created_by=null, name='Check Inbound Mailboxes', job='function:ollMonitoredInboxes', date_time_start='2005-01-01 22:45:00', date_time_end='2021-01-01 04:59:00', job_interval='*::*::*::*::*', time_from=null, time_to=null, last_run='2008-05-21 16:26:00', status='Active', catch_up='0' WHERE ID = 'be9bf8cd-6a30-b71b-9e04-47a66810d1f3'
Wed May 21 12:26:01 2008,800 [22224] INFO SugarCRM - Query Execution Time:0.00061299999999997
Wed May 21 12:26:01 2008,800 [22224] DEBUG SugarCRM - ----->Scheduler Job completed successfully
Wed May 21 12:26:01 2008,800 [22224] DEBUG SugarCRM - ----->Schedulers->deriveDBDateTimes() got an object of type: schedulers
Wed May 21 12:26:01 2008,800 [22224] DEBUG SugarCRM - ----->got * day
Wed May 21 12:26:01 2008,801 [22224] DEBUG SugarCRM - ----->got * months
Wed May 21 12:26:01 2008,801 [22224] DEBUG SugarCRM - ----->Scheduler did NOT find valid job (Prune Database on 1st of Month) for time GMT(2008-05-21 16:26)
Usually the brower will show "this website cannot display the page" we refresh and select the whole group again and finally everything gets sent out. Any help is appreciated.
Chris


LinkBack URL
About LinkBacks
ollMonitoredInboxes', date_time_start='2005-01-01 22:45:00', date_time_end='2021-01-01 04:59:00', job_interval='*::*::*::*::*', time_from=null, time_to=null, last_run='2008-05-21 16:26:00', status='Active', catch_up='0' WHERE ID = 'be9bf8cd-6a30-b71b-9e04-47a66810d1f3'



Reply With Quote
Bookmarks