vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Administrative and Maintenance Tools - Suppress-o-Matic - Stop database error spam (https://vborg.vbsupport.ru/showthread.php?t=218620)

Link14716 08-03-2009 12:03 AM

This doesn't disable e-mail sending, this stops it from destroying your inbox. Pretty big difference.

Stopping DB error mails entirely is as simple as removing the technical address from config.php. No need for anything special for that, but this isn't what the mod does.

Zachery 08-03-2009 01:48 AM

Quote:

Originally Posted by MentaL (Post 1860422)
vbulletin options
HelpError
Handling & Logging
--> Disable Database Error Email Sending

Also doesn't stop connection, and crashed table emails if the system cannot connect or read the database.

There is a pretty big note about this.

GeekyDesigns 08-13-2009 01:14 PM

Updated the description text, should read much better.

matthewhotdude 08-13-2009 02:00 PM

Installed dunno if it works tho, anyway to test?

Trek 08-13-2009 10:34 PM

This is good, but I think it could be taken a little further. For instance, if you get an error, you get an email. But you don't get duplicates for X time after wards.

That works, but how do I know I have a REAL problem or not then? Meaning it could of just been a quick outage where a query failed for whatever reason. Or, it might be something really serious where things are completely down.

I guess what I'm saying is, maybe some way to email saying "We just received 350 error reports for this same error, you should check it out ASAP" type of message.

I dunno, maybe I'm not explaining it well but... hopefully it's enough to spark what I mean and maybe a better idea than only suppression.

Zachery 08-14-2009 09:14 PM

Quote:

Originally Posted by Trek (Post 1866803)
This is good, but I think it could be taken a little further. For instance, if you get an error, you get an email. But you don't get duplicates for X time after wards.

That works, but how do I know I have a REAL problem or not then? Meaning it could of just been a quick outage where a query failed for whatever reason. Or, it might be something really serious where things are completely down.

I guess what I'm saying is, maybe some way to email saying "We just received 350 error reports for this same error, you should check it out ASAP" type of message.

I dunno, maybe I'm not explaining it well but... hopefully it's enough to spark what I mean and maybe a better idea than only suppression.

Its a pretty good idea, we'll take it into consideration for sure :)

Zachery 08-15-2009 05:08 AM

Quote:

Originally Posted by matthewhotdude (Post 1866481)
Installed dunno if it works tho, anyway to test?

messup the config by using a bad password

Sarthek 08-16-2009 11:50 AM

Finally, some very useful mod. I tagged it for now, will give it a try in coming weeks.

Our "record" so far: over 18.000 emails in less than day.

janslu 09-10-2009 09:59 PM

I have it installed but I got php errors when my database had too many connections. The error logged was:
Code:

[10-Sep-2009 23:35:50] PHP Warning:  SQLiteDatabase::unbufferedQuery() [<a href='sqlitedatabase.unbufferedquery'>sqlitedatabase.unbufferedquery</a>]: near &quot;ORDER&quot;: syntax error in forum/includes/class_core.php on line 1015
[10-Sep-2009 23:35:50] PHP Fatal error:  Call to a member function fetch() on a non-object in forum/includes/class_core.php on line 1017

Any idea what might be the problem?

Line 1015 of modified class_core.php is:
Code:

                $sqlitequery = $sqlitedb->unbufferedQuery("SELECT * FROM dberrors WHERE time > ".(TIMENOW - $timebetweenerrors)." AND errorcode = ".$this->errno." ORDER BY time DESC");

Link14716 09-11-2009 02:37 AM

Quote:

Originally Posted by janslu (Post 1882845)
I have it installed but I got php errors when my database had too many connections. The error logged was:
Code:

[10-Sep-2009 23:35:50] PHP Warning:  SQLiteDatabase::unbufferedQuery() [<a href='sqlitedatabase.unbufferedquery'>sqlitedatabase.unbufferedquery</a>]: near &quot;ORDER&quot;: syntax error in forum/includes/class_core.php on line 1015
[10-Sep-2009 23:35:50] PHP Fatal error:  Call to a member function fetch() on a non-object in forum/includes/class_core.php on line 1017

Any idea what might be the problem?

Line 1015 of modified class_core.php is:
Code:

                $sqlitequery = $sqlitedb->unbufferedQuery("SELECT * FROM dberrors WHERE time > ".(TIMENOW - $timebetweenerrors)." AND errorcode = ".$this->errno." ORDER BY time DESC");

Try to change that line to
Code:

                $sqlitequery = $sqlitedb->unbufferedQuery("SELECT * FROM dberrors WHERE time > ".(TIMENOW - $timebetweenerrors)." AND errorcode = '".$this->errno."' ORDER BY time DESC");
I wish it gave more details about the syntax error so I could see exactly what its problem is.


All times are GMT. The time now is 04:33 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01167 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete