Author Topic: send_reminder Cron job failing in 4.2.2. (Read 987 times)

mcgeehon · October 16, 2012, 04:01:52 pm

I upgraded to 4.2.2 hoping that a previous issue with the send_reminder job would be fixed. It seems that no matter how I run the job, I cannot get Civi to send anything.

I attempted to run it using wget and specifying a job, and also directly through the System > Scheduled Jobs page through the 'execute now' link. Here is the result in from the web log (any ideas?):

Code: [Select]

2012-10-16 18:49:12	Scheduled reminders sender	
0
Summary
Finished execution of Scheduled reminders sender with result: Failure, Error message: DB Error: no such field
Details

Parameters parsed (and passed to API method): 
a:1:{s:7:"version";i:3;}

Full message: 
Finished execution of Scheduled reminders sender with result: Failure, Error message: DB Error: no such field
2012-10-16 18:49:12	Scheduled reminders sender	
0
Summary
Starting execution of Scheduled reminders sender
Details

Parameters parsed (and passed to API method): 
a:1:{s:7:"version";i:3;}

Full message: 
Starting execution of Scheduled reminders sender

Nothing appears to be added to the /var/www/sites/default/files/civicrm/ConfigAndLog/*.log files either.

CiviTeacher.com · November 01, 2012, 02:04:57 pm

Can confirm this in 4.2.6.

Debugging and backtrace on. No backtrace appears on Screen, ConfigAndLog nor PHP error log.

I get this though in the Jobs Log.

Quote

0
Summary
Finished execution of Scheduled reminders sender with result: Failure, Error message: DB Error: no such field

0
Summary
Starting execution of Scheduled reminders sender
Details

Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Starting execution of Scheduled reminders sender

Using the API explorer I got this backtrace, the "event_start_date" is the wrong field name.

Quote

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']",

Issue posted: http://issues.civicrm.org/jira/browse/CRM-11258

Yashodha Chaku · November 09, 2012, 11:26:21 pm

This has been fixed for 4.2.7

You can try out the patch here : https://fisheye2.atlassian.com/changelog/CiviCRM?cs=43605

HTH
-Yashodha

mcgeehon · November 28, 2012, 07:23:01 pm

Thanks, tested and working. I now need assistance with message templates, but will open that in a separate thread.

CiviCRM Community Forums (archive)

News:

Author Topic: send_reminder Cron job failing in 4.2.2. (Read 987 times)

mcgeehon

send_reminder Cron job failing in 4.2.2.

CiviTeacher.com

Re: send_reminder Cron job failing in 4.2.2.

Yashodha Chaku

Re: send_reminder Cron job failing in 4.2.2.

mcgeehon

Re: send_reminder Cron job failing in 4.2.2.