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.

[Zachery]

Originally Posted by Vaupell

Ty needed it,, when playing with the db etc spam is crazy. .

EDIT : currently uninstalled.. didnt stop mail spam from new db errors, while site runs rc1 same with rc2.

You sure? we've tested this and it was working for us. IF the errors are different, you'll get multiple emails sitll.

[CvP]

Hi Zachery.
Installed on 4.0.2.
but how do I test it?

[FractalizeR]

Stop your SQL server

[CvP]

Originally Posted by FractalizeR

Stop your SQL server

lol..yeah..that'd work

[x1421]

Hi,
it is not working for me.

I get this error:

Fatal error: Class 'SQLiteDatabase' not found in /var/www/...../includes/class_core.php on line 1103

sqlitedberrors.sqlite is uploaded to my base vBulletin directory (domain.com/sqlitedberrors.sqlite) and its given 666 permission.

What is wrong?
(i have vb 4.0.4)

Regards,
x1421

[Zachery]

You don't have SQLite support in your php installation.

[Webbstre]

Thank you for this... I'll have to wait until something else breaks, but hopefully this will take care of my mass e-mail problem when errors happen :P

[Leo777]

This wasn't working for me, the sqlitedberrors file wasn't writeable despite having the correct permissions. Maybe this was due to some obscure setting on our hardened-security server. Fortunately I found the solution by following the advice of another person with the same problem, they posted the solution on the VB3 version of this mod : https://vborg.vbsupport.ru/showpost....9&postcount=47

Using that post's advice, I moved the sqlitedberrors file to a subdirectory and adjusted the path in the code, the problem was immediately solved.

ps. earlier in this thread someone asked about how to test this mod and a suggestion was to stop the SQL server. That would work but for most people it's probably easier to just edit the /includes/config.php and change the database settings to give an incorrect username. Then visit your forum homepage 5 times, if you get more than 1 email then this mod isn't working.

Thanks for the great mod, I'm using it with 4.0.8 and can't believe this STILL hasn't been included in core.

[Zachery]

That does sound like a server security issue. Not sure why it shouldn't work right Glad you found out why.

This was on someones todo list in the early vB3 days (at my suggestion), but never got included.

[cravendale]

Hi,

So do I get any emails at all once this is installed and working?
If not how exactly do I gain the information I need to problem solve potential vital errors?

thanks