PDOException on the content/newsletter tab

I'm seeing the same error message.

After scheduling the newsletter, when I then manually run cron, the above error message ( only difference is the actual vid and nid ) is displayed.

Dawson

Would this patch help ?

I changed

function simplenews_count_spool($nid, $vid, $status = array(SIMPLENEWS_SPOOL_PENDING, SIMPLENEWS_SPOOL_IN_PROGRESS)) {
  $clauses = array();
  $params = array();

  if (!is_array($status)) {
    $status = array($status);
  }

  foreach ($status as $s) {
    $clauses[] = "s.status = $s";
  }

  $query = db_select('simplenews_mail_spool')
    ->condition('nid', $nid)
    ->condition('vid', $vid)
    ->where(implode(' OR ', $clauses));
  return $query->countQuery()->execute()->fetchField();
}

to

function simplenews_count_spool($nid, $vid, $status = array(SIMPLENEWS_SPOOL_PENDING, SIMPLENEWS_SPOOL_IN_PROGRESS)) {
  $clauses = array();
  $params = array();

  if (!is_array($status)) {
    $status = array($status);
  }

  foreach ($status as $s) {
    $clauses[] = "status = $s";
  }

  $query = db_select('simplenews_mail_spool')
    ->condition('nid', $nid)
    ->condition('vid', $vid)
    ->where(implode(' OR ', $clauses));
  return $query->countQuery()->execute()->fetchField();
}

and the error is no longer generated when running cron, but no emails seem to have been sent.
When I go to the newsletter page it still says "this newsletter is pending"

Thanks Simon, hadn't seen your patch before I posted, though I think you've done the same that I did, and as I mentioned the error's gone, but still no emails sent. Though I guess that's a different issue.

Please don't change the status to "fixed" until it's committed (put it instead to "reviewed and tested by the community").
Your luck is, due do the small size of the patch, I just committed it ;-) (see commit).

Same here,

Thanks for the patch but well ... still no email sent.
Do you really guess that's a different issue ?

Subscribe

Subscribe

subscribe

subscribe

This issue is fixed. There was indeed another issue (#1175400: Mails won't send - but testing mails works) regarding the sending, fixed as well.