rendered paste bodyFri 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)