Tracking down email campaing issues, email queue no sending.

[pkubat]

We sent out a email campaign yesterday and about 40 or 95 went out without any issues. Sines then no additional emails have been sent. We are running 6.1

My initial questions is are the logs around sending email? I have looked at sugarcrm.log, but there are not email related errors. I want to make sure that sugar is "sending" then emails.

I have "Send Queue Campaign Email" but they are still in the queue. All the messages show was in process and 1 send attempt.

Other emails from within sugar (test and to contacts) work fine. Also from the OS.

I also changed the campaign email job to run every minute.

Any ideas would be greatly appreciated.

Thanks

[kuske]

The email queue is stopped if there is an email in state inqueue=1.
To restart the email in emailman must be reset to inqueue=0.
The scheduler job must be reset to active.

Be sure that all emails can be sent in the time between two send schedules!
If the next schedule starts and teh schedule before is yet running, the email queue will be stopped and not restart again - as it happened in your case.

[pkubat]

Ok maybe a bug....

SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2010-12-04 17:11:02', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2010-12-03 17:11:02', '%Y-%m-%d %H:%i:%s'))) ORDER BY send_date_time ASC,user_id, list_id LIMIT 0,500

Why is the in_queue_date condition value off by 24hrs, what is it not today? Is there a 24hr hold on messages?

[pkubat]

Thanks Harald.

So I updated the in_queue directly in the db. Is there a UI means to re-release these messages? Or is meant to re-try after 24hrs?

Thanks

[kuske]

Oh, did you set the start date of the campaign in the past?
Only campaigns with start date before now are sent out.
So you can start a campaign in two weeks, send all emails and these emails are really sent in two weeks.

[pkubat]

Yes, the send date was in the past ( by 2 hrs)

We wanted this to go out right away and not in the future. So do the emails only go out in the future and also during night (the job for sending campaign email)?

Is there a good document (more that the admin guide) that explains this?

[kuske]

There were good descriptions of campaign management from synolia (in french) and one of iscon group (in german).

You can set up campaigns to start at any date.
I always set up campaigns starting yesterday and beeing active.
The emails are sent at the times which are set in the scheduler "Run nightly mass email campaigns".
This can be once a night, or every five minutes or anything else...
You should do some experiments to find the best solution for your server and for your provider and the rest of the world.
A SugarCRM server sending thousands of mails in a short time will surely be on a spammer list in the near future...