PDA

View Full Version : Administrative and Maintenance Tools - Cron Based E-Mail Sending


Paul M
01-07-2008, 10:00 PM
This modification is no longer available or supported.

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

As a result of this your server can become seriously overloaded very quickly - so sending several thousand e-mails (like a newsletter) can become very difficult (hours spent clicking 'next' in the ACP) - as a result of these problems, this very simple modification was born.

This modification does two things ;

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

2. The processing of the mail queue is set-up as a vb cron item.

Obviously 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 realisitc 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 (v3.7.002 onwards).

Version 3.7.003 has the option to add a small delay before each e-mail is sent (between 1 and 9 seconds). Use this option carefully.



History:

v3.7.001 : First Release for vB 3.7
v3.7.002 : Added mail queue size display code.
v3.7.003 : Added option for a delay between the sending of each e-mail.

joopss
01-08-2008, 07:08 PM
Tenks Paul M......... :)

Howell
01-08-2008, 08:56 PM
Excellent! Thanks Paul.

I had to change the compatability of antivirus's little addon to get to install but it's working fine after that. ;)

yahoooh
01-09-2008, 01:59 PM
thanks

obmob
01-11-2008, 03:23 AM
This can be a huge addon, thanks will test it! :3

rainyleaves
01-13-2008, 12:15 PM
Thanks Paul. :)

teenhut
01-23-2008, 06:42 PM
Thanks a ton. I tried to send email through VB system and my VPS went way damn slow and crashed. I had to abort email sending. I just installed this now. Things will be much easier now :)

yawsh
02-03-2008, 03:06 AM
I think this should go as vBulletin built-in as it adds a huge value. Thanks pals.

Paul M
02-03-2008, 10:57 AM
You should probably suggest that on vb.com. They're not likely to see any comments over here. :)

hdrmut
02-03-2008, 04:47 PM
Very important modification ..
isntalled Done

- this is modification send 1 E-mail in evry 10 but i want chang this numper to send 100 E-mail in evry 10 minutes .. so how i can change ?

Paul M
02-03-2008, 06:18 PM
Read the first post.

hdrmut
02-03-2008, 09:03 PM
Thank you :)

asj
02-04-2008, 12:02 AM
Thank you very much

kylek
02-10-2008, 08:30 PM
"Queue Size
Antivirus (https://vborg.vbsupport.ru/member.php?u=64660) has posted a nifty little addon that displays the current size of the mail queue here (https://vborg.vbsupport.ru/showthread.php?p=1367832#post1367832)."

This doesn't seem to work with 3.7.0 Beta 4. When you import the product you get this:

The following dependencies were not met:
The product paulm_20060709 must be installed before this product may be installed. (Compatible starting with 1)

Howell
02-10-2008, 09:04 PM
"Queue Size
Antivirus (https://vborg.vbsupport.ru/member.php?u=64660) has posted a nifty little addon that displays the current size of the mail queue here (https://vborg.vbsupport.ru/showthread.php?p=1367832#post1367832)."

This doesn't seem to work with 3.7.0 Beta 4. When you import the product you get this:

The following dependencies were not met:
The product paulm_20060709 must be installed before this product may be installed. (Compatible starting with 1)

Open: product-anti_mailqueue_stats_acp

Find:

<dependencies>
<dependency dependencytype="product" parentproductid="paulm_20060709" minversion="1" maxversion="" />
</dependencies>Replace with:

<dependencies>
<dependency dependencytype="product" parentproductid="paulm_cmq_37" minversion="1" maxversion="" />
</dependencies>Thats what I did to get it working. :)

Paul M
02-11-2008, 11:22 AM
Yes, well spotted.

I suppose what I should really do is ask Antivirus if I can include his code in the main product.

webgeek247
04-19-2008, 12:09 AM
Hi Paul, looks like it will do the job once i figure out how to use it properly

Ive setup the script but i got this error

Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Friday, April 18th 2008 @ 07:02:17 PM
Script : http://www.djpassion.co.uk/forums/admincp/cronadmin.php?do=runcron&cronid=21
Referrer : http://www.djpassion.co.uk/forums/admincp/index.php
IP Address : **********
Username : Chris Powell
Classname : vB_Database
MySQL Version :

It seemed to work out with the email send out setting set to 10 but when i tried 250 i got the above error

My host allow 500 emails to be sent out per hour. I have just under 1000 members so to be on the safe side would have thought setting it to send 250 emails per hour would work ok...please help

webgeek247
04-19-2008, 12:11 AM
Ps even though it said it failed i think the emails still sent out because the Mailqueue Quick Stats went from around 950 to this

There are currently 679 unsent emails remaining in the mail queue.

webgeek247
04-19-2008, 07:44 AM
just checked back this morning and have now got There are currently 434 unsent emails remaining in the mail queue.
more info. the error message i got above was what i got after running the Run Now button in scheduled tasks. hope this extra info helps.

Paul M
04-19-2008, 11:08 AM
You obviously have a fairly low mysql timeout, so if you try and send too many emails in one go, your database connection is timing out before they have all been sent.

webgeek247
04-19-2008, 02:15 PM
Well I sent 167 on one of my other sites which is hosted on the djpassion account as a addon domain and they all sent successfully so I don’t think its a mysql problem. I did change the schedule times around a little invbulletin which I think fixed it though. It didn’t seem to work when set to send all emails everyday. But once I figured out how to change it to 1 hour I think it sorted it. I also took the limit down from 250 to 100 and they all seem to be sending ok. Like when I check back every hour 100 more have sent so I guess its working ok now...? If so thanks to you so much for this hack and to Antivirus for his little addition….makes life much easier.

cheers chris

F.nk
05-05-2008, 09:57 PM
Thank you, it works beautifully :D
I also see that my server is faster ^_^
thanks.

TCB
05-06-2008, 04:10 PM
Thanks for this product. I have some questions though:

I have in the ACP under email options:

Email Flood Check: 0
Number of Emails to Send Per Batch: 25

Then the cron is setup to run every 10 minutes.

What does the floodcheck do? Does it interfere with this addon?

Where can I see the number of unsent messages in the cron queue (antivirus addon)?

On the end of your first post you say: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. .
I don't understand this part. First we have to set a number in the 'email'-option in the ACP (like 25), and then (when?) it can be safely set to a high number?

Paul M
05-06-2008, 04:22 PM
Flood check is not part of this mod.

The ACP mail inteface is when you mass email users via the ACP, not the Emails per batch option, totally different thing.

TCB
05-06-2008, 05:50 PM
so this current setting is right? If so, when can this '25' be changed to '9999'?

Paul M
05-06-2008, 06:39 PM
It cant, like I said, its nothing to do with that.

Its the ACP > Users > Send Email to Users.

wii
05-07-2008, 01:55 PM
My host has this limit:

Run cron entries with intervals of less than 15 minutes

1. Would that be a problem ? Since I´m allowed to send 500 mails an hour

2. Mailqueue Quick Stats should be the total number of mails, right ?

3. How do I set the time interval - how many mails to send out a minute ?

4. Can I delete a Mailqueue once it started ?

Thanks

Jase2
05-20-2008, 02:42 PM
Thanks Paul! Will come handy when I start sending a newsletter, but works great for subscriptions in the mean time. :)

coberr
05-29-2008, 09:26 PM
Hello,
I installed the plugin.
I turn on e-mail queuing in the ACP options - set 'Use Mailqueue System' to 'Yes', and 'Number of Emails set to 10.

How to send now mails to all normal users.
Thank you.
Regards,
Manuel

Paul M
05-29-2008, 09:50 PM
ACP > Users > Send Email to Users.

losedude
05-31-2008, 05:46 PM
Hi,

I'm using this mod right now and I must admit it's a life saver ^^ , I wouldn't be able to send out emails without it.

I was wondering though, where do I have to go to see the amount of emails that are left to be sent ?

Thanks

Paul M
06-01-2008, 05:13 PM
Thats entirely server/os/control panel dependant (unless you means still to be sent by vb ?).

losedude
06-03-2008, 04:59 PM
Yes that's what I mean, how many emails VB has left to send.

Paul M
06-03-2008, 05:01 PM
Its displayed in the ACP.

360themes
06-05-2008, 02:57 AM
i want to send HTML Mail to Members by this way ... but VBB seems not support T.T ... who can help me ?

alhindasi
06-23-2008, 02:47 PM
The number of seconds delay before sending each e-mail. Note that values greater than 9 seconds will be ignored

can you tell me what is the number it can be good to my sarver not mack up load

Paul M
06-23-2008, 04:51 PM
Unless you have a specific reason then you wont normally need to change it from zero.

alhindasi
06-23-2008, 05:22 PM
Unless you have a specific reason then you wont normally need to change it from zero.

that mean the zero is good ...

alhindasi
06-23-2008, 05:31 PM
Dear in My Web Host Manager i do like this :
Number of minutes between mail server queue runs (default is 60). : 10
The maximum each domain can send out per hour (0 is unlimited) : 3500

in my Server Only One site only
----------------------------------------------------------------------------------
in the forum Option i do in : Number of Emails to Send Per Batch: 500


can you tell me what is the good for me i have 50,000 Members

Sherrie
06-27-2008, 01:13 AM
Okay I am new to adding plugins and products so this may be a really dumb question so apologies in advance :)

I have installed this as instructed and already have email queue enabled but where I am stuck is the next step as I do not follow where I change the cron settings:

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


Any help would be appreciated

Thanks

Sherrie
06-27-2008, 03:03 AM
Never mind, I figured it out (scheduled task manager) and it is running beautifully, thank you very much as I really needed this!

One more question though, how do you view your mail queue?

Cheers

Paul M
06-27-2008, 12:57 PM
See post #32

helpmehost
06-28-2008, 08:05 PM
reserved

wii
07-15-2008, 06:27 PM
The update works fine, but very slow, since my host requires me to set it to throttle it at least every 6 seconds, now the email manager take forever to get the mails out.

Paul M
07-15-2008, 07:20 PM
Six seconds is a ridiculous amount of time, it *will* run slowly.

wii
07-16-2008, 06:32 AM
Yeah, I will contact my host again about this.

dtommy79
07-17-2008, 12:39 PM
Hi,

It may be a dull question, but how can I use it?

I have to enable Mailqueue System and set the "Number of Emails to Send Per Batch" option and that's it?

And also on my host I have a 200 emails/hour limit, I have around 1000 members. What's the best settings for me?

thanks for the help

Paul M
07-17-2008, 03:17 PM
Once its installed, yes, you just enable the queue system and set the number - in your case you should set it to 30. (30 x 6 = 180 per hour).

dtommy79
07-19-2008, 07:06 AM
Once its installed, yes, you just enable the queue system and set the number - in your case you should set it to 30. (30 x 6 = 180 per hour).
Hi,

I enabled and set the number, but I think it's not doing what it supposed to.

When I try to check the logs it says there is no result. The logging is enabled though.

StonePilot
07-23-2008, 08:32 PM
Looks like it's working properly for me, my VPS has the emails shut down pretty tight so this is great!

StonePilot
07-24-2008, 12:41 AM
Its displayed in the ACP.

Where is this shown in the ACP? I've got 7500 emails to send out.

Paul M
07-24-2008, 01:07 AM
On the main index page, above the Administrator Notes.

yahoooh
07-26-2008, 05:54 PM
does this effect the sending e-mail function for addon like : vba links and vbgallery?

FLASHYAN
07-27-2008, 07:05 AM
thanks pro

but if i do what u talk like :
https://vborg.vbsupport.ru/attachment.php?attachmentid=84640&stc=1&d=1217145516

how to abort or Cancel this Process when i want ??:)

jw00dy
07-28-2008, 05:09 AM
I'm trying this now, but wanted to know if you had any thoughts on this...

Would their be a problem with creating a second cron (scheduled task) to run every 10 minutes on the 5's (5,15,25,35,45,55) so my queue is processed every 5 minutes instead of every 10?

I think this should work, and the crons do run, but I'm not sure the 2nd one is actually processing email, though I believe it is.

So in short my mail queue processes every 5 minutes instead of every 10. My board is pretty big, and I've had complaints about it taking a long time to get their messages... You know how that goes.

So far so good...

dtommy79
07-29-2008, 08:38 AM
On the main index page, above the Administrator Notes.

For some reason it doesn't want to send emails. For days now I have this message above admin notes.

There are currently 769 unsent emails remaining in the mail queue.

Arsh
08-02-2008, 07:02 AM
HI

When trying to install the mod, I'm getting this error:

vBulletin Message

XML Error: not well-formed (invalid token) at Line 1

How do I fix this?

Paul M
08-02-2008, 06:20 PM
Would their be a problem with creating a second cron (scheduled task) to run every 10 minutes on the 5's (5,15,25,35,45,55) so my queue is processed every 5 minutes instead of every 10?

That would work fine.

jw00dy
08-04-2008, 02:48 PM
Thanks paul.

Froggy32701
08-10-2008, 06:16 AM
E-Mail Send Delay

Is this out of que? or into.

As I set this to 1 and it seems like it was 1 second for each to go into que? If so what is the benefit of this?

Chimpie
08-11-2008, 03:59 PM
It cant, like I said, its nothing to do with that.

Its the ACP > Users > Send Email to Users.

Hey Paul... just seeking some clarification here...

Are you saying that this mod will not affect the Send Email to Users, or will it also work with Send Email to Users?

EDIT:And I'm overlooking the obvious here, but where do we make the change from running the cron every 10 minutes to every 5 minutes (or whatever)?

i.s.s.w
08-19-2008, 06:41 AM
thank Paul M

i am testing good

yahoooh
08-20-2008, 01:50 AM
after install this product some e-mail not show the bburl option correctly
like: $vboptions[bbtitle] , $vboptions[bburl]

Paul M
08-20-2008, 11:08 PM
This does not alter the content of e-mails.

txspaderz
08-22-2008, 05:39 AM
Marked as Installed. Thanks for this great add-on!!!!

Chimpie
08-24-2008, 10:23 PM
Just want to add a thank you to this thread. This mod is working out nicely.

:thumbsup:

My forum has around a thousand members and I have two crons set up for this. I send out 10 emails every 5 minutes. This shouldn't raise any flags with any ISPs.

StonePilot
08-26-2008, 07:25 AM
How to set this to send email out every minute? I made two cron jobs running 0-10-20-30-40-50, and 5-15-25-35-45-55. Even at this, it's taking hours to send emails out. Granted, I have nearly 10,000 emails to ship, maybe I would be better off sending though a third-party email system at this point.

Paul M
08-26-2008, 09:59 AM
Set all the options in the vb cron to "*" and it should run the cron once a minute.

mayanks
08-31-2008, 06:42 PM
Hi Paul,

Could you please let me know if these settings are fine ? i have 18K+ members on my board

Thanks

Chimpie
09-01-2008, 02:11 AM
For those who have upgraded to vB v3.7.3 remember to update the associated php files.
:(

len backus
09-11-2008, 03:48 PM
Do I need to first uninstall Version 1.12?

Paul M
09-11-2008, 04:38 PM
You dont need to, you can just install this over the top of the old version. Your choice. :)

len backus
09-11-2008, 04:47 PM
Paul, thanks. Do I need to do the file edits again or just upload the xml file?

Paul M
09-11-2008, 06:25 PM
Check the edits, afaik they are the same.

len backus
09-13-2008, 10:14 AM
Paul, After upgrade I now show 2 copies of Mailque Quick Stats in my Admin CP. ??

pmcnamara
09-24-2008, 11:07 AM
I'm confused about the cron job.. what command am I asking it to run ?

420
09-25-2008, 07:24 AM
i have v3.7.003 with vb 3.73 pl1

how do i tell how many seconds the delay is set for?

i had a programmer install it then went mia.

i was able to send out ten thousand emails an hour before loading this, now i can only send out about a thousand per hour, i think this may be why... is it possible?

thanks for your valuable time and support!

Paul M
09-25-2008, 11:53 AM
The delay is a setting in the vb options for this mod, simply check what its set to.

420
09-25-2008, 10:59 PM
is this the code to change from 10 seconds to 1 second? < 10) to < 1)?

<removed>

420
09-25-2008, 11:01 PM
and does this work on 3.73 pl1?

Paul M
09-25-2008, 11:03 PM
is this the code to change from 10 seconds to 1 second? < 10) to < 1)?
No, thats just part of the plugin, as I said, to change it you would go into the mods settings.

and does this work on 3.73 pl1?

Yes.

420
09-25-2008, 11:25 PM
Plugins & Products > Manage Products > Edit > Edit Product paulm_cmq_37

i cannot find a setting in here to change delay time.

am i in the wrong place?

420
09-27-2008, 03:20 AM
bump...;)

glennybee
09-29-2008, 02:17 PM
Is there any way I can view the mailing list to check it's progress?

Thanks

glennybee
09-29-2008, 02:20 PM
Just noticed that you can see how many emails are in the queue on the main admincp page. :)

Thanks

Paul M
09-29-2008, 03:40 PM
vBulletin Options > Email Options > E-Mail Send Delay

Mr-Mo3ath
10-02-2008, 10:46 AM
im send but he not send and im see the cron hes not send and i doinge refresh for cron and he same proplem :s

Paul M
10-02-2008, 11:17 AM
Sorry, I have no idea what you are trying to say.

Mr-Mo3ath
10-02-2008, 11:35 AM
im send but he not send good the cron for example 1065 user hes not change because hes not send and im go to the cron in acp and doing refresh for cron or turn on for this cron and nothinge change i dont now why
but when i removed the proudect hes send him all :D

Mr-Mo3ath
10-02-2008, 11:37 AM
and add a sugget for you if you can make him like mail php if i want stop thes meesage or turn on
like this if you can
thanks agine mr paul

Mr-Mo3ath
10-03-2008, 03:08 AM
im installed him agine and he give me same proplem

Chimpie
10-04-2008, 07:57 PM
I've used this before with no problems. Today, it sent emails to all 1,000+ members in short bursts, within just a few minutes instead of over a period of hours. No settings were changed.

Thoughts?

Edit: The only change was the upgrade to 3.7.3 PL1

Paul M
10-05-2008, 10:12 PM
Did you redo the file edits - I would guess not.

Chimpie
10-05-2008, 11:04 PM
Did you redo the file edits - I would guess not.

I changed one, but not the other. oops

Mr-Mo3ath
10-06-2008, 10:14 AM
Did you redo the file edits - I would guess not.

i changed the 2 files and upload the php file and install the prodect
any think else i have to do
last plaese learn us what wh have to do when install the meesage and hoe we are confirge the mail cron good

thanks agine sair

Paul M
10-06-2008, 12:27 PM
I can barely understand you, but from what I can tell, you have done everything except set the vb options. Read the first post. :)

BigDog56
10-06-2008, 03:33 PM
Installed, seems to be working good!

Erosantica
10-06-2008, 04:22 PM
Hi Guys,

I have install this plugin.. However it seems to be generating the email to sent to users 3 times already.
How can I prevent the email to sent it out again..

Erosantica
10-07-2008, 03:45 AM
Is there any way to check what is in the mail queue?

Paul M
10-07-2008, 06:57 AM
Do you mean the vb mail queue, in which case, just view the table. If you mean your mail server then probably, but I can t tell you how as its system dependant.

Erosantica
10-07-2008, 04:41 PM
Hi Paul M, how to view the table in VB mail queue?

Paul M
10-08-2008, 02:14 PM
Same as you view any table in mysql, phpmyadmin or the ACP are the most common ways.

dtommy79
10-08-2008, 05:23 PM
Hi,

set it to run every 10 minutes, and set the items to be processed to something larger (like 100).

Where do I have to do the settings?
Can I check the progress of the sending somewhere?

Thanks

420
10-08-2008, 08:58 PM
Mine is set to 0 (ZERO), what does that do?

vBulletin Options > Email Options > E-Mail Send Delay

Paul M
10-11-2008, 03:46 PM
Sends them without any delay, zero is the default and prob fine for 99% of forums.

420
10-11-2008, 08:08 PM
cool, thanks paul!

i think i found my problem, by the way.
in email settings in vb admin control panel, there is a setting for using smtp for your emails, instead of the web based mail... you are apparently not supposed to enter the user name and password for the email account being used, when the email server and web server share the same infrastructure... (not sure if that is the correct word or not)... when i removed the user name and password, the bottle necking and slowness stopped during email blasts and everything is back to normal... the servers are still hanging for some reason, probably a faulty add on we need to locate, but the email blasts are back to normal...

by the way, i notice i can see the mail queue in vb admin control panel now, is that a feature of vb 3.73 or is that a feature of your add on?

thanks again for your valuable time, energy and support brother!

Paul M
10-11-2008, 08:10 PM
by the way, i notice i can see the mail queue in vb admin control panel now, is that a feature of vb 3.73 or is that a feature of your add on?

From the main post ;

This modification includes the code by Antivirus that displays the current size of the mail queue (v3.7.002 onwards).

420
10-11-2008, 08:27 PM
thanks paul!

muhakeme
10-30-2008, 08:42 PM
Thanks.

shacow
11-01-2008, 08:38 PM
Thank you so much!

lebmobile
11-01-2008, 10:18 PM
i got this error : Parse error: parse error, unexpected T_DIV_EQUAL in /home/content/l/e/b/lebmobilehost/html/forum/includes/functions.php on line 791

Paul M
11-01-2008, 11:34 PM
You need to check the edit you made to functions.php - you have made a mistake in it.

lebmobile
11-02-2008, 12:15 AM
thank you man its done .. but i want to ask where i can change the value of minutes ?

Paul M
11-02-2008, 11:04 AM
Value of minutes ?

BigDog56
11-02-2008, 07:55 PM
I just went into my admin control panel and saw 10 emails in queue, yet I had not sent any. Is there a way to see which member is emailing people?

Paul M
11-02-2008, 11:20 PM
Try looking in the email queue table (mysql).

BigDog56
11-03-2008, 07:36 AM
Try looking in the email queue table (mysql).

Thank you, got it!

lebmobile
11-04-2008, 01:07 PM
i want to run this plug in every 1 hour ..where i can set that

Paul M
11-05-2008, 09:15 AM
Edit the cron job in schedule manager.

kartik786
11-06-2008, 06:31 PM
i have over 75k members and it takes atleast a week for the queue to send mail to all of them.

please assist as to how to make these mails reach them quicker.

i m on a dedicated server.

Mr-Mo3ath
11-17-2008, 01:36 PM
thats come to me
Database error in vBulletin 3.7.4:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, November 17th 2008 @ 05:34:20 PM
Error Date : Monday, November 17th 2008 @ 05:35:01 PM
Script : http://8888888/admincp/cronadmin.php?do=runcron&cronid=24
Referrer : http://8888888/admincp/cronadmin.php?do=modify
IP Address : 8888
Username : *****
Classname : v888_Database
MySQL Version :

wreckless
11-20-2008, 12:06 AM
I randomly check the queue and I see emails waiting to send. I think my registration emails are some how getting caught up. Is this possible?

Paul M
11-20-2008, 10:30 AM
They are most likely subscription emails. Registration emails are not queued by vb afaik.

Plasma2002
11-22-2008, 02:35 AM
Hey man, just wanted to say thanks. This is something that should be a part of vBulletin in the first place. Youve made my day easier as well as many others' im assuming.

Thank you

axi
11-23-2008, 10:34 AM
hi how do i get it to send 40 an hour i tried adjusting settings in sceduled task settings for this but it still tried to send the full thing in 1 hour can anyone suggest please thanks??

axi
11-25-2008, 01:01 PM
hi how do i get it to send 40 an hour i tried adjusting settings in sceduled task settings for this but it still tried to send the full thing in 1 hour can anyone suggest please thanks??

bump!!

cellow
12-18-2008, 06:30 AM
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 is not working 4 me. I looked up in the database and could see that every email is in the queue. Activation-emails, registration email :-(

How can i solve this problem?

kinkarso
12-18-2008, 07:09 AM
Just installed it. I'm wondering, do I have to go to cpanel and create the cron job for this to function? :)..

Can't seem to find the option to edit the number of emails to send / batch in cron, and the per minute settings.

Paul M
12-18-2008, 08:53 AM
This runs via the vb cron system, not cpanel.

MuTheMatrix
12-23-2008, 04:04 AM
Thanks a lot for this mod.

Sworm
01-01-2009, 03:09 PM
Hi all,
this mod work on vb 3.8 too?

thanks

TMH63
01-06-2009, 11:10 AM
Can someone please help me with this one? I've read through this whole thread twice and I'm still a little confused on how many emails will be sent per hour.

Here's what I have setup....

Number of Emails to Send Per Batch=8
E-Mail Send Delay=0

When I sent the mass email..... Email to send at once: I set at 100

*Scheduled Task Manager*
Days of the week=*
Day of the month=*
Hour=*
Minute=0,10,20,30,40,50

EDIT:

If I understand this correctly.......I'm beginning to believe that the amount of "Email to send at once" is irrelevant with this mod. One could have it set really to any amount. I've been watching and it seems that 8 emails are being sent every 10 min.

If someone could verify everything above....I'd appreciate it!

Chimpie
01-06-2009, 11:26 AM
EDIT:

If I understand this correctly.......I'm beginning to believe that the amount of "Email to send at once" is irrelevant with this mod. One could have it set really to any amount. I've been watching and it seems that 8 emails are being sent every 10 min.

If someone could verify everything above....I'd appreciate it!

You have everything correct.

TMH63
01-06-2009, 11:40 AM
You have everything correct.


Perfect! Thanks for verifying. My host allows 500 emails per hour, so I guess that I can just tweak the "Number of Emails to Send Per Batch" up to get them out faster.

Paul M
01-06-2009, 03:39 PM
Yes, you can set it to 80 (6 x 80 = 480 per hour).

TMH63
01-06-2009, 04:50 PM
Paul,

One thing that I've noticed though now is that for those including myself who want to get emailed on PM's received or new registrants....I'm now not getting those immediately like before.

Is there a work around to this or it is what it is?

Paul M
01-06-2009, 05:26 PM
That is how vb is designed, new registration emails are not queued, I'm surprised PM notifications arent tho.

TMH63
01-06-2009, 05:47 PM
That is how vb is designed, new registration emails are not queued, I'm surprised PM notifications arent tho.

Yes I know registration emails aren't queued, but my email notification of their registry is along with the email that I receive when someone sends me a PM. That's what I was wondering if there is a work around for. Prior to this mod install, I received those instantly....now they lag.

Just curious.

cellow
01-07-2009, 12:16 AM
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 is not working 4 me. I looked up in the database and could see that every email is in the queue. Activation-emails, registration email :-(

How can i solve this problem?

*BUMP*
why i dont get any answer for that? Look into ur database, and u will find also queued registrion & activationlink emails!

RedFoxy
01-12-2009, 11:38 AM
do it goes with 3.8.0?

Paul M
01-12-2009, 11:54 AM
Read the main post :)

cellow
01-27-2009, 05:34 PM
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.
Originally Posted by cellow
This is not working 4 me. I looked up in the database and could see that every email is in the queue. Activation-emails, registration email :-(

How can i solve this problem?
*BUMP*
why i dont get any answer for that? Look into ur database, and u will find also queued registrion & activationlink emails!

fredang85
02-02-2009, 06:53 AM
I cannot see the mail queue in my admincp. Why is that so?

magicman17
02-11-2009, 11:36 PM
is there a way for this mod to still work and mu members still get their subscription emails? or not able to happen? Thanks mate.

Paul M
02-12-2009, 07:02 AM
Huh ?

Jelmertjee
03-27-2009, 12:53 PM
Awesome work, perfect when your host limits your number of emails per hour/minute. thanks a lot.

yahsuah
11-13-2009, 03:16 PM
Thanks for this mod. I tested it today, it is working perfect on vb3.7.3

vitrag24
11-26-2009, 12:41 PM
I've installed this mod.
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.

viper357
01-31-2010, 07:28 AM
Has anybody got this running on 3.8.4?

Chimpie
01-31-2010, 11:25 AM
Has anybody got this running on 3.8.4?

Try the 3.8 version...
https://vborg.vbsupport.ru/showthread.php?t=201318

viper357
01-31-2010, 11:35 AM
Try the 3.8 version...
https://vborg.vbsupport.ru/showthread.php?t=201318
Thanks. :up: Didn't find that one when I was searching.

serra00
06-03-2010, 02:17 AM
how to install on 3.8? I said that is not compatible

The product paulm_20060709 must be installed before this product may be installed. (Compatible starting with 1)