The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Cron Based E-Mail Sending Details »» | |||||||||||||||||||||||||
This modification is no longer available or supported. This is a 3.6 specific port of the 3.5 Modification. 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. Upgrading from the 3.5 version. If you have the 3.5 version installed then you don't need to upgrade - however if you decide to upgrade then you need to delete the current cron job in the Scheduled Tasks Manager and then import the product xml via the ACP Product Manager. The file edits do not need to be changed. Queue Size Antivirus has posted a nifty little addon that displays the current size of the mail queue here. History: v1.12 : First Release for vB 3.6. Show Your Support
|
Comments |
#112
|
|||
|
|||
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 |
#113
|
|||
|
|||
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 |
#114
|
|||
|
|||
Yes, it will solve lot of problems for us.
|
#115
|
|||
|
|||
Installed, thanks.
|
#116
|
|||
|
|||
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 |
#117
|
||||
|
||||
Increase your sql timeout, or reduce the number of emails you send in one batch.
|
#118
|
|||
|
|||
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.
|
#119
|
|||
|
|||
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. |
#120
|
|||
|
|||
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. |
#121
|
||||
|
||||
Subscription etc emails are designed to be queued, thats standard vb.
|
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|