Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Suppress-o-Matic - Stop database error spam Details »»
Suppress-o-Matic - Stop database error spam
Version: 1.00, by GeekyDesigns GeekyDesigns is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.8.x Rating:
Released: 07-14-2009 Last Update: 11-16-2009 Installs: 96
Code Changes Additional Files  
No support by the author.

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.

Download Now

File Type: zip DB Error Suppress-o-matic.zip (1.7 KB, 426 views)

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 09-08-2010, 05:12 PM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ZomgStuff View Post
Anyone try this on 4.0?
The author links to the 4.0 version in his description.
Reply With Quote
  #43  
Old 09-09-2010, 09:02 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ZomgStuff View Post
Anyone try this on 4.0?
https://vborg.vbsupport.ru/showthread.php?t=228146
Reply With Quote
  #44  
Old 09-19-2010, 11:42 AM
psychonikeo psychonikeo is offline
 
Join Date: Nov 2009
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Installed, but still get tons of mails?
Reply With Quote
  #45  
Old 10-11-2010, 10:43 PM
adwade adwade is offline
 
Join Date: Aug 2006
Location: SouthEast, TN
Posts: 323
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is "your base vBulletin directory"? Is that the /forums directory that it's referring to, or the one above it /public_html on the server?
Reply With Quote
  #46  
Old 10-12-2010, 07:12 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wherever you have your vBulletin files installed to, if all of the vBulletin files and folders are in the /forum/s directory than that is the correct one.

If you have the product installed and are getting tons of emails, check the permissions on your sqlite database.
Reply With Quote
  #47  
Old 10-22-2010, 06:10 PM
6impy 6impy is offline
 
Join Date: Oct 2001
Location: Seattle
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm having a similar issue as psychonikeo.

sqlitedberrors.sqlite has the right permissions.

I echo'ed out: DIR .'/sqlitedberrors.sqlite' and it has the correct path.

I took a look in the sqlitedberrors.sqlite file and nothing is changing.

SQLite is properly installed because error_log is not spitting out any PHP errors for unrecognized commands.

Is there any way to see what the result/error of a query is?
Code:
$sqlitedb->queryExec("INSERT INTO dberrors (time, error, errorcode, ipaddress, script) VALUES (".TIMENOW.", '".sqlite_escape_string($this->error)."', '".$this->errno."', '$ipaddress', '$scriptpath')");
Edit:
Could it be the version of SQLite I'm running?

PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c 272374 2008-12-31 11:17:49Z sebastian $
SQLite Library 3.3.7
---
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c 282740 2009-06-25 00:07:20Z scottmac $
SQLite Library 2.8.17
SQLite Encoding iso8859
Reply With Quote
  #48  
Old 10-23-2010, 06:30 PM
6impy 6impy is offline
 
Join Date: Oct 2001
Location: Seattle
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I fixed the problem I was having and thought I would share it with others who run into it.

For whatever reason, I needed to put the sqlitedberrors.sqlite file in a subfolder of the forum directory that was chmod'ed to 666 (sqlitedberrors.sqlite also being chmod'ed to 666)

e.g.
/path/to/web/forum/sqlite/sqlitedberrors.sqlite

instead of:
/path/to/web/forum/sqlitedberrors.sqlite

Then I modified the very first line of modified code (below the comments) that goes into /includes/class_core.php from:
Code:
if ($sqlitedb = new SQLiteDatabase(DIR .'/sqlitedberrors.sqlite', 0666, $sqliteerror)) {
to (look after the DIR part for the added subfolder)

Code:
if ($sqlitedb = new SQLiteDatabase(DIR .'/sqlite/sqlitedberrors.sqlite', 0666, $sqliteerror)) {
It's working perfectly and now I don't get hundreds of text messages when my database goes down.

Cheers,
Drew
Reply With Quote
  #49  
Old 10-23-2010, 10:21 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

sounds like a permission error on the host OS/PHP more than SQLite.
Reply With Quote
  #50  
Old 10-24-2010, 01:04 AM
6impy 6impy is offline
 
Join Date: Oct 2001
Location: Seattle
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That could be the case, but I tried changing ownership of the file and giving 777 to it. Nothing seemed to allow an update the content of the sqlite file. It would always spit out a query error on the insert. I even tried writing completely separate sqlite code to test it out. It only worked when I stuck it in a folder that was also writable.

Anyway, it may be of help to someone else...
Reply With Quote
  #51  
Old 10-27-2010, 12:40 AM
adwade adwade is offline
 
Join Date: Aug 2006
Location: SouthEast, TN
Posts: 323
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BirdOPrey5 View Post
I've been lucky enough to not ever need this, but now installed just in case- thanks.
DITTO!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:02 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05091 seconds
  • Memory Usage 2,337KB
  • Queries Executed 27 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete