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+. vB4 thread located here.

[Gladius2007]

I sure hope so.

[gwerzal]

should defo be part of the stock vb

Thank you

[Zachery]

Havent had any reported bugs yet, And Link14716 is curretly without interwebs.

Though we have plans to impliment the listed features and get this pushed out as a final shortly here.

[cheesegrits]

Thankyou thankyou thankyou. Thankyou.

Been having One Of Those Days (several in a row, actually), where I'm on the road and MySQL goes tits up ... thought my Crackberry was going to self destruct with the volume of vB error msgs.

Hoping this makes it into the core product ASAP.

-- hugh

[Zachery]

Originally Posted by cheesegrits

Thankyou thankyou thankyou. Thankyou.

Been having One Of Those Days (several in a row, actually), where I'm on the road and MySQL goes tits up ... thought my Crackberry was going to self destruct with the volume of vB error msgs.

Hoping this makes it into the core product ASAP.

-- hugh

Let us know how well its working

[Zachery]

Since we've had no reported issues, I'm pulling the beta tag.

[mahz]

Wow, great.

[MentaL]

isnt this default in vb?

[Zachery]

Originally Posted by MentaL

isnt this default in vb?

Nope, that is why we released it.

Right now, if there is a db error, your email will be sent 1 mail for every time someone visits the page with the db error message. (100 guests + 100 regulars) x 10-15 refreshes = lost of database error emails. This stops it dead cold, 10,000 page requests with the same database error, 1 mail is sent.

[MentaL]

vbulletin options
HelpError
Handling & Logging
--> Disable Database Error Email Sending