Nope, it will send 6 e-mails every 10 minutes.



You do not need to stay logged in, it will process the list straight away (just step through the pages) - the e-mails go into the e-mail queue.

Oh yes sorry, speel error, I indeed 6 e-mail x 10 minutes, this is what I need, Thanks Paul

hi
i am having this error from the past one month
i check with my hosting company but no use
it just happen for sending mails an nothing else

please try to solve my problem becoz it help me alot from the time i add it
---------------
Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, October 3rd 2007 @ 04:31:29 PM
Script : http://www.q8x4.com/vb/cron.php?&rand=827783
Referrer : http://www.q8x4.com/vb/index.php
IP Address : 86.62.250.3
Username : ??? ????
Classname : vB_Database

That's a mysql problem. If you search vbulletin.com I believe they have more details.

i am lost !!!

its not a mysql problem becoz it just happen with the mail queue and every thing else is working fine.

and i have contact my hosting company they told me the problem with the sleeping quary

and when i contact the vbulletin.com support team they told me its a Cron Based E-Mail Sending add-on problem.

every one is just saying its not my problem

what can i do please help me becoz this corn job solve a big problem i was facing before and i can not stop using it.

Well I'm sorry they told you that, but the fact remains that it's a mysql issue.

Great modification Paul, really helps with sending out emails to large amounts of members. I found myself wondering how many emails were in the queue quite often however, and I got tired of manually running a SELECT query in the console to find out how many emails were remaining in the queue... so i coded the attached add-on for your mod which adds the quantity of remaining emails in the mail queue to the AdminCP page.

You can see a screenpic of what it does in the attached "screenie.gif" image. I just thought I would share it with everyone who's using this mod, makes life a little easier. :)

Thanks a lot Antivirus :D

You are welcome!

Ok just a question. Im a little naive from what I see. I want to only send out 200 emails per hour since that is what Hostgator only allows.
I went to acp email options
Use mailqueue I checked to yes...
Number of Emails to Send Per Batch what would I put? I put 85 as I read in the first page but all my emails returned back. So what exactly am I doing wrong I can only send 200 emails per hour so how would I set that up? I also did the two file edits.
Thanks in advance...

As the notes tell you - the Cron runs every 10 minutes (i.e. 6 times an hour) - so if you set it to 85 then 85 x 6 = 510 per hour - well over your limit. You need to set it to about 32 maximum.

Thanks Paul seems to be working perfect!

Thanks for this hack and thanks for the report hack on the admincp homepage.

One question - there is a CVS folder in the zip that is empty - should this be uploaded?

Nope, ignore it.

Need some help with this. It was working fine till I installed the vb368 PL2 (only the changed files). Now the queue processes, but the emails are not sent.

If I disable the queue processing, the emails are sent just fine.

Could anyone help?

Nothing in PL2 can affect this modification.

Hello.

This doesn't seem to work if SMTP port 587 is specifiied in PHP.

Laura

great add-on, Paul.

I have a question in regards to vBulletin "cron" jobs.

If I have it right, these are triggered by users visiting the forums.

If a forum were to have no visitors in say a two hour period, are missed vb cron jobs then executed? The result being that the task for this add-on may run all missed tasks and thereby possibly causing quotas to be exceeded?

That's correct.

They will be executed as soon as you get a visitor after the two hour period, not during it.

Sorry, but I don't understand what you mean by this.

Huh ?

Can you please be a bit more specific.

To re-phrase, are missed cron jobs still executed at the next opporutinty? For example, if there are no visitors for 2 hours then the (default - every 10 minutes) 'process mail queue' cron job would would miss 12 'executions' of the job. Would these missed 'executions' then all (12) be run at the next opportunity, or would the never be run.

The reason I ask is that if I were on a throttled account of say 500 emails/hour and had configured my vb system to send batches of 100 emails every 10 minutes (using this add-on) and if all 12 missed executions were run at the next opportunity, that would be 1200 emails send in a short space of time - totally trashing my 500 email/hour limit.

Clear as mud?

No, that will not happen - the cron job is only triggered once - if you have no visitors for two hours then it won't fire 12 times, just the once.

Sure.

I have Cron Mail Queue installed and it was working great. I have it set to send 5 emails per minute which works fine for my site when I send out my weekly updates.

I recently changed my SMTP port setting from 25 to 587 at the request of my provider. There is a vBulletin option for this, but you also have to change SMTP_Port= in PHP to 587 as well to get it to work.

After I made the change, my last round of weekly updates went out all at once instead of 5 per minute. They all were successful, but they did go out all at once.

Laura

The change you made cannot affect this modification in any way, maybe your e-mail server just queued them all up.

Perhaps it can't affect the mod, but the PHP change can certainly affect the way vBulletin works relative to the mod.

I did change this back to port 25 and it worked as expected sending 5 emails per minute.

Laura

* Clicks Mark as Uninstalled *
Just what we needed to get all our stuff out past our hosts 200 emails/hour limit @30 emails /10 minutes
Now everyone will get their daily e-mail notifications, even if it does take the system 3-4 hours to get the job done.

Thanks Paul!
---------------------------------
now if it only were truely CRON based and didn't depend on site activity, though we always get more than enough site hits to trigger things

Installed using hostgator. Thank you, exactually what I needed and will be setting it to 25 emails per batch. Thanks - Nominated for mod of the month.

SVT

A great addition to this great hack.

SVT

^
|
|
|

What (s)he said x 2 :up:

I have to agree. This plus the crontab based vbcron jobs is a killer combination!

Working great still in Beta 3.

Hostgator is now imposing a 200 per hour limit. I recommended this on their forum for all vB users for that :)

Yea it sucks having vB on hostgator site and can only send 200 emails a day. This is the perfect fix for that. Props to Dr Pepper Addict :up:

SVT

Yes, it will solve lot of problems for us.

Installed, thanks.

I am getting this error after upgrading php verion

Database error in vBulletin 3.6.5:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, January 2nd 2008 @ 12:16:37 AM
Script : http://alhawza.net/forum/forumdisplay.php?f=50
Referrer : http://alhawza.net/forum/showthread.php?t=50724
IP Address : 87.230.151.169
Username : منا(العلم)هل
Classname : vB_Database

is there a way to resolve this issue

Increase your sql timeout, or reduce the number of emails you send in one batch.

I'd like to set it so it sends 100 emails per hour....what do I need to edit? The ACP functions confuse me and I don't know what to edit and where.

Thanks. It seems to be working fine for now.

This is a fantastic feature for vB forums. My host has a hourly email limit of 250. There are a many instances where I need to send out a mass pm to my members. I just end up exceeding my mail quota and everything gets returned. Hopefully, this will permanently solve that problem.

This is a feature that should come OEM in vBulletin. Makes no sense to me why it's not built into vB in the first place, considering the nature of these types of forums.

installed

Is there any way to get around the server not sending subscription emails right away instead they are being put in the mail deal also. so in tread replys email.

Subscription etc emails are designed to be queued, thats standard vb.