Fri Dec 7 15:10:02 2007,181 [5854] INFO SugarCRM - Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Fri Dec 7 15:10:02 2007,183 [5854] INFO SugarCRM - Query Execution Time:0.00059999999999999 Fri Dec 7 15:10:02 2007,188 [5854] INFO SugarCRM - Query:SELECT category, name, value FROM config Fri Dec 7 15:10:02 2007,190 [5854] INFO SugarCRM - Query Execution Time:0.00068699999999999 Fri Dec 7 15:10:02 2007,192 [5854] INFO SugarCRM - Query:SELECT id FROM outbound_email WHERE type = 'system' Fri Dec 7 15:10:02 2007,193 [5854] INFO SugarCRM - Query Execution Time:0.00070400000000001 Fri Dec 7 15:10:02 2007,194 [5854] INFO SugarCRM - Query:SELECT * FROM outbound_email WHERE id = '495d8379-3133-6950-70a8-47510d47da66' Fri Dec 7 15:10:02 2007,195 [5854] INFO SugarCRM - Query Execution Time:0.000696 Fri Dec 7 15:10:02 2007,196 [5854] DEBUG SugarCRM - --------------------------------------------> at cron.php <-------------------------------------------- Fri Dec 7 15:10:02 2007,205 [5854] DEBUG SugarCRM - Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Fri Dec 7 15:10:02 2007,205 [5854] DEBUG SugarCRM - Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1 Fri Dec 7 15:10:02 2007,206 [5854] INFO SugarCRM - Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1 Fri Dec 7 15:10:02 2007,207 [5854] INFO SugarCRM - Query Execution Time:0.00089900000000001 Fri Dec 7 15:10:02 2007,210 [5854] INFO SugarCRM - 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 Fri Dec 7 15:10:02 2007,211 [5854] INFO SugarCRM - Query Execution Time:0.00076399999999999 Fri Dec 7 15:10:02 2007,212 [5854] DEBUG SugarCRM - additional detail query results: Fri Dec 7 15:10:02 2007,213 [5854] INFO SugarCRM - Query:SELECT ea.*, ear.* 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 Fri Dec 7 15:10:02 2007,214 [5854] INFO SugarCRM - Query Execution Time:0.00098599999999999 Fri Dec 7 15:10:02 2007,215 [5854] DEBUG SugarCRM - -----> Scheduler flushing dead jobs Fri Dec 7 15:10:02 2007,216 [5854] INFO SugarCRM - Query: SELECT s.id, s.name FROM schedulers s WHERE s.deleted=0 AND s.status = 'In Progress' Fri Dec 7 15:10:02 2007,217 [5854] INFO SugarCRM - Query Execution Time:0.00073599999999999 Fri Dec 7 15:10:02 2007,218 [5854] INFO SugarCRM - Query:DELETE FROM schedulers_times WHERE date_entered < DATE_FORMAT('2007-12-06 22:10:02', '%Y-%m-%d %H:%i:%s') Fri Dec 7 15:10:02 2007,219 [5854] INFO SugarCRM - Query Execution Time:0.00090800000000002 Fri Dec 7 15:10:02 2007,220 [5854] DEBUG SugarCRM - get_full_list: order_by = '' and where = 'status='Active'' Fri Dec 7 15:10:02 2007,220 [5854] DEBUG SugarCRM - process_full_list_query: query is SELECT schedulers.* FROM schedulers WHERE (status='Active') AND DELETED=0 Fri Dec 7 15:10:02 2007,221 [5854] INFO SugarCRM - Query:SELECT schedulers.* FROM schedulers WHERE (status='Active') AND DELETED=0 Fri Dec 7 15:10:02 2007,222 [5854] INFO SugarCRM - Query Execution Time:0.000781 Fri Dec 7 15:10:02 2007,222 [5854] DEBUG SugarCRM - process_full_list_query: result is mysqli_result Object ( ) Fri Dec 7 15:10:02 2007,224 [5854] DEBUG SugarCRM - Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Fri Dec 7 15:10:02 2007,224 [5854] DEBUG SugarCRM - Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1 Fri Dec 7 15:10:02 2007,225 [5854] INFO SugarCRM - Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1 Fri Dec 7 15:10:02 2007,226 [5854] INFO SugarCRM - Query Execution Time:0.00088100000000002 Fri Dec 7 15:10:02 2007,229 [5854] INFO SugarCRM - 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 Fri Dec 7 15:10:02 2007,230 [5854] INFO SugarCRM - Query Execution Time:0.00076100000000001 Fri Dec 7 15:10:02 2007,231 [5854] DEBUG SugarCRM - additional detail query results: Fri Dec 7 15:10:02 2007,232 [5854] INFO SugarCRM - Query:SELECT ea.*, ear.* 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 Fri Dec 7 15:10:02 2007,233 [5854] INFO SugarCRM - Query Execution Time:0.00096399999999999 Fri Dec 7 15:10:02 2007,234 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): id = 70ce0134-29ea-c8c4-80ba-47510d1b73ec Fri Dec 7 15:10:02 2007,235 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): deleted = 0 Fri Dec 7 15:10:02 2007,235 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): date_entered = 2007-12-01 07:28:26 Fri Dec 7 15:10:02 2007,235 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): date_modified = 2007-12-07 13:00:02 Fri Dec 7 15:10:02 2007,235 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): modified_user_id = 1 Fri Dec 7 15:10:02 2007,236 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): name = Run Nightly Process Bounced Campaign Emails Fri Dec 7 15:10:02 2007,236 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): job = function::pollMonitoredInboxesForBouncedCampaignEmails Fri Dec 7 15:10:02 2007,236 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): date_time_start = 2005-01-01 20:30:00 Fri Dec 7 15:10:02 2007,237 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): date_time_end = 2021-01-01 06:59:00 Fri Dec 7 15:10:02 2007,237 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): job_interval = 0::2-6::*::*::* Fri Dec 7 15:10:02 2007,237 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): last_run = 2007-12-07 13:00:00 Fri Dec 7 15:10:02 2007,238 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): status = Active Fri Dec 7 15:10:02 2007,238 [5854] DEBUG SugarCRM - process_full_list: schedulers(70ce0134-29ea-c8c4-80ba-47510d1b73ec): catch_up = 1 Fri Dec 7 15:10:02 2007,239 [5854] DEBUG SugarCRM - Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Fri Dec 7 15:10:02 2007,240 [5854] DEBUG SugarCRM - Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1 Fri Dec 7 15:10:02 2007,240 [5854] INFO SugarCRM - Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1 Fri Dec 7 15:10:02 2007,242 [5854] INFO SugarCRM - Query Execution Time:0.00087399999999999 Fri Dec 7 15:10:02 2007,244 [5854] INFO SugarCRM - 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 Fri Dec 7 15:10:02 2007,246 [5854] INFO SugarCRM - Query Execution Time:0.000751 Fri Dec 7 15:10:02 2007,246 [5854] DEBUG SugarCRM - additional detail query results: Fri Dec 7 15:10:02 2007,247 [5854] INFO SugarCRM - Query:SELECT ea.*, ear.* 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 Fri Dec 7 15:10:02 2007,249 [5854] INFO SugarCRM - Query Execution Time:0.00099100000000002 Fri Dec 7 15:10:02 2007,250 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): id = a7150136-73c1-15f0-38be-47510d678d02 Fri Dec 7 15:10:02 2007,250 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): deleted = 0 Fri Dec 7 15:10:02 2007,250 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): date_entered = 2007-12-01 07:28:26 Fri Dec 7 15:10:02 2007,251 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): date_modified = 2007-12-07 13:00:02 Fri Dec 7 15:10:02 2007,251 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): modified_user_id = 1 Fri Dec 7 15:10:02 2007,251 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): name = Run Nightly Mass Email Campaigns Fri Dec 7 15:10:02 2007,252 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): job = function::runMassEmailCampaign Fri Dec 7 15:10:02 2007,252 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): date_time_start = 2005-01-01 21:00:00 Fri Dec 7 15:10:02 2007,252 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): date_time_end = 2021-01-01 06:59:00 Fri Dec 7 15:10:02 2007,253 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): job_interval = 0::2-6::*::*::* Fri Dec 7 15:10:02 2007,253 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): last_run = 2007-12-07 13:00:00 Fri Dec 7 15:10:02 2007,253 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): status = Active Fri Dec 7 15:10:02 2007,254 [5854] DEBUG SugarCRM - process_full_list: schedulers(a7150136-73c1-15f0-38be-47510d678d02): catch_up = 1 Fri Dec 7 15:10:02 2007,254 [5854] INFO SugarCRM - -----> Scheduler found [ 2 ] ACTIVE jobs Fri Dec 7 15:10:02 2007,255 [5854] DEBUG SugarCRM - ----->Schedulers->deriveDBDateTimes() got an object of type: schedulers Fri Dec 7 15:10:02 2007,255 [5854] DEBUG SugarCRM - ----->got * day Fri Dec 7 15:10:02 2007,255 [5854] DEBUG SugarCRM - ----->got * months Fri Dec 7 15:10:02 2007,256 [5854] DEBUG SugarCRM - ----->got * dates Fri Dec 7 15:10:02 2007,258 [5854] DEBUG SugarCRM - ----->Scheduler did NOT find valid job (Run Nightly Process Bounced Campaign Emails) for time GMT(2007-12-07 22:10) Fri Dec 7 15:10:02 2007,258 [5854] DEBUG SugarCRM - ----->Schedulers->deriveDBDateTimes() got an object of type: schedulers Fri Dec 7 15:10:02 2007,259 [5854] DEBUG SugarCRM - ----->got * day Fri Dec 7 15:10:02 2007,259 [5854] DEBUG SugarCRM - ----->got * months Fri Dec 7 15:10:02 2007,259 [5854] DEBUG SugarCRM - ----->got * dates Fri Dec 7 15:10:02 2007,262 [5854] DEBUG SugarCRM - ----->Scheduler did NOT find valid job (Run Nightly Mass Email Campaigns) for time GMT(2007-12-07 22:10)