Sending Subscription Manager emails: Notice: FAILED to send Email to all recipients

[SHokuf]

Same problem here. I'll look into this today.

[numinix]

If you open /includes/functions/audience.php and find:

// BEGIN newsletter_subscribe mod 2/2
    if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') &&
       (NEWSONLY_SUBSCRIPTION_ENABLED=='true')) {
       $query_string = "select c.customers_firstname, c.customers_lastname, " . 
                   "s.email_address as customers_email_address from " . TABLE_SUBSCRIBERS . 
                   " as s left join " . TABLE_CUSTOMERS . 
                   " as c on c.customers_id = s.customers_id " .
                   " where email_address = '" . zen_db_input($cust_email_address) . "'" .
                   " and (s.confirmed = 1 or s.customers_id >= 1) ";

    } else {        
        $query_string = "select customers_firstname, customers_lastname, customers_email_address
                              from " . TABLE_CUSTOMERS . "
                              where customers_email_address = '" . zen_db_input($cust_email_address) . "'";
    }
// END newsletter_subscribe mod 2/2 

Try replacing that with:

        $query_string = "select customers_firstname, customers_lastname, customers_email_address
                              from " . TABLE_CUSTOMERS . "
                              where customers_email_address = '" . zen_db_input($cust_email_address) . "'"; 

This will remove the core hack made by the subscription manager module. But I don't see why it needs to make this hack since this part of the code is only executed if the recipient is a single email address. In that case the subscription manager isn't needed at all.

[hamid84]

I am having the same issue. Has anybody found a solution yet?

[hamid84]

Any solution yet?

[vandiermen]

post #12 above is the answer; although I just replaced includes/functions/audience.php with original file and it was fixed for me

[Astarkley]

I just want to make sure I do this correctly. When I get to the area in the includes/functions/audience.php with

// BEGIN newsletter_subscribe mod 2/2
if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') &&
(NEWSONLY_SUBSCRIPTION_ENABLED=='true')) {
$query_string = "select c.customers_firstname, c.customers_lastname, " .
"s.email_address as customers_email_address from " . TABLE_SUBSCRIBERS .
" as s left join " . TABLE_CUSTOMERS .
" as c on c.customers_id = s.customers_id " .
" where email_address = '" . zen_db_input($cust_email_address) . "'" .
" and (s.confirmed = 1 or s.customers_id >= 1) ";

} else {
$query_string = "select customers_firstname, customers_lastname, customers_email_address
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($cust_email_address) . "'";
}
// END newsletter_subscribe mod 2/2

I'm to replace all of it with the code below including the // BEGIN newsletter_subscribe mod 2/2 and // END newsletter_subscribe mod 2/2 ?

$query_string = "select customers_firstname, customers_lastname, customers_email_address
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($cust_email_address) . "'";