Answers.Body: <p>Problem a result of a reminder that has no sending date.  (see attached image) This error results in a syntax error that <strong>prevents all subsequent reminders from being sent</strong>.  Solution is to add date or disable reminder with no date.   (ConfigAndLog error messages show the ID for the reminder that has the error.)</p>
  
  <p>Will report as a bug with recommendation that reminder cannot be saved without a date.
  <a href="https://i.sstatic.net/qgjsk.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/qgjsk.jpg" alt="Reminder with no date"></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-03T23:18:07.843Z
Answers.Text: Did you report this. If you give me a reference I will add my vote for a fix. Very annoying.
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-27T12:08:18.657Z
Answers.LastActivityDate: 2017-10-27T12:08:18.657Z
Answers.UserDisplayName: Dave T
Body: <p>Event scheduled reminder is not executing.  The error log for scheduled jobs shows failure DB syntax error.</p>
  
  <p><a href="https://i.sstatic.net/GqArJ.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/GqArJ.jpg" alt="syntax error message"></a></p>
  
Tags: <civievent><scheduled-reminders><scheduled-job>
Title: Civi Event scheduled reminders error - missing date causes DB syntax error
ThreadText: # Civi Event scheduled reminders error - missing date causes DB syntax error
  
  (Asked by: username_0 on 2017-10-27)
  
  Event scheduled reminder is not executing. The error log for scheduled jobs shows failure DB syntax error.
  
  [![syntax error message](https://i.sstatic.net/GqArJ.jpg)](https://i.sstatic.net/GqArJ.jpg)
  
  **Tags:** civievent, scheduled-reminders, scheduled-job
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-10-27. Score: 3
  
  Problem a result of a reminder that has no sending date. (see attached image) This error results in a syntax error that **prevents all subsequent reminders from being sent**. Solution is to add date or disable reminder with no date. (ConfigAndLog error messages show the ID for the reminder that has the error.)
  
  Will report as a bug with recommendation that reminder cannot be saved without a date.
  [![Reminder with no date](https://i.sstatic.net/qgjsk.jpg)](https://i.sstatic.net/qgjsk.jpg)
  
  > **Comments:**
  > **username_1**: Did you report this. If you give me a reference I will add my vote for a fix. Very annoying.  
  
  ---
  
  