Not all mass emails are being sent

[ianobetz]

We have about 300 people in a target list. We have setup the email campaign, selected the correct target list, selected the email template, added the date, etc. At the finish screen, we schedule the email, then I go to the Admin and send out the Email Queue. Aftet about a minute, the screen finishes and shows twenty nine number ones in a row: 11111111111111111111111111111

The campaign then reports that 28 emails have been sent (when it should have been closer to 300). It wasn't a bug in that send cause we tried it a second time and it did it again.

Any suggestions for fixing this?

[kbrill]

A little more info would be needed. Like how many emails is your system configured to send at a time (admin->Campaign Email Settings) and who is your outgoing email provider and do they have any restrictions? Are there any errors in your SugarCRM.log or your php error log files?

[ianobetz]

Log:

Fri Jun 10 17:55:46 2011 [31808][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] Notifications: e-mail successfully sent
Fri Jun 10 20:56:01 2011 [24474][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] SUGAREMAILADDRESS: address did not validate [ ****29Yahoo.com ]
Fri Jun 10 20:56:03 2011 [24474][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] Notifications: e-mail successfully sent
Sat Jun 11 06:34:22 2011 [3712][-none-][FATAL] SECURITY: User authentication for tara failed
Sat Jun 11 06:34:22 2011 [3712][-none-][FATAL] FAILED LOGIN:attempts[1] - tara
Sat Jun 11 06:34:27 2011 [3712][-none-][FATAL] SECURITY: User authentication for tara failed
Sat Jun 11 06:34:27 2011 [3712][-none-][FATAL] FAILED LOGIN:attempts[2] - tara
Sat Jun 11 06:34:32 2011 [3712][-none-][FATAL] SECURITY: User authentication for tara failed
Sat Jun 11 06:34:32 2011 [3712][-none-][FATAL] FAILED LOGIN:attempts[3] - tara
Sat Jun 11 13:29:34 2011 [13671][1][FATAL] Email delivery FAILURE:Array
(
[date_entered] => 2011-06-11 19:25:23
[date_modified] =>
[user_id] => 1
[id] => 1133
[campaign_id] => 151e4b65-626a-48bf-e7c4-4de3e58061bb
[marketing_id] => ab71807f-ee8e-2c45-f908-4df042b7a8eb
[list_id] => 256247a6-7d7f-6069-8c3d-4de3db943775
[send_date_time] => 2011-06-09 05:00:00
[modified_user_id] =>
[in_queue] => 0
[in_queue_date] =>
[send_attempts] => 0
[deleted] => 0
[related_id] => 66cb0f7b-0dd2-3063-e093-4dcdab75a239
[related_type] => Leads
)

Sat Jun 11 14:04:18 2011 [13917][1][FATAL] Email delivery FAILURE:Array
(
[date_entered] => 2011-06-11 20:03:51
[date_modified] =>
[user_id] => 1
[id] => 1460
[campaign_id] => 151e4b65-626a-48bf-e7c4-4de3e58061bb
[marketing_id] => ab71807f-ee8e-2c45-f908-4df042b7a8eb
[list_id] => 256247a6-7d7f-6069-8c3d-4de3db943775
[send_date_time] => 2011-06-09 05:00:00
[modified_user_id] =>
[in_queue] => 0
[in_queue_date] =>
[send_attempts] => 0
[deleted] => 0
[related_id] => 66cb0f7b-0dd2-3063-e093-4dcdab75a239
[related_type] => Leads
)

Sat Jun 11 17:11:24 2011 [13945][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] Notifications: e-mail successfully sent
Sat Jun 11 17:50:54 2011 [13671][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] Notifications: e-mail successfully sent
Sat Jun 11 22:58:47 2011 [13687][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] Notifications: e-mail successfully sent


There are a lot more errors. I will change the batch to be 25 and see if that works.

[kbrill]

Log:

Fri Jun 10 20:56:01 2011 [24474][c8ff05cf-a819-dd9a-48ce-4dc45c7d0695][FATAL] SUGAREMAILADDRESS: address did not validate [ ****29Yahoo.com ]

well that first error seems fairly straight forward.

It might be helpful if you edited

modules/EmailMan/EmailManDelivery.php around line 225 and change

         if(!$emailman->sendEmail($mail,$massemailer_email_copy,$test)){
            $GLOBALS['log']->fatal("Email delivery FAILURE:" . print_r($row,true));
        } else {
            $GLOBALS['log']->debug("Email delivery SUCCESS:" . print_r($row,true));
         }
        if($mail->isError()){
            $GLOBALS['log']->fatal("Email delivery error:" . print_r($row,true). $mail->ErrorInfo);
        } 
  

to

         if(!$emailman->sendEmail($mail,$massemailer_email_copy,$test)){
            $GLOBALS['log']->fatal("Email delivery FAILURE:" . var_export($mail,true));
        } else {
            $GLOBALS['log']->debug("Email delivery SUCCESS:" . var_export($mail,true));
         }
        if($mail->isError()){
            $GLOBALS['log']->fatal("Email delivery error:" . var_export($mail,true). $mail->ErrorInfo);
        } 
  

and see what that gives. Its a change I am thinking about suggesting to engineering to be included in the product.

[ianobetz]

I made the change (line 230 though) and the following error showed up on the Administrator Email Queue when I attempted to send it instead of the 1's but didn't put anything into the log file:

1SugarPHPMailer::__set_state(array( 'oe' => OutboundEmail::__set_state(array( 'db' => MysqliManager::__set_state(array( 'dbType' => 'mysql', 'backendFunctions' => array ( 'free_result' => 'mysqli_free_result', 'close' => 'mysqli_close', 'row_count' => 'mysqli_num_rows', 'affected_row_count' => 'mysqli_affected_rows', ), 'helper' => MysqliHelper::__set_state(array( 'db' => MysqliManager::__set_state(array( 'dbType' => 'mysql', 'backendFunctions' => array ( 'free_result' => 'mysqli_free_result', 'close' => 'mysqli_close', 'row_count' => 'mysqli_num_rows', 'affected_row_count' => 'mysqli_affected_rows', ), 'helper' => MysqliHelper::__set_state(array( 'db' => MysqliManager::__set_state(array( 'dbType' => 'mysql', 'backendFunctions' => array ( 'free_result' => 'mysqli_free_result', 'close' => 'mysqli_close', 'row_count' => 'mysqli_num_rows', 'affected_row_count' => 'mysqli_affected_rows', ), 'helper' => MysqliHelper::__set_state(array( 'db' => MysqliManager::__set_state(array(


I will let the queue run its course and see if I get anything in the log.

[ashdwi1]

Hello,
many possiblities with occurence of this error are:

1. no mass mailing permission at your account at host , please consult your host for same.
2. time execution limits and memory limits of php at server.
extend these 2 limits.
3. crm stops sending mails if send_status and in_process fieids values are 1 in emailman table.
try to set 0 for this values.

please apply above and tell us results.
thanks

[ianobetz]

I changed the batch number to 25, so server limits shouldn't be an issue now. The server is a rackspace cloud, so I'm the administrator. All send_status and in_process fields are 0 for the emails.