4

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, but I'm struggling to locate the actual fault / corrective action. Any help greatfully received.

Improve this question
2
  • 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?
    – lcdservices
    Apr 15, 2016 at 11:58
  • 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 :)
    – Robin Fenwick
    Apr 15, 2016 at 12:12

1 Answer 1

Reset to default
3

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.

Improve this answer
3
  • Thank you Brad, that was it! Really appreciate your assistance :)
    – Robin Fenwick
    Apr 15, 2016 at 14:10
  • 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.
    – lcdservices
    Apr 15, 2016 at 19:38
  • @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!
    – Robin Fenwick
    Apr 16, 2016 at 16:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.