BUG ??? - Not all newsletter are sended $mail_status overwritten

Hi, We sended our first Newsletter to our client target, that was about 5000 unit. We are using a Business google account (i.e. Google app for business) to send the email: smtp.google.com with an account.

After a while I saw in Campaign statistics that all the Newsletter was sended, after 2/3 week only 800 newsletter was readed. Checking the tbl_s_newsletter_queue in db I saw that in the first 2000 newsletter there is the 800 read date compiled. Forward the first 2000, the read dates are always 0000-00-00 0000000: quite strange for prabability laws (but not for Murphy laws).

I didn't have the logger on, but I suppose that could was the smtp server that raise some error after a countinuos mailing. So checking the sourcecode to find some error code management I find around line 995 in Newsletter.php that the $mail_status is always overwritten with 1 (meaning no error). WHY????

cp

Hi tebby, I commented the line and rescheduled the Newsletter by updating fields in db and it works.
I also activated the logging for FATAL error and I also saw that there are some SMTP error. Checking it with Google support they says that there is a limitation of 2000 mail send in a day for each account, includi the business account.

So now I have to test this possibility:

1- tuning the parameters in Newsletter.php to send max 2000 mail a day
2- setting up a local smtp on the server.

When done I'll update the post to help other user having the same problem.

Thank you

cp

SOLUTION:

for the possibility previously written:

1- Setup in Newsletter.php
$no_email_processed_by_schedule=1999
$interval_between_blocks_email_delivery=86400
Schedule the newsletter sending at 00:01. But I hope that Tebby or some developer could confirm this settings.

2- Setup a local smtp
I choose this one. I installed on ubuntu 12.04 Postfix
help.ubuntu.com/community/Postfix
if you want to enable port 465 for ssl/tls decomment in /etc/postfix/master.cf the line starting by smtpds
Create a Linux user that you'll use to autenticate with smtp (i.e. newsletter)
In modules/Newsletter.php at line 134 update the $smtp_config
var $smtp_config = array(
'enable'=>TRUE, // true o false
'server'=>'ssl://localhost:465',
'server_username'=>'newsletter@yourdomain',
'server_password'=>'yourpassword',
'smtp_auth'=>'true', //valori: 'true' o 'false' (string)
);

In modules/Emails/mail.php at line 60 add the line
$mail->Hostname = 'localhost';
to overwrite the hostname used in ehlo.

cp