[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 : http://www.vbulletin.org/forum/showp...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

[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