Emails not being sent from campaign test feature

[jpeckham]

Please Help - emails are not being sent when I use the test send feature of SugarCRM.

After an initial struggle getting SugarCRM up and running on Mac OS ....., I have setup an email marketing campaign which I want to test. I've gone through all the right steps, creating campaign with test email list of type Test. Have setup Inbound Mailbox properly and tested the incoming mail account successfully.

I click "Send Test:" on the Campaigns screen, then select the email marketing campaign and click Send. I am then taken to the Status screen.

If I then check the outgoing email queue (Admin -> Outbound Email Queue Management) the email is listed there with these values:

Send Attempts = 1
In Process = Checked

I don't know what "checked" means.

When I check the target email account there has been no email sent - I have double & triple checked the SMTP settings and they are correct for my account. I've tried and tried many times to get the email sent - but nothing is coming out.

I'm using:
SugarCRM version 4.2.0d
MAC OS X ..... 10.4.6
PHP 5.1.4-5
Apache 1.3.33
MySQL 5.0.21

The debug output from running emailmandelivery.php (with mail in the outgoing queue) is:

Sun Jun 11 21:36:42 2006,167 [1949] INFO SugarCRM - Query:SELECT category, name, value FROM config
Sun Jun 11 21:36:42 2006,169 [1949] INFO SugarCRM - Connect:Resource id #158
Sun Jun 11 21:36:42 2006,172 [1949] INFO SugarCRM - Query Execution Time:0.00103
Sun Jun 11 21:36:42 2006,189 [1949] DEBUG SugarCRM - Array
(
[0] => SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2006-06-11 20:36:42', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2006-06-10 20:36:42', '%Y-%m-%d %H:%i:%s'))) ORDER BY campaign_id,user_id, list_id
[1] => 0
[2] => 500
)

Sun Jun 11 21:36:42 2006,192 [1949] DEBUG SugarCRM - Limit Query: SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2006-06-11 20:36:42', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2006-06-10 20:36:42', '%Y-%m-%d %H:%i:%s'))) ORDER BY campaign_id,user_id, list_id Start: 0 count: 500
Sun Jun 11 21:36:42 2006,195 [1949] INFO SugarCRM - Query: SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2006-06-11 20:36:42', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2006-06-10 20:36:42', '%Y-%m-%d %H:%i:%s'))) ORDER BY campaign_id,user_id, list_id LIMIT 0,500
Sun Jun 11 21:36:42 2006,198 [1949] INFO SugarCRM - Query Execution Time:0.001273

I've checked the "emailman" table in the database and there is a row in there.


I've spent some time getting thus far, I'd like to get over the final hurdle and figure out why the heck mail isn't being sent. It would be nice to get SugarCRM to do some CRM!

Thanks for any advice/hints/suggestions anyone can offer.

[jpeckham]

Juat a note - in the Inbound Email Setup guide, it states that Test campaign emails will be sent immediately, whereas regular campaign emails will be scheduled.

Whenever I send test email by using the "Send Test" button, they are being queued as can be seen on the admin Outbound Email Queue panel (but never sent).

Is this the correct behaviour?