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]

No, you get one per error per 30 min by default. So if you only get one, and 30 min later you dont get another the error has resolved itself. If you continue to get them, you know there is a problem.

So if you got an error about a crashed table, and error 28, you'd get two emails. Instead of 2000 per min for all of your users trying to refresh.

[cravendale]

Originally Posted by Zachery

No, you get one per error per 30 min by default. So if you only get one, and 30 min later you dont get another the error has resolved itself. If you continue to get them, you know there is a problem.

So if you got an error about a crashed table, and error 28, you'd get two emails. Instead of 2000 per min for all of your users trying to refresh.

I have vB 4.0.6 and I ended up having to remove it.

I put the sqlitedberrors.sqlite in the sqlite folder and CHMODD both file and folder to 666 and I got this...

Fatal error: Call to a member function show_chatbox() on a non-object in /home/private/public_html/keptprivate.com/forum/includes/class_bootstrap.php(394) : eval()'d code on line 33


Any ideas?

[Zachery]

That is an issue with annother third party addon. Not sure how our edits c ause a problem with your chatbox, but they shouldn't have. Also, you are likely required to edit the file to 777 so it is writeable.

[Romamo]

I have a more simple decision: http://tracker.vbulletin.com/browse/VBIV-12105
Patch limits email sending to 1 per minute.

[Phaedrus]

So you'd have 60 e-mails if the same error repeated for an hour? I'd prefer two. I'm going to tag this for later use.

Danke.

[screenmates]

There is no reason for not including this in the core - this is less than 15 lines of code. vB can use a config flag set to default false so admins can turn it on if sqlite is supported in the hosting.

[Zachery]

I actually suggested this feature as far back as vB3.0 they were always plans, but it never happened.

[Joe Siegler]

I installed this, and have two issues. At the top of my forums, I'm now seeing this text:



It's at the top of every page. This wasn't there until I installed this plugin. Additionally, none of my users' avatars are showing.

I backed the mod out, and the weird characters went away, but some of my users avatars are still not showing.

Using vB 4.15. Any ideas?

[Leo777]

Originally Posted by Joe Siegler

I backed the mod out, and the weird characters went away, but some of my users avatars are still not showing.

It seems extremely unlikely that this mod 'Stop database error spam' is the cause of the problem, as it requires only 1 very small edit and couldn't affect avatars. I am guessing either it was another mod that you recently installed, or another change that you made to your forum (file edit, or template edit), or possibly a virus. But definitely not this mod. IMHO

[karel1985]

thanks, installed