Administrative and Maintenance Tools - Suppress-o-matic - Stop database error spam

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.

[Mecho]

Originally Posted by Zachery

Are you saying you were getting db errors after installing it? What errors?

the normal "mysql server gone" database error. so i meant addon was not working for me for unknown reason and i got lots of that db error in a second.

[Zachery]

What were the specific errors you were getting?

[Mecho]

i have stopped mysql service to check if i get 1 email only or attached by mysql server gone database error emails. i got tons of emails like usual .

[i156]

I added this plugin and it seemed to stop all emails being sent from the site. I removed the code and the file and my site still is not sending any emails (error emails, user registration emails, etc). What can I do to fix this?

[i156]

When I run the email diagnostics I get:

The mailing function returned an error while trying to send the mail.
The following errors were outputted by PHP when attempting to send mail:

Warning: 554 Unexpected response from SMTP server when ending transmission in ..../includes/class_mail.php on line 710

[kh99]

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?

[i156]

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.

[i156]

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.

[kh99]

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?

[i156]

Originally Posted by kh99

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.