Email Newsletter Campaign Error

[leemoney24]

Everything's been working fine...until all the sudden this error started popping up. The email campaign will let me send one test...but if i delete the test results and try again, i get this error. Now when i try to send to the production group, i get the same error.

Please help...p.s. i'm in the process of restoring the source files for these areas...this has fixed other problems in the past.

1 Query Failed:INSERT into emails set id='e68d17e9-33bb-3938-e16b-46cc60ea4c7a', date_entered='2007-08-22 17:04:49', date_modified='2007-08-22 17:04:49', assigned_user_id='124095bb-a0c4-1757-82a3-44cc3a1e7e81', modified_user_id='124095bb-a0c4-1757-82a3-44cc3a1e7e81', created_by='124095bb-a0c4-1757-82a3-44cc3a1e7e81', name='RBC Weekly eNewsletter: RBC eNewsletter', date_start='2000-01-01', time_start='00:00:00', parent_type='test', parent_id='test', description=null, description_html='


[body of email was in this area ]


', from_addr='newsletter@rivesbaptist.org', to_addrs=null, cc_addrs=null, bcc_addrs=null, to_addrs_ids=null, to_addrs_names=null, to_addrs_emails=null, type='campaign', status='sent', deleted='0'::MySQL error 1062: Duplicate entry 'e68d17e9-33bb-3938-e16b-46cc60ea4c7a' for key 1

[leemoney24]

Hello all,

I found what the problem was. In the ADMIN area, EMAIL Configuration, you cannot have this option turned OFF.
"Keep copies of campaign messages:"

I had turned this option off b/c i didn't want to save the actual email. Turns out if you turn this OFF, email campaigns get royally hosed.

Hope this helps someone.

Leland

[susiewilliams]

Thanks for posting the update to your saga. I've forwarded this thread to our QA group so they are aware of the situation.

[kenkoock]

Dear LeeMoney,

I just encountered the same problem as you... we were creating and firing email campaign ok until just 2 days ago we have the same erroe message as you when we send the emails in queue under admin .. we are using Sugar Open Source Version 4.5.1e (Build 1049). Can you let we know if you have resolve the problem and what is the solution. Thanks in advance.

Best regards,
Ken