Old email campaigns being sent out randomly

[stro]

I have a fair amount of experience creating and sending email campaigns in sugar, and I am stumped by this one. I have a client that sends out email newsletters monthly. They set up and april newsletter and sent it out. All went fine. Then when they went to set up a follow up email campaign to a new list, new campaign and new email template, the system sent out the old april newsletter instead. Then I went in and set up a new target list with just my email address. I sent the one email and looked in the email queue. There it was just the one email ready to go out. I sent the campaign email and it arrived fine with the correct email template but also the old April newsletter campaign was sent to everyone on the target list made for the monthly newsletters. Any ideas how this might happen? How to fix? Clear the cache, delete & recreate target lists, email templates, campaigns? Any help or insight into the campaign module would be greatly appreciated. Thanks

Greg

[Enable1T.Mike]

Check the emailman table is completely EMPTY after you have sent your campaigns out.
We experienced a similar issue with one of our customers, and it appeared that someone had deleted mails from the queue, thus marking them "deleted = 1" in the emailman table (didnt physically remove them from the table in the way it does when successfully sent).
Sugar didnt seem to take any notice of the "deleted=1" and treated it as live mail, but when it came to remove it from the table, saw the "deleted=1" and left it in the table.

Every time our customer sent out a campaign (having checked the queue was empty first, the "deleted" mails would be sent out as well.

Hope this helps