Not populating queue

[Limbrey]

I just upgraded from 5.2 to 5.5.1

I had a good configuration in 5.2 for sending email campaigns. But in 5.5.1, I now have a problem. After creating the campaign, I am hitting the "schedule emails" button.

In my previous install, that would populate the email queue. However now, only the first email is going to the queue.

The only other difference, apart from version numbers, is that my current target list is up from ~200 to ~2500.

Any ideas? I am stuck....

[Limbrey]

Digging around in the sugarcrm.log file (INFO level). I can see

Thu Apr 22 12:40:25 2010 [27761][98faf65d-f274-5eac-84da-4bbca7d45732][INFO] Query:INSERT INTO emailman (date_entered, user_id, campaign_id, marketing_id,list_id, related_id, related_type, send_date_time) SELECT '2010-04-22 12:40:25','98faf65d-f274-5eac-84da-4bbca7d45732',plc.campaign_id,'db1a58b6-fd87-1523-4ae7-4bcf1aaac5b6',plp.prospect_list_id, plp.related_id, plp.related_type,'2010-04-22 06:00: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 = '41857ce2-77ea-969c-3fc8-4bcf2fdefdf7' AND plp.deleted=0 AND plc.deleted=0 AND plc.campaign_id='bfb059e5-c2b7-6ed4-bb57-4bc742e8845a'
Thu Apr 22 12:40:25 2010 [27761][98faf65d-f274-5eac-84da-4bbca7d45732][INFO] Query Execution Time:0.000447034835815
Thu Apr 22 12:40:25 2010 [27761][98faf65d-f274-5eac-84da-4bbca7d45732][ERROR] MySQL error 1062: Duplicate entry '0' for key 1
Thu Apr 22 12:40:25 2010 [27761][98faf65d-f274-5eac-84da-4bbca7d45732][INFO] Query:delete from emailman where campaign_id='bfb059e5-c2b7-6ed4-bb57-4bc742e8845a' and marketing_id='db1a58b6-fd87-1523-4ae7-4bcf1aaac5b6' and list_id='e581ff6f-8213-8d42-de6e-4bcf1d427f9d'
Thu Apr 22 12:40:25 2010 [27761][98faf65d-f274-5eac-84da-4bbca7d45732][INFO] Query Execution Time:7.5101852417E-5

I have logged into my MySQL database, and executing the INSERT query results in error #1062 (as above) "duplicate entry '0' for key '1'"

So that's why only 1 entry was being populated.

Examining the emailman table, through examination of the keys (using 'show keys in emailman) I determined that key '1' referred to "id", the primary key. To a MySQL dummie, not overly apparent since most programming languages start counting at '0'

Anyway, I noticed that the 'auto_increment' setting was not switched on. OOOOOOhhhhhh!

So I enabled it. Rescheduled the campaign. And we're good
Don't ask me how many hours I wasted chasing that one.>!

----------
Note, installation was made via Installatron v6.0.9 via cpanel. SugarCRM is version 5.5.1