Hi, I am using SugarCRM 6.02 and I had a problem sending email newsletters. The newsletter was not sent to the contacts in the target list and the log was saying:

Thu Sep 30 10:25:00 2010 [14216][1][INFO] Query:INSERT INTO emailman (date_entered, user_id, campaign_id, marketing_id,list_id, related_id, related_type, send_date_time) SELECT '2010-09-30 08:25:00','1',plc.campaign_id,'688ffcad-1c8a-242b-9e1a-4ca43994a96a',plp.prospect_list_id, plp.related_id, plp.related_type,'2010-09-30 08:24:00' FROM prospect_lists_prospects plp INNER JOIN prospect_list_campaigns plc ON plc.prospect_list_id = plp.prospect_list_id WHERE plp.prospect_list_id = 'e5020c3c-9308-c794-5cd0-4ca438380295' AND plp.deleted=0 AND plc.deleted=0 AND plc.campaign_id='c1400ac3-138c-1168-bc1d-4ca438f26295'
Thu Sep 30 10:25:00 2010 [14216][1][INFO] Query Execution Time:0.000456094741821
Thu Sep 30 10:25:00 2010 [14216][1][ERROR] MySQL error 1062: Duplicate entry '0' for key 1

The same error existed for the tracker table.
I solved this by altering the both tables, so that ID was set to AUTO_INCREMENT.
Now it works, but I am still wondering if this is the right solution and how this bug slipped into my system.

Bas