Answers.Body: <p>If you'll notice (as per your Google Doc you posted), the last <code>VALUE</code> that the query is trying to insert is <code>( 1668, , 3537, null, '78ed5224ae6ab7d9' )</code>.  The second argument is missing, and therefore the Query is invalid.</p>
  
  <p>Double check if Contact with ID <code>3537</code> has an email address associated with it.  I don't know why Civi wouldn't catch this error, but that seems to be the issue.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-15T14:10:47.963Z
Answers.Text: Thank you Brad, that was it! Really appreciate your assistance :)
Answers.UserDisplayName: Robin Fenwick
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-15T19:38:20.123Z
Answers.Text: Perhaps the email address was deleted for that contact record after the mailing was queued? Would be good to think about why that might have happened.
Answers.UserDisplayName: lcdservices
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-16T16:23:35.137Z
Answers.Text: @lcdservices I think that is exactly what happened - the contact in question had left her company, and our team dealt with that by deleting her email address from her record.  We are retraining the team!
Answers.UserDisplayName: Robin Fenwick
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-15T13:24:02.613Z
Answers.LastActivityDate: 2016-04-15T13:24:02.613Z
Answers.UserDisplayName: Brad Xanti
Body: <p>Since upgrading to 4.7.6 we have two CiviMail bulk emails with the status "Running" that have not actually been sent.  In the scheduled jobs log there is this message:</p>
  
  <blockquote>
    <p>Finished execution of Send Scheduled Mailings with result: Failure,
    Error message: DB Error: syntax error </p>
    
    <p>Parameters parsed (and passed to API method): 
    a:1:{s:7:"version";i:3;}</p>
    
    <p>Full message:  Finished execution of Send Scheduled Mailings with
    result: Failure, Error message: DB Error: syntax error</p>
  </blockquote>
  
  <p>In ConfigAndLog The <a href="https://docs.google.com/document/d/1KR1HNi6tYjYaays4X97nTnTP3fLqROhDaDKPAI9kgSU/edit?usp=sharing" rel="nofollow">full error is shown here</a>, but I'm struggling to locate the actual fault / corrective action.  Any help greatfully received.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-04-15T11:58:10.237Z
Comments.Text: Yes, there are CiviCRM-specific logs that will shed more light on the error. The location is different based on what CMS you are using. Can you update your description to include whether you are running Joomla, Drupal, or WordPress?
Comments.UserDisplayName: lcdservices
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-04-15T12:12:55.297Z
Comments.Text: Thanks, have updated to show it is Drupal 7 and have found a fuller error in ConfigAndLog, which I have put in the updated post above :)
Comments.UserDisplayName: Robin Fenwick
Tags: <civimail>
Title: CiviMail not sending mails in 4.7.6 / Drupal 7 "DB Error: syntax error"
ThreadText: # CiviMail not sending mails in 4.7.6 / Drupal 7 "DB Error: syntax error"
  
  (Asked by: username_0 on 2016-04-15)
  
  Since upgrading to 4.7.6 we have two CiviMail bulk emails with the status "Running" that have not actually been sent. In the scheduled jobs log there is this message:
  
  > Finished execution of Send Scheduled Mailings with result: Failure,
  > Error message: DB Error: syntax error
  >
  > Parameters parsed (and passed to API method):
  > a:1:{s:7:"version";i:3;}
  >
  > Full message: Finished execution of Send Scheduled Mailings with
  > result: Failure, Error message: DB Error: syntax error
  
  In ConfigAndLog The [full error is shown here](https://docs.google.com/document/d/1KR1HNi6tYjYaays4X97nTnTP3fLqROhDaDKPAI9kgSU/edit?usp=sharing), but I'm struggling to locate the actual fault / corrective action. Any help greatfully received.
  
  **Tags:** civimail
  
  > **Comments:**
  > **username_1**: Yes, there are CiviCRM-specific logs that will shed more light on the error. The location is different based on what CMS you are using. Can you update your description to include whether you are running Joomla, Drupal, or WordPress?  
  > **username_0**: Thanks, have updated to show it is Drupal 7 and have found a fuller error in ConfigAndLog, which I have put in the updated post above :)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-04-15. Score: 3 | Accepted answer
  
  If you'll notice (as per your Google Doc you posted), the last `VALUE` that the query is trying to insert is `( 1668, , 3537, null, '78ed5224ae6ab7d9' )`. The second argument is missing, and therefore the Query is invalid.
  
  Double check if Contact with ID `3537` has an email address associated with it. I don't know why Civi wouldn't catch this error, but that seems to be the issue.
  
  > **Comments:**
  > **username_0**: Thank you username_2, that was it! Really appreciate your assistance :)  
  > **username_1**: Perhaps the email address was deleted for that contact record after the mailing was queued? Would be good to think about why that might have happened.  
  > **username_0**: @username_1 I think that is exactly what happened - the contact in question had left her company, and our team dealt with that by deleting her email address from her record.  We are retraining the team!  
  
  ---
  
  