CiviCRM Community Forums (archive)

Hi Guys

I've been looking at the events reminder issue with a client and it seems there is a bug in the codebase. I've reproduced the issue in the demo site so its still current.

If you setup an scheduled reminder at event level then run the reminders job the log indicates there is an error

Summary
Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: no such field

This is due to the following line in query

reminder.id IS NULL AND '20120607061443' >= DATE_SUB(r.start_date, INTERVAL 1 day) AND DATE_SUB(20120607061443, INTERVAL 1 DAY ) <= event_start_date

Which is produced by this bit of PHP in the ActionSchedule.php

$startDateClause[] = $operator. "({$now}, INTERVAL 1 DAY ) {$op} " . $actionSchedule->start_action_date;

Earlier on in the method the following is done to correct similar problems - the problem is the field 'event_start_date' doesn't exist

$dateField = str_replace('event_', 'r.', $actionSchedule->start_action_date);

Although I can see whats been done to get round this issue for other sections of the code I'm reluctant to patch this line as I'm not sure what its purpose is and if using the $dateField is the correct solution.

Any help would be appreciated.

Thanks

Thanks Yashodha

Its worth noting that when I was testing I tested setting reminders to be triggered following the end date of the event. This highlighted a problem in 4.1.1 where the code was always appending r.start_date onto the end.

So I would also test the end date cases work as expected.

Filed http://issues.civicrm.org/jira/browse/CRM-10384 for your reference

This will be fixed soon.

-Yashodha