Suspended by our host for sending bulk emails

[ashoor]

So we got suspended twice today for trying to mass-message our close to 10K members, as it exceeded the acceptable threshold per hour (I had no idea)

the question is: how do I suspend this operation? It seems like the forum has queues up the rest and is trying to send it, and that is causing the host to suspend us after earlier lifting the suspension.

can I go back to the control panel and cancel this operation?

 

[Chromaniac]

https://xenforo.com/community/threads/how-to-delete-emails-queue.160344/post-1322230 indicates that there is a table in the database. i do have a xf_mail_queue table which is empty... but somehow it's size is 263MB so that's quite amusing.

 

[ashoor]

thank you, will look into that​

I did some research and ended up disabling the option below. But I know the moment I re-enable it, the system will end trying to send the rest of emails and my host will suspend my account again. Any way around it​

​

Edit cron entry: Process email bounces​

 

[Chromaniac]

it seems that purging that table should fix the issue for you. the content should give you an indication as i assume it should show a lot of entries of mails that are queued for sending. do take a backup though in case no one else responds to this thread!

 

[Mouth]

can I go back to the control panel and cancel this operation?

Put $config['enableMailQueue'] = false; into your src/config.php file.
Ref: https://xenforo.com/xf2-docs/manual/config/#enablemailqueue

And then you can sort out what to do with the big send of emails queued, likely a DB action as per @Chromaniac

 

[ashoor]

it seems that purging that table should fix the issue for you. the content should give you an indication as i assume it should show a lot of entries of mails that are queued for sending. do take a backup though in case no one else responds to this thread!

thank a lot. Correct, it has close to 9000+ entries which closely matches how many emails would have gone out.

do i empty or drop that table ? Am assuming empty?

 

[Chromaniac]

empty! drop would delete the table and from my experience xenforo cannot create tables on the fly! (do take backup!) i once picked the wrong option and deleted the xf_oembed table...

 

[Mouth]

Am assuming empty?

truncate xf_mail_queue;

 

[dknife]

I'd recommend something like Amazon SES for sending email from XenForo. It's very cheap and takes care of DKIM.