XF 2.1 How to delete emails queue

[Biarritz64]

How can I delete all emails in queue and is it safe?
Thank you

 

[Biarritz64]

Any idea ?

 

[Mike]

It would require manual database changes (to empty the table in question), though I'm unsure why you would want to do that -- emails shouldn't really be in that table for long.

Note that we don't really recommend/support manual DB edits. We always recommend that you take a backup before trying any manual change.

 

[Joe Blow]

Hi, I urgently need to know how to purge the email queue database table. Can someone assist?

I have opened a support ticket about associated matters, but I need to do this urgently.

 

[Ozzy47]

Run this query:
truncate xf_mail_queue;

 

[Joe Blow]

Run this query:
truncate xf_mail_queue;

Thanks! I got Jon at support on the ticket now so hopefully he'll be able to sort it out for me.

 

[Littlebigdunc]

Run this query:
truncate xf_mail_queue;

thanks for this i had 16gb of stuck emails , worked a treat