CiviCRM Community Forums (archive)

Here's the internal CivicSpaceOnDemand instructions for deleting a mail stuck in the queue:

There are three foreign key connected tables.  They must all have the entries with the common mailing_id removed.

First, identify the id in the civicrm_mailing table.  Then remove the rows with mailing_id = civicrm_mailing.id from civicrm

mysql> select id, mailing_id, status from civicrm_mailing_job;

Match id to job_id:

mysql> delete from civicrm_mailing_event_queue where job_id=25;

mysql> delete quick from civicrm_mailing_group where mailing_id=25;
Query OK, 1 row affected (0.00 sec)

mysql> delete quick from civicrm_mailing_job where mailing_id=25;
Query OK, 1 row affected (0.01 sec)

mysql> delete quick from civicrm_mailing where id=25;
Query OK, 1 row affected (0.00 sec)

Comments, updates welcome.

Kieran