Cron based e-mail sending

[Paul M]

As of 24 Nov 2017 this modification has been withdrawn.

In default vBulletin, if you send a large number of e-mails, vbulletin either puts them in it's queue and attempts to send them as each user visits a page, or just simply tries to send them straight away (as is the case when you use the Administrators email users inteface).

The result of this can be that your server can gets seriously overloaded very quickly - or on many hosts, you get banned for exceeding their e-mail sending limits. This can make sending several thousand e-mails (like a newsletter) very difficult.

This modification does two things ;

1. The processing of the mail queue is set-up as a vbulletin cron item.

2. Allows you to add a small delay before each e-mail is sent (between 1 and 9 seconds).

3. E-mails from the ACP inteface are sent to the mail queue, not straight to the mail system.

Use option 2 carefully, otherwise you will slow your e-mail system right down.

For this to work, you must turn on e-mail queuing in the ACP options - set 'Use Mailqueue System' to 'Yes', and 'Number of Emails to Send Per Batch' to a realistic value (based on the cron setting, as below).

There are two options for the cron job, you can either set it to run every minute, and set the items to be processed to something small (like 10), or you can do what this modification does by default and set it to run every 10 minutes, and set the items to be processed to something larger (like 100).

Remember, 10 per minute = 600 per hour, 100 per 10 minutes is also 600 per hour. The numbers really depend on how quick you want large queues processed, and how much your mail server can handle in one go.

Once working, when using the ACP mail users inteface, remember you can set it to process 9999 at once (not 500 or whatever) as the mails will now go into the queue, not be sent directly.

Note: This modification will affect any queued e-mails such as subscription e-mails. It will not affect registration e-mails as they bypass queuing anyway.

This modification includes the code by Antivirus (https://vborg.vbsupport.ru/member.php?u=64660) that displays the current size of the mail queue.


History:

v3.8.001 : First Release for vB 3.8.

[Rene Kriest]

Finally I need this addon since my forum is getting more and more members. ;)

[Derek Chai]

The cron isn't working for some reason. I had it set at every minute and now it's at the default every 10 and it isn't running according to the logs. I have about 200k mails in the quene.

[Paul M]

Have you tried to run it manually ?

[RedFoxy]

there is an admin/stats panel for that version?

[Battle_Ring]

Thank you , moved t oa new host and they have a 200 emails per hour limit

[Battle_Ring]

how do we set up the cron for this there is no intructions???

[Derek Chai]

Wait, how does the quene work? I heard you need visitors? What do you mean by manually? If I click run now it says processing etc.

[Battle_Ring]

nevermind i see it already sets it up for you.

[Battle_Ring]

When you send an email shouldnt it send the first batch right then, then the next bath at the tim you input. As of right now it doesnt send any when you first send it waits for the first que time to come around.

Anyway to change that?

[Paul M]

Wait, how does the quene work? I heard you need visitors? What do you mean by manually? If I click run now it says processing etc.
Yes, the vb cron system requires that you actually have people visit your site.

When you send an email shouldnt it send the first batch right then, then the next bath at the tim you input. As of right now it doesnt send any when you first send it waits for the first que time to come around.
Its working correctly, thats what a cron job is, it runs every 10 mins.

[Battle_Ring]

i need mine to run every 1 hours as i can only email 200 times per hour

[Paul M]

No you dont. Please actually read the notes.

[obmob]

i have a 800 limit, but my webhost told me to use a 200 queue per hour, i'll try to set this up, awesome idea, must be part of vb 4.0 :D

[Mr-Mo3ath]

i have a proplem
i have to forums in my server the firs forum its sendeing aotumatic good
the secund forum when i doing send hes not send only manually and i update to 3.8 and the proplem its strel hes not send auto like the first form

[Paul M]

Sorry, not really sure what you are asking.

[Mr-Mo3ath]

for example in admincp the queue its 60000 user its not changed auto only Manuel
But in other site in same server its workinge good and i cheake the confige for email and evry tink

[Mr-Mo3ath]

???

[Sworm]

Hi all, for first, this mod is GREAT.....i've clicked installed!
I'm not expert ,
and i don't understand well the en language,
my forum can send 400 emails in 1 hour , for send 300 mails in 1 hour,
is correct if i go in my AdminCP/Vb Options/Email Options/
and set the Number of emails to send per batch at 5?
Without touch the delay option (set to "0" like default)?

Thats correct?

Please help me.

Thanks

[Paul M]

Set it to 50, not 5.

[Sworm]

Set it to 50, not 5.


Thanks Paul,
only this?

The default number of that option is 10, but when i send (without your hack) i riceive "400 is the max email that i can to send" error,
if i increase this value , i will send more of 400 emails in one hour?

please help me,
without your mod i can't use my newsletter.

[Mr-Mo3ath]

now im uprdage other forum to 3.8.1
and the cron its send auto

please i want send to the information in pm o cheake on this

[Paul M]

Sorry, but I dont really understand either of you.

[Mr-Mo3ath]

Sorry, but I dont really understand either of you.

sair the cron hes now send auto i have to send him Manuel only so i want send to you in privet meesage the login for my forums to cheake on this :)

[almsloob]

thank you.

[obmob]

Ok, finally installed... and i have a question, is it ok to set the Use Mailqueue System as "Yes with locking"? o.o

[Paul M]

If you want, that has no bearing on this mod.

[obmob]

Cool, well, i sent my first newsletter, this is a little site, so i set a really low number to test.

I'll search for the logs. Thanks :D

[obmob]

Hmm... well, i see there is a log as "Process Mail Queue for vBulletin 3.7"

But where cani see the mail queue or any chance to see how many mails were sent on each run? Oo

[bklynjava]

What would the settings look like to send 400 - 450 emails an hour. I was pretty sure I set it right at 75 emails every 10 min.

I tried it and must have done something wrong cause I am currently getting my suspension lifted for sending 1000's of emails.

[joe1989]

I'm sorry I don't really understand how to know what numbers to set the batch and processing times to.... My webhost allows me 100 emails per hour. What should I set everything to???

Thanks, and I'm sorry if this was answered already, I can't decipher some of this computer lingo...i'm no programmer!!

Thanks for a great mod!!

[joe1989]

Also, how do I view the mail queue, and see how many emails are currently queued for sending??

This modification includes the code by Antivirus that displays the current size of the mail queue.

Where? How to access it?

[joe1989]

Also, how do I view the mail queue, and see how many emails are currently queued for sending??


OK i see it in the ACP!! Nevermind!

Awesome Mod!

[obmob]

I'm sorry I don't really understand how to know what numbers to set the batch and processing times to.... My webhost allows me 100 emails per hour. What should I set everything to???

Thanks, and I'm sorry if this was answered already, I can't decipher some of this computer lingo...i'm no programmer!!

Thanks for a great mod!!I think that would be toset the batch around 15

OK i see it in the ACP!! Nevermind!

Awesome Mod!where, where? Oo

Can't figure out where to see it x_x

[joe1989]

After you've installed, it shows up with the quick stats in the admin cp.

If you just installed, you may need to reload the admin cp (by actually hitting reload or logging out and logging back in).

Take a look at my screenshot attached...

[obmob]

OMG! the last place I'd ever search x_x

thanks :D

[transparent]

God, this mod has been needed for way to long! It truly should be a default in VB. Thx a lot for making this Paul!!

[zlos]

Paul
Installed & clicked :)
One thought - maybe short help or some kind of how-to for setting a proper number of mails sent per batch, as this single setting is actually top important for proper batch mailing.

[belal_najjar]

heyy,

how can i start?

like sending 100 msj per hr and then activate it? or wt

[Paul M]

Huh ?

[FRANKTHETANK 2]

ok now i sent a total of 12,000 emails. now it was 11,264 yesterday. now its this? what is wrong here

There are currently 16,380 unsent emails remaining in the mail queue.

[vwdforum]

How do you delete unsent emails still in the queue? I sent a test email to all my members other than just myself boo

[FRANKTHETANK 2]

i like this mod. but i don't like how there is no Vb options settings for it. why not make one like CYB stuff?

[Paul M]

Huh ?

[FRANKTHETANK 2]

Huh ?

your addon sucks as to where to adjust it or change it. cybernetic or CYB's stuff, has a page in vboptions after installed to do adjustments and check it. you need to make one for this

and HUH? doesn't answer questions of why i have 12,000 members and its showing 13,624 in my mail queue? when does it ever send all emails?and does it ever stop? how do i check all this? that's why there should be a template or whatever you call it under vb options in ACP

[FRANKTHETANK 2]

JUST KEEPS GOING UP!LOL

There are currently 13,663 unsent emails remaining in the mail queue.

just now

[Paul M]

Maybe you should just remove it and move on.

[obmob]

HAHA, I was thinking that Paul.

Maybe the batch size is too small or the time delay between emails is not 0.

[FRANKTHETANK 2]

cause i want to use this cause i cant do mass email another way. i would like you to tell me how to fix this. you make mod and cant give me support?

[Paul M]

If you want support then maybe saying it sucks is not the way to go ;)

[belal_najjar]

and HUH? doesn't answer questions


:up::up::up:

its better to delete the support instead of writing huh:rolleyes:!!!!

& i ws wrong by using it & as u said its better to delete it:cool:!

[Bulldog Stang]

Installed!!! Works GREAT!!!

[FRANKTHETANK 2]

If you want support then maybe saying it sucks is not the way to go ;)


well "HUH" wasn't support!

thanks anyways. ill delete and not you your products anymore:mad:

[Paul M]

As you wish, your loss, not mine :)

[obmob]

LOL somehow i was sent back to my elementary school days XD

[Icy]

Though its not a big deal but the Scheduled Task Title still shows Process Mail Queue for vBulletin 3.7 :)

[Paul M]

Oh well, I can live with that for now. Thanks.

[PPUS]

Installed and clicked....

Is this correct:

In ACP email settings:
Number of emails per batch is set to 50
Email send delay: 9 sec
This will blast out 450 mails/hr correct?

And... Once I begin the mail, do I need to keep the window open or will it dump to server cron queue and send regardless of my pc?

Thanks for making this, I will be elated to delete my phplist mailer...

Will re-post back on success of it working.

[Paul M]

You do not need to set the send delay to 9 seconds, generally this is not needed at all, 1 or 2 seconds is good enough if you really want to use it.

[Vinyljunky]

Paul,

Thank you for another quality mod :up:

Regards

VJ

[PPUS]

OK, thanks Paul... so I have it set as:

Number of Emails to Send Per Batch: 50 and the delay at 1 second. Is this the only setting I need? I do not want to exceed 500/hour as I am allowed 600 and the extra 100 is for other functions and email users on the server. I am I correct that there are no settings in the mod/hack, only those in the ACP?

Gotta say I am nervous as a long tail cat in a room of rocking chairs.

[Paul M]

The cron runs 6 times an hour (every 10 minutes), so 50 x 6 = 300 an hour, well under your 500/Hr - you are fine.

[PPUS]

The cron runs 6 times an hour (every 10 minutes), so 50 x 6 = 300 an hour, well under your 500/Hr - you are fine.

Ahh, the light bulb comes on, I did not realize the cron ran 6x per hour. So whatever I put in the field is x6 to give me the hourly send rate. So a quick math lesson for other:

Setting the "Number of Emails to Send Per Batch" to:

50 = 300/hr
60 = 360/hr
70 = 420/hr
80 = 480/hr
90 = 540/hr

Perfect! I got it now, Thanks again Paul.

[tehPARADOX]

I just wanted to stop by to warn you guys:

If you have say over 200,000 emails queued and you decide to upgrade vbulletin, make sure to do the file edits on the new files immediately before uploading it!

I made the noob mistake of uploading a fresh functions.php onto the server. Within seconds, all the emails were sent out, bringing my server to a halt with a load of 1000+.

I didn't know what the heck was going on until I saw exim crash.

[obmob]

Hmm... yeah, editing first might be a wise action :p

[Plasma2002]

Hey Paul,

Ive been using this addon for quite a while now and it has been a lifesaver... but i have a question.

Maybe it has nothing to do with your addon, and its more of a vBulletin thing, but you may know the answer anyways :)


I dont have much traffic on my forums (most the traffic is on the main site), so this becomes a problem when, say, in the middle of the night, i have a newsletter that needs to go out to 8,000 people that doesnt get finished until the next couple weeks.

What i tried to do to remedy this was make my local machine at home just do a simple wget of vBulletin's cron.php file every 5 minutes.

I figured this would be the best solution... but for some reason, when i look at my mailqueue from the adminpanel, it shows that the number of unsent mails never changed when i just hit the cron.php file... but it works fine if i leave a browser on the forums and make it reaload every 60 seconds.

Would you happen to have any idea how i can manually execute the cron and make my emails send out when my forums are empty?


Thanks :)


EDIT: I found out my problem, in case anybody got here by googling. it was in fact my wget script... if you are trying to run your cron's manually, simply make something hit cron.php on your forums.

[Paul M]

Sorry, I dont.

[cellow]

Note: This modification will affect any queued e-mails such as subscription e-mails. It will not affect registration e-mails as they bypass queuing anyway.

All my activation links are queued. My Users are waiting up to 10 minutes for their activation e-mails.

How can i solve this problem?

[Paul M]

As it says, activation e-mails are not queued by vb.

[cellow]

did you test it on your forum? Why my vb queued activation links?
how can i solve this problem?

[Paul M]

I dont need to test it, just look at the registration code.

Activation e-mails (to members) are not queued. All that gets queued is New User Notification e-mails.

There is no problem to solve.

[nohuhu]

Paul M,

russian translation for your must-have mod.

[LAJAURIA]

I can't find where I can change the options in the ACP. :(

[plothook]

Just thought I'd mention:
The scheduled task this product creates is titled "Process Mail Queue for vBulletin 3.7"
The title has no real effect, but it's an easy fix

[Paul M]

Yeah, See posts #56 & #57. :)

[Makaveli007]

i get a parse error in functions.php everytime. i edited EXACTLY as the instructions stated. there are actually two parts in functions.php that has the exec_mail_queue();

one is functions exec_mail_queue() and then further down is exec_mail_queue(); (with an ; at the end)

i changed the one with the ; exactly as the instructions stated and got the parse error. i then tried every possible combination of changing/not changing the two instances of exec_mail_queue(); and got the parse error every time.

am i doing something wrong?

p.s. parse error was on line 944 everytime

[2zoo]

i tried this before and its working perfectly
thanks

[Paul M]

i get a parse error in functions.php everytime. i edited EXACTLY as the instructions stated. there are actually two parts in functions.php that has the exec_mail_queue();

one is functions exec_mail_queue() and then further down is exec_mail_queue(); (with an ; at the end)

i changed the one with the ; exactly as the instructions stated and got the parse error. i then tried every possible combination of changing/not changing the two instances of exec_mail_queue(); and got the parse error every time.

am i doing something wrong?

p.s. parse error was on line 944 everytime

The instructions do not say "Function exec_mail_queue()" they only say "exec_mail_queue()" - this is almost at the end of the file. Changing anything else is likely to cause errors. :)

[marshal_ramdev]

thanks

[thincom2000]

I was getting a MySQL timeout error when sending only - count it - 1 email via a Report Post form. Fixed it by replacing the mail_send plugin. This edit also makes it possible to use this mod with no file edits:
if ($this->registry->options['usemailqueue'] AND get_class($this) == 'vB_Mail')
{
$qmail =& vB_QueueMail::fetch_instance();
$qmail->toemail = $this->toemail;
$qmail->subject = $this->subject;
$qmail->message = $this->message;
$qmail->headers = $this->headers;
$qmail->fromemail = $this->fromemail;
$qmail->delimiter = $this->delimiter;
$qmail->registry = $this->registry;
$qmail->debug = $this->debug;
$qmail->log = $this->log;
$qmail->send();
unset($qmail);

$this->toemail = '';
}
else
{
$delay = intval($vbulletin->options['cmqdelay']);
if ($delay > 0 AND $delay < 10)
{
sleep($delay);
}
}
Also create a plugin at hook global_shutdown with the following code:
$vbulletin->mailqueue = null;

[Limode]

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

[greenspan]

Very useful indeed. Thanks so much!

[Paul M]

Total active user: 132,507
There are currently 131,004 unsent emails remaining in the mail queue. After Send Email to Users 8 hours :(
130,000+ emails is an insane amount to send, and will take an extremely long time unless you use some high settings.

[Griffoneur]

I am a dumbass! I fixed my problem.

[demojames]

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.

[passwords]

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 ?

[Paul M]

What setting(s) are you referring to ?

[passwords]

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

[Paul M]

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.

[vwdforum]

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

[Paul M]

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

[vwdforum]

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 :)

[Paul M]

TRUNCATE Mailqueue ;

[vitrag24]

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.

[Paul M]

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

[vitrag24]

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?

[vwdforum]

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

[Paul M]

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?
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.

[Paul M]

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.

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.

[jkcerda]

tagged

[vwdforum]

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.

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

[alla n1015]

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

[BOWZONE]

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...

[ChopSuey]

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

[alla n1015]

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.

[Paul M]

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

[len backus]

Hi Paul,

I've been getting frequent database errors that reference "mailqueue":
Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE datastore SET
data = data - 49,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, November 7th 2009 @ 07:40:22 AM
Error Date : Saturday, November 7th 2009 @ 07:40:57 AM
Script : http://www.longrangehunting.com/forums/cron.php?rand=1257597618
Referrer : http://www.longrangehunting.com/forums/
IP Address : 173.73.121.35
Username : Unregistered
Classname : vB_Database
MySQL Version :

Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE datastore SET
data = data - 5,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, November 7th 2009 @ 09:00:24 AM
Error Date : Saturday, November 7th 2009 @ 09:00:45 AM
Script : http://www.longrangehunting.com/forums/cron.php?rand=147496
Referrer : http://www.longrangehunting.com/articles/basic-rifle-maintenance-2-3.php
IP Address : 98.125.108.202
Username : Unregistered
Classname : vB_Database
MySQL Version :

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:
This seems to be an SQL error as opposed to a MySQL server error. Check the script or the SQL query you're running. Also, try to run a similar query manually to verify if this is a SQL 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.

[Paul M]

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).

[len backus]

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.

[alla n1015]

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

[Meeper]

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

Awesome Mod.

Thankyou

[Paul M]

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

[demojames]

Deleted

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

[tehPARADOX]

EDIT: NVM had to truncate the mailqueue

[Pumpo]

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

[Paul M]

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

[Reef Man]

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.

[Reef Man]

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

[Sworm]

This mod work in vb4 beta 4 too?

[Sworm]

Tried now on vb4 beta 4 seems that work :)
emailing ok

[Sworm]

No, don't work, the email remain in the mail queue, the're'sany adjustment for work with vb4?

[vitrag24]

If i want to send upto 1000 email per hour, then what to do?

If i send emails to all my users via admincp, they will be queued too or not?

Thanks.

[Paul M]

Read the information provided. :)

[vitrag24]

Read the information provided. :)

I've read. Thanks.

I wanted to ask how many emails will be sent hourly? in admincp it's given to set per batch?

and will it delay sending emails if there are not more than allowed emails in an hour or send as before i installed this mod?

Thanks for gr8 mod.

[vitrag24]

one mroe question:

I've just send announcement via email to all my users [37,000+] using 200 per batch.

i want to know how can i know if and when all users have been emaied?

Thanks.

[Paul M]

Again, read the main post. :)

This modification includes the code by Antivirus that displays the current size of the mail queue.

[tipu sulthan]

what is the use of this mod???

[vitrag24]

Again, read the main post. :)

sorry but i didnt get my answer. I've read thread twice.

I've 2 queries only.

1. After i send email from admincp, how can i know if all emails have been sent and when email to all users have been sent?

2. i've sent 200 per batch, it means 1200 per hour isnt it? just asking to confirm.
and 1200 per hour will be sent instantly and continously if i've set 0 in delay?

Thanks and sorry for inconvenience.

[eatworksleepdie]

It appears to be working perfectly! thank you sir!

I guess I will know for sure in a few if I get some hate mail from Lunarpages forever banning me from using email. haha.

[eatworksleepdie]

to add.. it took me a bit to figure out that the default was set to send the batches every 10 minutes.. and to just goo off of that.. every ten minutes send 50 messages = 300 emails per hour 60 messages in a batch every 10 minutes = 360 emails per hour etc.

very cool feature. thx again.

[eatworksleepdie]

say, I'm not having any luck finding the "Queue" to see where my email message is up to, where's the queue located at in ACP - VB 3.8.1?

[Quads]

The main ACP page when you log in. You'll see it there.

<removed>

1. Mod file(s) as stated in the Cron-Mail-Queue.txt
2. Backup orig. files. Upload edited to appropriate locations. Upload other file needed.
3. Install xml through ACP
4. Configure number of emails per hour:
ACP> VB Options> Email Options>
Find: Use Mailqueue System.
Change to Yes
Find: Number of Emails to Send Per Batch
Set to 50, 60, 70, etc.
**NOTE** Cron job runs every 10 minutes by default / when isntalled. So if you send 50 per batch, 6 times an hour, that would be 300 per hour.
To view the queue, log into your ACP, scroll down past the Notices, and you'll find:
Mailqueue Quick Stats
To view the cron job:
ACP> Scheduled Tasks> Scheduled Task Manager>
where you will find: "Process Mail Queue for vBulletin 3.7"
You can view the cron job, edit / disable, and or manually run the job by clicking the "Run Now" button.

Other than that, it's pretty straight forward.

Regards-
~Q

[vitrag24]

To view the queue, log into your ACP, scroll down past the Notices, and you'll find:
Mailqueue Quick Stats


Thanks a lot.

Atleast someone provided support to this mod.

I'm unable to see mailqueue quick stats past notices in admincp.

can u help to find?

[Quads]

Thanks a lot.

Atleast someone provided support to this mod.

I'm unable to see mailqueue quick stats past notices in admincp.

can u help to find?

Not really sure what you're looking for.
Unless there are emails sitting in the queue, waiting to be sent by the cron job, then it should read: "The mail queue is currently empty."

Is there something else you are looking for? And it's entirely possible that there's something I'm not aware of, due to the expansive documentation on this mod. :o

[Quads]

You can see some other very basic information showing that the script ran by going here:
ACP> Statistics and Logs> Scheduled Task Log> select "Process Mail Queue" from the drop down, and it will give you the entries of the cron job running at its scheduled intervals.

[vitrag24]

Not really sure what you're looking for.
Unless there are emails sitting in the queue, waiting to be sent by the cron job, then it should read: "The mail queue is currently empty."

Is there something else you are looking for? And it's entirely possible that there's something I'm not aware of, due to the expansive documentation on this mod. :o

You've told that "To view the queue, log into your ACP, scroll down past the Notices, and you'll find: Mailqueue Quick Stats"

I'm unable to find that.

[Paul M]

The only way it would not appear is if you havent turned mail queuing on.

[LilleMama]

I wonder if its posible to modify it to start sending mails at night time ( when the server load are low )

[vitrag24]

The only way it would not appear is if you havent turned mail queuing on.

I've enabled mailqueue and it's also showing in logs but not showing any option named mailqueue quick stats in admincp.

[Log on]

Great

[Paul M]

I've enabled mailqueue and it's also showing in logs but not showing any option named mailqueue quick stats in admincp.
Then I have no idea. There is no reason for it not to appear.

[need2fart]

Very nice thank you. I like your hacks.

[need2fart]

Hey Paul does this disable reporting posts in vB?

When I received a vB Database error when a user tried reporting a post I received a problem.

So I tested it myself to see the error, here is what I got.


Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
AND varname = 'reportthanks' AND languageid IN (-1, 0, 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, December 14th 2009 @ 08:53:21 PM
Error Date : Monday, December 14th 2009 @ 08:54:33 PM
Script : http://ds-forums.info/report.php?do=sendemail
Referrer : http://ds-forums.info/report.php?p=255051
IP Address : *.*.*.*
Username : Kyle
Classname : vB_Database
MySQL Version :

Does this hack disable "report post" ?


Thanks!

[Log on]

I don't have mail queue stat in my c panal ?

what is the problem ?

[Paul M]

Hey Paul does this disable reporting posts in vB?
.
.
Does this hack disable "report post" ?

No it doesnt.

Mysql gone away is a timeout error - I would guess you have a very low timeout value and are trying to send too many e-mails in one go.

I don't have mail queue stat in my c panal ?

what is the problem ?
No idea without access to your system.

[need2fart]

No it doesnt.

Mysql gone away is a timeout error - I would guess you have a very low timeout value and are trying to send too many e-mails in one go.


No idea without access to your system.

Alright thanks I'll see if it can be fixed. =)

[Log on]

No idea without access to your system.

what do you mean by accessing my system ??

the problem is clear

I don't have this

https://vborg.vbsupport.ru/attachment.php?attachmentid=94953&d=1234729167

[Paul M]

I know what your problem is, but without admin access to your system I have no idea why, nor anyway of finding out.

[Log on]

I know what your problem is, but without admin access to your system I have no idea why, nor anyway of finding out.

Unfortunately .. my system in Arabic langauge

[Log on]

I solved the problem ...

now if the queue stacked and nothing goes out and the queue increased day by day .. how I can push the mails to go out of the queue?

regards

[Paul M]

You can manually run the cron in your acp as many times as you want.

[TurkeySub]

Very awesome!

Works like a charm!

[Griffoneur]

Will you be supporting v4.0?

I rely on your program for emailing users as I am limited to 400 emails per hour.

[Paul M]

Will you be supporting v4.0?
Yes.

[Griffoneur]

Yes.

That is great. E-mails are a BIG issue with many forums. Your plugin is probably one of the most used on my site.

Looking forward to its release.

Norman

[the stig]

Mr. Paul M,

After installing this mod, members of my forum are complaining that they are NOT

a. receiving any subscription email
b. receiving any pm notificaiton email

what do you think is going on? the number set to 5 btw.

thanks

[Paul M]

what do you think is going on?
I cannot possibly guess at what is happening on your site. :)

[joe1989]

Perhaps he is using 4.0?? The_stig... this mod is not compatible with 4.0 (yet), so if you are running 4.0, you need to disable this mod in the ACP --> Plugins and Products.

Regards,
Joe

[the stig]

I cannot possibly guess at what is happening on your site. :)

I have no clue what's going on :(. My vb software is pretty much stock. Almost no modification done to it. I don't know why it's not working. MEmbers are not receiving any emails whatsoever. I found out today that I'm not receiving "contact us" emails either :(.

Perhaps he is using 4.0?? The_stig... this mod is not compatible with 4.0 (yet), so if you are running 4.0, you need to disable this mod in the ACP --> Plugins and Products.

Regards,
Joe

Hey joe, I have 3.8.4 version.

[Paul M]

Perhaps you need to check your e-mail system, send one from the ACP dianostics page.

[voglermc]

I had this in 3.8 and would love to see it in 4.0! Thanks Paul

[the stig]

Perhaps you need to check your e-mail system, send one from the ACP dianostics page.

I did and the email works. Members are saying that they are receiving pm and thread subscription emails from 2-3 days ago , just NOW!

I am now forced to move to a new VPS server :(.

[the stig]

Paul, is there a way I can remove "contact us' from the bottom of the page?

It's not sending ANY emails from here so I would like to know if I can delete temporarily.

[Sworm]

When we can use your great mod on vb4?

[vitrag24]

I hope this will be updated for vb 4.0 soon.
Thanks.

[Paul M]

It already has :)

[Sworm]

Oh wow,

and where can be downloaded?

I have tried to use 3.8.001 on previous vb4 beta , but the queue is never empty and the emails are not sended..... Do u have released some upgrade?

[Paul M]

Just look in my profile, and you will find it in the vb4 section.

[the stig]

Mr. Paul M,

After installing this mod, members of my forum are complaining that they are NOT

a. receiving any subscription email
b. receiving any pm notificaiton email

what do you think is going on? the number set to 5 btw.

thanks

I have no clue what's going on :(. My vb software is pretty much stock. Almost no modification done to it. I don't know why it's not working. MEmbers are not receiving any emails whatsoever. I found out today that I'm not receiving "contact us" emails either :(.



Hey joe, I have 3.8.4 version.

I cannot possibly guess at what is happening on your site. :)

Perhaps you need to check your e-mail system, send one from the ACP dianostics page.

Paul M, I fixed the problem (vb 3.8.4 ). I put 5 email in the batches instead of 60 or 80. Yesterday I had 33,000 emails in the queue! Well, it's finally going now since I changed the value. It's at 24,000 now thank god. Good modification. Thanks for posting. A MUST have for ALL shared hosting vb owner.

I will say one thing though, EVEN if you turn this modification off, you NO LONGER receive emails directly from vb. I turned the mod off , I still didn't receive any email. Also, you mentioned in original post that registration emails are bypassed. But during the queue, I didn't receive "contact us" email (i'm receiving them now) and new user notification (i'm receiving them now) ..weird

[Paul M]

Turning it off is not sufficient, you also need to reverse the file edits, otherwise you wont get queued emails.

[yoyoman]

Hi, Paul!
Installed and marked.

Next question. I installed the mod on vB 3.8.3 and sent 24 test emails with the batch value set to 10. Waited an hour, but nothing happened.
There are approximately 18 users viewing my forum at the moment. If I send more e-mails, they queue up. In the scheduled tasks it says that the next start is at 3:50, although I sent the e-mails at 4:24. Strange, huh?
If I run the mod manually - it works.

What could be the problem? Need a little tip here.

Kirill

[yoyoman]

In the scheduled tasks I clicked edit, didn't change anything, clicked save and the next start time changed to 06:00. This was at 05:52. But now it's already 06:05 and nothing has happened - neither the queue of emails decreased, nor the next start time changed - it's still at 06:00.

[Paul M]

Sounds like your cron system is not functioning correctly, either its broke, or you dont have enough real visitors to keep it going. When you say 18 users, are they spiders ? - as they will not trigger the cron system.

[Griffoneur]

Skipping over some users?
I have a dummy user account (ID: 260)

I have often noticed that when I send out e-mails (2500 members), my "Dummy Account" does not receive them. It is NOT in the junk e-mail filter. I have even tried using a different e-mail address.

My Dummy User account is set up as a regular forum member. My admin account (ID: 1) gets the e-mails every time. My dummy account will actually get the mass e-mail maybe 1 time in 8 e-mails. What is happening to the other 7?

I am concerned that maybe other "real members" are not getting the e-mails as well. There is no way for me to know who didn't receive it.

Has anyone else ever noticed or reported this?

[Paul M]

This neither knows or cares who e-mails are addressed to, it cannot skip users.

[yoyoman]

Sounds like your cron system is not functioning correctly, either its broke, or you dont have enough real visitors to keep it going. When you say 18 users, are they spiders ? - as they will not trigger the cron system.

Hi. Guess you are right. I got it working yesterday. And you know how?!!
This is just ridiculous!
Quote about CRON jobs from here: http://www.vbulletin.com/forum/showthread.php?135087-Question-about-vBulletin-cron-jobs
The tasks take the form of a 1 x 1 transparent gif image loading on the page. So the page should still load, but it will show as continuing to load until the image / task finishes.

So the Cron jobs have something to do with the 1x1 Spacer.gif, which is loaded to your forum via the header template. And the funny thing is that I replaced this gif with a Christmas hat for the holidays. When I removed the Christmas hat your hack started working.
Very weird. Any comments on this issue?

BTW: I Suggest you add info about the spacer.gif into your manual, so people, who use custom styles check that it's in place. It's kinda impossible to think of it yourself if don't know beforehand.

[Paul M]

I do not work for IB/Jelsoft/vBulletin, I can neither comment on the cron system or have any input to the vbulletin manual.

[yoyoman]

Skipping over some users?
I have a dummy user account (ID: 260)

I have often noticed that when I send out e-mails (2500 members), my "Dummy Account" does not receive them. It is NOT in the junk e-mail filter. I have even tried using a different e-mail address.

...

Has anyone else ever noticed or reported this?

This neither knows or cares who e-mails are addressed to, it cannot skip users.

Actually, I can't agree here, Paul.
I understand, that theoretically, your mod doesn't care what type of user it is mailing, but...
I have three dummy accounts. Before your mod I tested all of them by sending single e-mails. All ok. But I mailed an informer yesterday to all the users and only one of my dummy accounts recieved it (and my admin account). The other two - didn't.
I have a 300/hour qouta, so your parameter was set to 40 - that's 240/hour. So this is ok.
Plus, I checked the server mailbox - no info on undelivered mail to the dummies.

So, what could be the problem here? Can you check, plz.

[Paul M]

Actually, I can't agree here, Paul.
I understand, that theoretically, your mod doesn't care what type of user it is mailing, but...

Well you can disagree if you want, but it wont change the facts. :) This has no bearing on who mail is sent to. Perhaps you are not clear on how this works - what it does is run the vBulletin mail processing code every 10 minutes instead of every page load. That code is standard (untouched) vbulletin code.

So, what could be the problem here? Can you check, plz.
There is nothing I can check, as I said, this mod does not do the mail processing, vbulletin does that, all this does is change how often it runs.

[newmomsforum]

Great Mod , works well. Thanks Paul :)

[viper357]

Quick question Paul, if you don't mind.

I have just upgraded from vb 3.6.12 to vb 3.8.4, I had both yours and antivirus's hacks installed on my 3.6.12 board. Now that I have upgraded please advise if these will be the correct steps to follow for your hack?

1. Uninstall antivurs hack
2. Install current version of your hack without uninstalling the old version?

Thanks.

[Paul M]

I would uninstall both, then install this.

[viper357]

OK, thanks. :)

[yoyoman]

TRUNCATE Mailqueue ;

Hi everybody!
Today I had a problem - accidentally sent the wrong e-mail to all users. Needed to cancel it.
I recommend 3 steps in such situations:
1. admincp->scheduled tasks->uncheck mailqueue
2. admincp->sql query->type in: TRUNCATE TABLE mailqueue;
3. admincp->scheduled tasks->switch mailqueue back on

See you!

[jet rex]

Emails - is a biggest problem in my server.
Thanks !

[Log on]

I couldn't adjusete it to run every min... I don't know whats going on ?

would you tell me please how I can adjuste it

[Paul M]

Why do you want to run it every minute ?

[Log on]

Why do you want to run it every minute ?

coz I want to send from the Q every min 14 messages...

coz my hosting ruls is

1- only 35 recipients per message.
2- only 750 messages per hour.

how I can adjuset it ?!

Please help me


Reagrds

[Paul M]

Edit the cron to run every minute (* in all the time fields).

[krimesis]

Perhaps I misread the whole post but need to send emails to all users?
I tried to load everything and the only difference I noticed was on the email options:
E-Mail Send Delay
The number of seconds delay before sending each e-mail. Note that values greater than 9 seconds will be ignored.
:o

[Paul M]

Im a bit confused, what is your question exactly ?

[krimesis]

I thought to solve the problem I have in sending mass emails to users, because the new server takes a long to send 20,000 emails while in the old party in 45 minutes.

[Aeolian]

possible to make it to work with vb4?
cheers!

[final kaoss]

It seems it isn't handling the daily & weekly digest or is it?

1897 Weekly Digest 00:47, 15th Feb 2010 Weekly Digest Sent
1896 Daily Digest 00:45, 15th Feb 2010 Daily Digest Sent
1895 Process Mail Queue for vBulletin 3.7 00:23, 15th Feb 2010 Processed Mail Queue

[Paul M]

I thought to solve the problem I have in sending mass emails to users, because the new server takes a long to send 20,000 emails while in the old party in 45 minutes.
Sorry but you still dont seem to be actually asking a question.

possible to make it to work with vb4?
cheers!
If you use the vb4 version, then yes.

It seems it isn't handling the daily & weekly digest or is it?

1897 Weekly Digest 00:47, 15th Feb 2010 Weekly Digest Sent
1896 Daily Digest 00:45, 15th Feb 2010 Daily Digest Sent
1895 Process Mail Queue for vBulletin 3.7 00:23, 15th Feb 2010 Processed Mail Queue
What do you mean by "not handling" ? - this has no direct link with Digest cron jobs.

[krimesis]

Paul
In practice I do not solve the problem I have in my server slow email delivery?
Then the general usefulness of the product is something that you may have misunderstood.
Thanks.

[Paul M]

This product is not about the speed your server delivers e-mail, and in fact, by its very nature, it will slow down the rate at which e-mail is sent, not speed it up. I have no idea what the second part of your message is supposed to mean, but I do not misunderstand my own mods. :)

[final kaoss]

Can you add support for the Digest jobs then?

[krimesis]

This product is not about the speed your server delivers e-mail, and in fact, by its very nature, it will slow down the rate at which e-mail is sent, not speed it up. I have no idea what the second part of your message is supposed to mean, but I do not misunderstand my own mods. :)
Ok
Thanks

[Paul M]

Can you add support for the Digest jobs then?
Please explain what you mean by this.

[final kaoss]

Well in your last post you said this. And this makes it sound like the Daily & Weekly digest emails are not being sent out by the mod.



What do you mean by "not handling" ? - this has no direct link with Digest cron jobs.

[Paul M]

As the description says, this handles anything in the vb mail queue.

Do the digest jobs put e-mails in the vb queue ? If they do then this will process them. (I have no idea without digging into their code, but Id be very surprised if they didnt).

[Log on]

Edit the cron to run every minute (* in all the time fields).


I did it .. but still dosen't work every min ?!!!

[Paul M]

It does if youve set it correctly (and you have enough forum activity of course).

[tafreeh]

i made, the file changes instructed in the downloaded file...

and when i click send email i get this


Parse error: syntax error, unexpected '}' in /home/user/public_html/admincp/email.php on line 226
on white page...


However i did upload the xml file, but couldnt find any option in vbulletin option at Admincp

I got more than 36,000 users, and i have to send an important email to everyone.. so i think i need this mod.... in order to prevent getting blacklisted.

Thanks

[Paul M]

i made, the file changes instructed in the downloaded file...

and when i click send email i get this


Parse error: syntax error, unexpected '}' in /home/user/public_html/admincp/email.php on line 226
on white page...

Then you made an error in the edit.

However i did upload the xml file, but couldnt find any option in vbulletin option at Admincp
Where are you looking ?

[tafreeh]

yea:) there was a line missinge from email.php... now its all good. :)

Thanks allot :)

[final kaoss]

I forced the cronjob to send the mail so no, theres no mail in the queue

and /home/vgchat/mail 45 has always been at 45 at hasn't gone up by an increment since test.

K made a test account and

SMTP: mail.vgchat.info:26
SMTP Username: test@vgchat.info

Help
Results
No errors were returned while attempting to send the email. Check avalanch07@gmail.com shortly to confirm you've received the email. If you don't receive the email, try sending the test to a different address. If that fails, check your mail server's configuration.

no mail received though...

EDIT solved.

[vitrag24]

update for vb 4.0?
Thx.

[Paul M]

Just look in my profile.

[tafreeh]

Hey Paul,

Can you make it work with this mod
https://vborg.vbsupport.ru/showthread.php?t=172026&highlight=html+email

Thank you

[TimesOut]

I installed it but I didn't find any option in ACP. From where can I set the options?

[Paul M]

What options exactly ?

[TimesOut]

What options exactly ?

The option which I can turn on Mailqueue System from

[Paul M]

Im afraid you are no longer showing as licensed.

[TimesOut]

Im afraid you are no longer showing as licensed.

I just updated my email ;)

[Paul M]

All e-mail options are in ACP > vBulletin Options > Email Options

[doubleclick]

Helllo -

Any chance this will run on 3.7.3?

Also, does this script still allow me to use smtp instead of sendmail?

thanks

[Paul M]

No need to post this question in multiple threads.

So again .... for vb 3.7, use the 3.7 release. :)

It does not alter what sending method your forum uses.

[pythonimp]

All of my emails are tied up. I don't even get "Contact Us" emails while there is mail in the queue

[serra00]

How do I make send 99 mails per day?
, that are queued to complete the whole list of mails

[Paul M]

99 a day ?

[blackberry]

Hey Paul,

Can you make it work with this mod
https://vborg.vbsupport.ru/showthread.php?t=172026&highlight=html+email

Thank you
it works for this hack

[serra00]

99 a day ?

Can it be configured to send 99 emails a day?

[Paul M]

I expect you could, but not easily, unless you wanted to send them all in one go, once a day.

[matthewhotdude]

Would be perfect if you could select what type of emails go into the mail que. Like newsletter emails that I send out manually to all members in the que...but new registration emails go out instantly

[pythonimp]

Fatal error: Out of memory (allocated 58720256) (tried to allocate 52 bytes) in /home/pythonim/public_html/codspot.com/includes/functions.php on line 4146

that is the error i'm getting? I've never gotten it before now..

[Mum]

Installed and works perfectly :)

[EcoForumZ]

Awesome work thanks a lot.

Not a big deal but in scheduled tasks the title is "Process Mail Queue for vBulletin 3.7" not sure if you wanted this to reference version 3.8 or not.

My hosting is via godaddy and my limit is 800 smtp relays per 24 hours.
With the default scheduled task which run's every 10 minutes I set mine to send out 720 emails per 24 hours.

Here is my config
E-Mail Send Delay = 0
Number of Emails to Send Per Batch = 5

Some calculations to save others time:
60 seconds per minute
600 seconds per 10 minutes
3600 seconds per hour
86400 seconds per 24 hours

scheduled task cron runs every 10 minutes
scheduled task cron per hour = 6
scheduled task cron jobs per 24 hours = 144

I considered changing the scheduled task runs once every 12 hours then set the number of emails per batch to 400, but I think I like the 5 email trickle option a little more that way I will have less odds of being recognized as a spammer.

[BOWZONE]

awesome mod!! Love it....easy to install...directions very clear on how to do it and how it works.
Been using it for a long time and it works great!!

[Paul M]

I considered changing the scheduled task runs once every 12 hours then set the number of emails per batch to 400
You cannot actually set a vb cron to run every 12 hours.

[Inferno Dragon]

i have installed this but in 3.8.5 i can find Options also not listed in Vbulletin options only viewing in Schedule task also not getting any option in Send Email To Users.

Please Tell Me how to setup

[Paul M]

The first post tells you how to set it up.

[Greight]

Hi
-Does this work on vb4?

[Paul M]

No, but the VB4 version does ;)

[Greight]

Oh sorry, I didn't notice that. Thanks for the good work Paul :up:

[ezzeen]

dear sir
does it work on 3.8.6 patch1
because i have tried and it didn't

[Paul M]

Yes, it does.

[ezzeen]

i did change the words in the files and upload the product its not the first time i do this work but it didn't work the test works fine but when trying to email members it doesn't work even for one member

[RealTesters]

Installed

I just will be check w/ a host if all is ok to prevent a troubles

THANKssssss.!!

Edit: work fine in 3.8.6 patch1...!!!

[weindians]

i want to know whether u need to leave ur brower [acp] on until all emails sent out like the phplist does or queueing is going to server side?? i need to know b4 installing . if so i will continue to use phplist... thanx paul for the mod

[Paul M]

Please clarify your question.

[weindians]

Please clarify your question.

not much to clarify... as it says "do i need to leave the email sending interface of acp open [ simply browser] until all emails sent out [ or until job finish] or will it stop if i close browser? . can i move on when all emails sent to queue ,confirmed in acp[ i suppose as i havent tested yet]

edit : i installed n cleared myself .

[weindians]

mailque in acp says 3,761 in queue. i sent mails yesterday around same time... total members 4600+ . but when sent all mail queue was below 4000 [ it was about 3900+ as far a i remember], i donno where is other 600-700 mails? may be banned n other etc. scheduled task[cron] for mailque seem to be not running every 10 mts.. my batch setting is 30 . delay 0 [ i changed to 1 now to see - no effect , may be mails already in queue]. but number reduced by 30 when i ran sch.task manually.. diagnotic email tested n working..

[Paul M]

Again, I dont follow what your actual question is ?

[weindians]

Again, I dont follow what your actual question is ?

actual question is why mailque still 3700+ even after 48 hours[now] when set to send 180 email/hour??.. or this mod send emails only if that member visit forum.
..

[Paul M]

actual question is why mailque still 3700+ even after 48 hours[now] when set to send 180 email/hour??.

Since any answer to that question would require access to your server and ACP to see how its set-up and working, I cannot answer it.

[weindians]

if u tell me what info related to server n acp needed i can provide you... below is scheduled task log...as per log it seems running 2-3 times a day only.. setting are default 10 ,20, 30,40 etc...

http://i53.tinypic.com/zthq48.jpg

[Paul M]

Unfortunately I cant view that from work (they block tinypic) so I'll look later. Initially I think i'd only need ACP access if you want to PM me an admin login with full access.

[Paul M]

The picture above confirms what I found from the access you gave me. Your problem is that your site is not busy enough to keep the vb cron system running - it needs regular visitors (not spiders) to keep it running. As you can see from you picture, its only managing to run the schedule very sporadically (about once an hour in the day, hardly at all at night).

About the only thing you can do is increase the batch size, so at least when it does run, it processes more. Try something like 200.