Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Suppress-o-matic - Stop database error spam Details »
Suppress-o-matic - Stop database error spam
Mod Version: 1.0.0, by GeekyDesigns (Coder) GeekyDesigns is offline
Developer Last Online: May 2012 I like it Show Printable Version Email this Page

vB Version: 4.x.x Rating: (7 votes - 5.00 average) Installs: 85
Released: 17 Nov 2009 Last Update: Never Downloads: 389
Not Supported Code Changes Additional Files  

What is Suppress-o-matic?
Suppress-o-matic is a change to the way vBulletin handles database error emails. It limits sending the same error email repeatedly to your inbox every time a database error is generated. On a busy site if a table is crashed or mysql itself goes down you could recieve several thousand emails. This causes the email server to bog down, and possibly the server itself if there is enough traffic generating emails.

Why do I want Suppress-o-matic?
It should be pretty clear, you still get the vital information that your vBulletin forum is offline for whichever reason, without the hassle of having to delete and manage your inbox afterwords.

Why do I have to edit the files?
If the database is down, there is no way to get to the plugins. Plugins are stored in the vBulletin database.

Isn't there a vBulletin Option for this?
There is an option to disable some emails, assuming that the settings table can be read. If it cannot then it doesn't work. It even states this on the option itself.

Can't I just remove my tech email from the config file?
This doesn't keep you up to date. What if a serious error like error 28 (no space left) crops up? This means that your server could potentially have serious issues. Not resolving these problems could cause major issues.

Are you considering adding more functionality to Suppress-o-matic?
We have plans to add a repair feature at some point in time, with an on/off switch.

What is SQlite?
SQLite is a tiny database engine that is found in PHP. It is very lite, and requires only that php have the extension. There is no other dedicated server for it. You can find more information here: http://en.wikipedia.org/wiki/SQLite


Whats required?
PHP5
SQLITE2 or newer (found in most php installations)
1 file edit
1 file to upload

Future versions:
Repair table feature



Project Credits:
Zachery - Project Planning, design goals, pestering.
Link14716 - Hard work.

This works for vBulletin 4.0 as well as 3.7+. vB3 thread located here.

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools Suppress-o-Matic - Stop database error spam GeekyDesigns vBulletin 3.8 Add-ons 65 12 Sep 2013 21:01

  #46  
Old 25 Mar 2015, 14:24
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I don't see anything in this mod that could do that. My guess is that it's a coincidence of some kind. Did you try this mod because someone told you you were sending too much email? Maybe your host decided to do something about it on their end?
Reply With Quote
  #47  
Old 25 Mar 2015, 14:40
i156 i156 is offline
 
Join Date: Oct 2007
No, I added it to stop cut down on the error emails that come through when mysql goes down. I've switch to sendmail for now which is working.
Reply With Quote
  #48  
Old 25 Mar 2015, 14:44
i156 i156 is offline
 
Join Date: Oct 2007
Now what I can't figure out is I have it working with SMTP using my hosts' SMTP. But when I switch back to using Amazon SES which is what I used before I get that error.
Reply With Quote
  #49  
Old 25 Mar 2015, 15:18
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Hmm...did you change the email address they are being sent to or from? Sometimes some servers will complain if the 'From' address isn't one they like. I guess there's no more information in the error message when you use the diagnostics?
Reply With Quote
  #50  
Old 25 Mar 2015, 15:26
i156 i156 is offline
 
Join Date: Oct 2007
Originally Posted by kh99 View Post
Hmm...did you change the email address they are being sent to or from? Sometimes some servers will complain if the 'From' address isn't one they like. I guess there's no more information in the error message when you use the diagnostics?
That was exactly it. I switched from my domain email to my gmail account. Switched it back and it is working. Thanks.
Reply With Quote
  #51  
Old 07 Jul 2015, 17:21
kerrghann's Avatar
kerrghann kerrghann is offline
 
Join Date: Jul 2012
Real name: Markis
This seems to be exactly what I want. I'll give it a go. Thanks for the mod.
__________________
A Place to create; a place to innovate~
Reply With Quote
  #52  
Old 28 Dec 2015, 21:29
joyboy2001 joyboy2001 is offline
 
Join Date: Nov 2008
Is this working with 4.2.x ?
Reply With Quote
  #53  
Old 01 Jan 2016, 17:26
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Still works fine.
__________________
Looking for ImpEx?
Reply With Quote
  #54  
Old 23 Jul 2016, 06:15
Islamic Board Islamic Board is offline
 
Join Date: May 2016
We have SQLite3 installed on php 5.4 and this mod doesn't work. How can we modify this to work with SQLite3?
Reply With Quote
  #55  
Old 26 Jul 2016, 10:32
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
SQLite3 requires recoding the plugin slightly.
I've done it - easy

Kym
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #56  
Old 26 Jul 2016, 12:40
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Do you have the errors or notes regarding it? I don't have a test bed for this right now but if you let me know we can look into fixing it.
__________________
Looking for ImpEx?
Reply With Quote
  #57  
Old 27 Jul 2016, 21:49
Islamic Board Islamic Board is offline
 
Join Date: May 2016
Originally Posted by Zachery View Post
Do you have the errors or notes regarding it? I don't have a test bed for this right now but if you let me know we can look into fixing it.
We have modified it slightly to work with SQLite3. There doesn't seem to be any errors thrown by this script at the moment but when we tested it, we still receive multiple db error emails of the same error message, even within 1 second.

Below is the modified script for SQLite3.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Using the dumpdberror script given in this thread, we can see that there was a single db error written in the database file, only once. It has not updated after that in subsequent tests.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:37.

Layout Options | Width: Wide Color: