Details
Description
Reproduced on demo site as well as local 4.2.6 install.
Associated links:
http://forum.civicrm.org/index.php/topic,26444.msg113119.html#msg113119
http://drupal.demo.civicrm.org/civicrm/admin/joblog?jid=8&reset=1
backtrace shows this is the DB query with error:
INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)\nSELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' as entity_table, 2 as action_schedule_id\nFROM civicrm_participant e\nINNER JOIN civicrm_event r ON e.event_id = r.id INNER JOIN civicrm_contact c ON c.id = e.contact_id\nLEFT JOIN civicrm_action_log reminder ON reminder.contact_id = e.contact_id AND\nreminder.entity_id = e.id AND\nreminder.entity_table = 'civicrm_participant' AND\nreminder.action_schedule_id = 2\nWHERE e.status_id IN (1) AND r.is_active = 1 AND c.is_deleted = 0 AND reminder.id IS NULL AND '20121109131925' >= DATE_SUB(r.start_date, INTERVAL 1 week) AND DATE_SUB(20121109131925, INTERVAL 1 DAY ) <= event_start_date [nativecode=1054 ** Unknown column 'event_start_date' in 'where clause']",
from eileen backtrace :"CRM_Core_BAO_ActionSchedule::buildRecipientContacts
line 808 or 952