Same command as this to clear email queue for Membership Pro 2 & Subscribe by Email?

Hi,

This works perfectly for eNewsletter stuck emails in queue (phpMyAdmin):

https://premium.wpmudev.org/forums/topic/how-to-remove-e-newsletter-cron-waiting-list#post-834053

What similar can be done for clearing email queue for Membership Pro 2 & Subscribe by Email?

:slight_smile:

  • Tyler Postle

    Hey Greg,

    It involves a bit more complex query with Membership 2. You'll need to run this one:

    UPDATE wp_postmeta
    SET meta_value = 'a:0:{}'
    WHERE meta_key = 'queue'
    AND EXISTS ( SELECT 1 FROM wp_posts WHERE ID=post_ID AND post_type='ms_communication' );

    That all delete the queue of all pending M2 email types.

    As with any time you make changes to the db, make sure you do a full back up first :slight_smile: you can use our Snapshot plugin if you don't already have a preferred back up method. https://premium.wpmudev.org/project/snapshot/

    As for Subscribe By Email, we actually provide the option to bulk delete pending emails within the plugin. Navigate to:

    Subscriptions > Emails Log > Emails in Queue. There you can bulk select the list and then delete, as seen in my screenshot.

    Hope this helps! Any further questions just let us know.

    All the best,
    Tyler

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.