Skip to content

Instantly share code, notes, and snippets.

@75nineteen

75nineteen/delete_specific_emails_from_queue_history.sql

Last active December 4, 2015 17:05
Show Gist options
  • Save 75nineteen/938c887e0419c19e3ba2 to your computer and use it in GitHub Desktop.
Save 75nineteen/938c887e0419c19e3ba2 to your computer and use it in GitHub Desktop.
Download ZIP
Delete all scheduled emails for a specific email
Raw
delete_specific_emails_from_queue_history.sql
DELETE FROM {$wpdb->prefix}followup_email_orders WHERE email_id=12345 AND is_sent=0
@75nineteen
Copy link
Author

Find your database prefix

  • Replace {$wpdb->prefix} with your prefix for your database.
  • The default is wp_ - can be found in wp-config.php.

Get the email_id

  • Replace the email_id with that of the email you wish to remove.
  • To find this ID, hover over the email name in Follow-up Emails > Scheduled Emails
  • http://domain.com/wp-admin/post.php?post=12345&action=edit
  • email_id is the post=12345
  • is_sent = 0 (only removes the unsent emails)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment