Answers.Body: <p>I found the issue.  One of the scheduled reminders had a date and a conditional parameter in it which CIVI could not handle.  Everything back in working order.  Thanks for your help.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-13T23:50:19.383Z
Answers.LastActivityDate: 2023-10-13T23:50:19.383Z
Answers.UserDisplayName: Margaret
Body: <p>This CRON job worked well for a long time and all of a sudden stopped working.  No database changes were made.  Here is the setup of the job and the result.  Any ideas would be appreciated.</p>
  <p><a href="https://i.sstatic.net/1jpdw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/1jpdw.png" alt="enter image description here" /></a></p>
  <p>Entity: Job Action: send_reminder
  Summary
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error
  Details</p>
  <p>Parameters parsed (and passed to API method):
  a:1:{s:7:&quot;version&quot;;i:3;}</p>
  <p>Full message:
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-10T12:39:52.820Z
Comments.Text: I'm guessing this happened after you upgraded CiviCRM? What version did you upgrade to?
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-10T18:33:40.883Z
Comments.Text: Sounds likely to be a message template that worked fine on an earlier version but doesn't any more because of the way Smarty is handled. If you check the logs for the scheduled job, you should get info on which particular message couldn't be sent and it should give a line number (look for curly braces ({}) that aren't used for Smarty, often CSS).
Comments.UserDisplayName: Lars SG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-10T19:35:44.700Z
Comments.Text: @Coleman 6,  I did not upgrade.
Comments.UserDisplayName: Margaret
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-10T19:46:15.113Z
Comments.Text: @Lars SG This is what is in the log of the scheduled reminders job.   Not sure how to read that message.
  Send Scheduled Reminders 
  Entity: Job Action: send_reminder
  Summary
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error
  Details
  Parameters parsed (and passed to API method): 
  a:1:{s:7:"version";i:3;}
  Full message: 
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error
Comments.UserDisplayName: Margaret
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-12T22:42:35.957Z
Comments.Text: Sounds like a different problem then. Which version are you using?
Comments.UserDisplayName: Lars SG
Tags: <cron><scheduled-reminders>
Title: Cron Job for Scheduled Reminders Failing
ThreadText: # Cron Job for Scheduled Reminders Failing
  
  (Asked by: username_0 on 2023-10-10)
  
  This CRON job worked well for a long time and all of a sudden stopped working. No database changes were made. Here is the setup of the job and the result. Any ideas would be appreciated.
  
  [![enter image description here](https://i.sstatic.net/1jpdw.png)](https://i.sstatic.net/1jpdw.png)
  
  Entity: Job Action: send\_reminder
  Summary
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error
  Details
  
  Parameters parsed (and passed to API method):
  a:1:{s:7:"version";i:3;}
  
  Full message:
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error
  
  **Tags:** cron, scheduled-reminders
  
  > **Comments:**
  > **username_1**: I'm guessing this happened after you upgraded CiviCRM? What version did you upgrade to?  
  > **username_2**: Sounds likely to be a message template that worked fine on an earlier version but doesn't any more because of the way Smarty is handled. If you check the logs for the scheduled job, you should get info on which particular message couldn't be sent and it should give a line number (look for curly braces ({}) that aren't used for Smarty, often CSS).  
  > **username_0**: @username_1 6,  I did not upgrade.  
  > **username_0**: @username_2 This is what is in the log of the scheduled reminders job.   Not sure how to read that message. Send Scheduled Reminders  Entity: Job Action: send_reminder Summary Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error Details Parameters parsed (and passed to API method):  a:1:{s:7:"version";i:3;} Full message:  Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error  
  > **username_2**: Sounds like a different problem then. Which version are you using?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2023-10-13. Score: 2
  
  I found the issue. One of the scheduled reminders had a date and a conditional parameter in it which CIVI could not handle. Everything back in working order. Thanks for your help.
  
  
  ---
  
  