Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-11258

Event scheduled reminders tied to start date not being sent, 'DB Error: no such field'

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.6
    • Fix Version/s: 4.2.7
    • Component/s: CiviEvent
    • Labels:
      None

      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

        Attachments

          Activity

            People

            • Assignee:
              ravish.nair Ravish Nair
              Reporter:
              stoob Stoob
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: