This tip is for people using Drupal and a module called Simplenews for maintaining and sending out newsletters to an email list.
There might come a time when you need to stop simplenews from sending newsletters - maybe because of issues with the module or the Drupal site, or you accidentally sent the wrong newsletter to a certain list of users. Whatever the reason, below is a quick way of stopping Simplenews.
Backup your database first. You can use a module called Backup and Migrate to do so.
- Open phpMyAdmin, and look for under your Drupal site's database the simplenews_newsletter table.
Determine the node id of the newsletter you are sending ( going into the edit page would show you the node id on the url ). Look for that node id on the simplenews_newsletter table, and click on the edit button on the left of the row ( pencil icon ).
Change the s_status from 1 ( which means sending ) to either 0 ( unsent ) or 2 ( sent ).
Empty the simplenews_mail_spool table ( this is where all the email addresses and status per message is stored ).
You can use TRUNCATE to do this, as in the code below:
TRUNCATE TABLE simplenews_mail_spool
