Campaign keeps sending emails every day

💬 General Discussion
1

Hello,

I’ve setup a campaign with suitecrm v7.1.3, and sent successfully around a 1000 messages.
However I have about 90 of them stuck in the message queue,
and our customers keep receiving them every day… :frowning:

  1. How do I stop messages from being sent? How do I empty the message queue?

  2. I found those errors in the log:


Fri Jun 12 00:00:19 2015 [8003][c734b0e0-9c96-3bf0-7370-5568ad70fd97][FATAL] Error inserting into table: emails_text: Query Failed: INSERT INTO emails_text (email_id,from_addr,reply_to_addr,to_addrs,cc_addrs,bcc_addrs,description,description_html,deleted)
                                        VALUES ('a1ffa495-bb2c-460f-88d9-5568e818bd78','RTDA_Mailer <mailer@rtda.com>','','','','','Dear $contact_name,\r\n \r\n \r\n \r\n \r\nBest Regards,\r\n \r\n \r\n','\n<p>Dear $coname,</p>\n<p> </p>\n<p>Please join us for our  20th Anniversary Celebration at DAC 2015, Booth #1227 on Tuesd June 9th at 5:30PM.</p>\n<p> </p>\n<p><img src=\"http://www.rtda.com/wp-content/uploads/2015/05/20th-Anniversay-Invitation.png\" alt=\"20th Anniversary Invite\" width=\"815\" height=\"566\" /> </p>\n<p> </p>\n<p>Best Regds,</p>\n<p> </p>\n<p>RTDA Team</p>\n<p><a href=\"%7B20Anniversary%7D\"> Unsubscribe Me </a></p>\n',0): MySQL eror 1062: Duplicate entry 'a1ffa495-bb2c-460f-88d9-5568e818bd78' for key 'PRIMARY'
Fri Jun 12 00:00:19 2015 [8003][c734b0e0-9c96-3bf0-7370-5568ad70fd97][FATAL] Job bf98f822-e152-384c-7252-557a837b1cb3 (Run Nightly Mass Email Campaigns) failed in CRON run
Fri Jun 12 00:00:43 2015 [8025][c734b0e0-9c96-3bf0-7370-5568ad70fd97][FATAL] Error inserting into table: emails_text: Query Failed: INSERT INTO emails_text (email_id,from_addr,reply_to_addr,to_addrs,cc_addrs,bcc_addrs,description,description_html,deleted)
                                        VALUES ('a1ffa495-bb2c-460f-88d9-5568e818bd78','RTDA_Mailer <mailer@rtda.com>','','','','','Dear $contact_name,\r\n \r\n \r\n \r\n \r\nBest Regards,\r\n \r\n \r\n','\n<p>Dear $coname,</p>\n<p> </p>\n<p>Please join us for our  20th Anniversary Celebration at DAC 2015, Booth #1227 on Tuesd June 9th at 5:30PM.</p>\n<p> </p>\n<p><img src=\"http://www.rtda.com/wp-content/uploads/2015/05/20th-Anniversay-Invitation.png\" alt=\"20th Anniversary Invite\" width=\"815\" height=\"566\" /> </p>\n<p> </p>\n<p>Best Regds,</p>\n<p> </p>\n<p>RTDA Team</p>\n<p><a href=\"%7B20Anniversary%7D\"> Unsubscribe Me </a></p>\n',0): MySQL eror 1062: Duplicate entry 'a1ffa495-bb2c-460f-88d9-5568e818bd78' for key 'PRIMARY'
Fri Jun 12 00:00:43 2015 [8025][c734b0e0-9c96-3bf0-7370-5568ad70fd97][FATAL] Job 3f37898f-c64e-fa2a-ff80-557a837d28f7 (Run Nightly Mass Email Campaigns) failed in CRON run
Fri Jun 12 00:01:07 2015 [8056][c734b0e0-9c96-3bf0-7370-5568ad70fd97][FATAL] Error inserting into table: emails_text: Query Failed: INSERT INTO emails_text (email_id,from_addr,reply_to_addr,to_addrs,cc_addrs,bcc_addrs,description,description_html,deleted)

why did it happen?

2

You can delete emails from the message queue in Admin -> Campaign Email Queue.

Is the issue that they keep being added after you delete them from this queue?

Thanks,

Will.