Total active user: 132,507
There are currently 131,004 unsent emails remaining in the mail queue. After Send Email to Users 8 hours :(

Very useful indeed. Thanks so much!

130,000+ emails is an insane amount to send, and will take an extremely long time unless you use some high settings.

I am a dumbass! I fixed my problem.

Thanks for this!

I just moved to a new hosting company and their limit was only 150 per hour, I got them to increase 750, but still way under my newsletter subscribers.

Will be testing it out today. Thanks again

UPDATED: tested and this hack works perfectly! All my subscribers got their newsletters and they're all happy.

after importing the product, where can i edit the settings ?
im not able to find them on my admin cp, should i edit the product file befor uploading it or what ?

What setting(s) are you referring to ?

Hello Paul,
Thanx for replying, please i need to know a few things:
1- where can i set the number of email sent per hr, is it only by puting the number in the e-mail settings or i need to put it in an other place.
2- how can i remove the e-mails from the queue
thank you

1. Please read the main (first) post, the settings are explained there.

2. You cant, unless you want to run direct sql on the relevant table.

Can anyone explain how to delete unsent emails, as I've sent to the wrong usergroup.

You cannot, unless you use something like phpadmin to actually delete the records from the email queue table.

Can you cover how to do this via mysql please :)

TRUNCATE Mailqueue ;

can i use this on my vb 3.7.1?

I'm asking as it's written in 3.7.x version that it's not supported.

Installing a 3.8 version on 3.7 would not be supported either.

I've vb 3.7.1 and want this mod on my board.
May i know why 3.7.x version isnt supported?
any problems with mod?

for 3.71 try this version https://vborg.vbsupport.ru/showthread.php?t=167274


PROBLEM

Hi, I've come across a problem. I have this installed but when I check my schedule logs, the cron does not appear to have been run. Its set to run every 10 minutes.

Even when I click "run now" from the schedule task manager menu in admincp, it goes to this screen "Process Mail Queue for vBulletin 3.7" but gets stuck there.

Any advice please?

My email unesent queue is growing as none are been sent. Any help or advice would be greatly appreciated thanks Mally

It isnt supported because I only support the 3.8 versions of my mods (as I only run 3.8).

There are no known issues with the 3.7 version.

If you dont get an error message then there isnt much i can tell you - it sounds like your server is unable to send mail. Have you tried this in the diagnostics ?

JFYI, Im about to go on holiday, so I may not actually see your reply until the end of next week.

tagged

Hope you enjoy your holidays!

I'm pulling my hair out now, I am able to send emails via the diagnostic test email, also, the standard emails are being sent out (like password reminder, new member etc)

Any suggestions please, your help is appreciated

Just wondering if there is any way to test this module?
I see that there is a 'test' selection on the send email to user, but no ideas if that tests this module?

Allan

Great mod! Been using this since last year on 3.7...Upgraded to 3.8 and forgot to upgrade to the newest version...OOPS! Hope my ISP doesn't catch my email blast of many thousands of emails this morning.

**INSTALLED!!!**...and upgraded...

So awesome this works fine =] Thanks
*installed /nominated

Any Ideas on how to test this? If I select a thousand members, and hit send, I dont want to actually send mail to 1000 members, before making sure this works.

Sorry, there is nothing else i can suggest, it would need server access to start tracing what your server is (or isnt) doing.

Hi Paul,

I've been getting frequent database errors that reference "mailqueue":
These are just 2 that came in this morning. There have been at least 2 each day. I submitted a support ticket to my server techs (ServInt VPS) and it was suggested that it isn't a MySQL server error:
I may be able to run a query with more guidance. I thought I'd check with you first and if there is a specific query I should run, you could guide me.

Thanks.

Its very much a MySQL error - MySQL server has gone away is a bit of a give away ;)

It means that the mysql connection has closed, almost certainly because its timed out - suggesting that MYSQL on your server has a very low timeout setting (Wait Timeout).

That's what I thought and discussed that with them several days ago. Different tech. I'll ask for the other techie and see if it can be resolved. Thanks for your response.

For testing I have modified email.php to put the To address to a dedicated account
and modified the message body to add the address it would have gone to.
This way I can run some samples and validate everything, the timings etc.

Call me stupid but i cant figure out hwo to drop the cron timing from once every 10m to once every 1m ?

Help?

Update - Never mind, found it under Schedule Task Manager

Solved my issue.......I had the batch up to high.

Awesome Mod.

Thankyou

vbulletin uses the mailqueue for many things (like subscriptions) not just one off mailouts.

Deleted

Was having issues, but it's working perfectly on a 3.8.4 PL1

EDIT: NVM had to truncate the mailqueue

Love this plugin. Maybe im missing something but i tired playing around with it and had no luck.

If i wanted to send 250 emails per hour untill all the users have been emailed, what setting will i need to use?

Thanks in advance

50 per batch would be 300 an hour, 40 would be 240.

Hi Paul,
I was trying to install it, but I am not finding the text to place the commands you place on your txt file to make it work.

I have 3.8.4 PL1

Can you give me a hand on know where do I need to place the code on the files?

Thanks.

I think I got it.
Let you know how it works.

This mod work in vb4 beta 4 too?

Tried now on vb4 beta 4 seems that work :)