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)

BirdOPrey5 09-08-2010 05:12 PM

Quote:

Originally Posted by ZomgStuff (Post 2095484)
Anyone try this on 4.0?

The author links to the 4.0 version in his description.

Zachery 09-09-2010 09:02 PM

Quote:

Originally Posted by ZomgStuff (Post 2095484)
Anyone try this on 4.0?

https://vborg.vbsupport.ru/showthread.php?t=228146

psychonikeo 09-19-2010 11:42 AM

Installed, but still get tons of mails?

adwade 10-11-2010 10:43 PM

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?

Zachery 10-12-2010 07:12 PM

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.

6impy 10-22-2010 06:10 PM

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

6impy 10-23-2010 06:30 PM

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

Zachery 10-23-2010 10:21 PM

sounds like a permission error on the host OS/PHP more than SQLite.

6impy 10-24-2010 01:04 AM

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...

adwade 10-27-2010 12:40 AM

Quote:

Originally Posted by BirdOPrey5 (Post 2066108)
I've been lucky enough to not ever need this, but now installed just in case- thanks.

DITTO!

ehd 12-02-2010 10:12 AM

hm...different one here.

I got emails with the db-errors, but also the sqlite-file was modifed und data has been inserted.

Why do I still get emails? Is there a way to check this?

Thx

Zachery 12-02-2010 08:14 PM

What were the emails that you got?

ehd 12-03-2010 02:51 AM

just the normal error-message you get when an error occurs.

I'll go into more details here.

I got the error-mails (board has another language though, but that wouldn't matter?)
and then I checked the sqlite-file.
It was last modified at the date of the db-error.
then I downloaded it and checked if there was an entry. And I could find the ip of the last db-error.

[edit] Just one IP, in the mails were more...[/edit]

That's quite strange, the db file has been accessed, but the mails were still sent... hm..

Here's the message, but that's the standard-one, which I got 10 times. With the same timestamp. Just a little error, normally I get more. It only differs in ips and paths.

Quote:

Datenbankfehler in vBulletin :


mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11)
/var/www/xxx/forum/includes/class_core.php on line 311


MySQL-Fehler :
Fehler-Nr. :
Fehler-Zeit : Wednesday, 24.11.2010 @ 10:32:01
Datum : Wednesday, 24.11.2010 @ 10:32:01
Skript : http://www.xxx/forum/ajax.php
Referrer : http://www.xxx/forum/xxx
IP-Adresse : 62.154.195.71
Benutzername :
Klassenname : vB_Database
MySQL-Version :

ehd 12-12-2010 02:52 PM

OK, strange enough: the last times I had db-errors there was only one mail.
And there always one entry in the sqlite-DB.

Floezen 01-25-2011 11:14 AM

I installed this Plug-In about 2 weeks ago without problems.

Now, that there seemed to occur some database error, the error mail says: To many Connections.

But the page shows following:

Quote:

Warning: SQLiteDatabase::queryExec() [sqlitedatabase.queryexec]: unable to open database file in /path_to_dir/httpdocs/includes/class_core.php on line 1032

Warning: SQLiteDatabase::queryExec() [sqlitedatabase.queryexec]: unable to open database file in /path_to_dir/httpdocs/includes/class_core.php on line 1038
Is that what it is supposed to show???

Regards
Florian

Zachery 01-26-2011 05:31 PM

Did you set the permissions correctrly?

Floezen 02-14-2011 08:26 PM

I would say, yes:

Code:

-rw-rw-rw-  1 user psacln    5120 Jan  3 23:35 sqlitedberrors.sqlite

Zachery 02-15-2011 09:51 PM

Did you try 777?

Romamo 05-17-2011 01:55 AM

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

6impy 05-17-2011 03:59 AM

Thanks for sharing!

Zachery 05-19-2011 09:39 PM

Quote:

Originally Posted by Romamo (Post 2196591)
I have a more simple decision: http://tracker.vbulletin.com/browse/VBIV-12105
Patch limits email sending to 1 per minute.

Doesn't your fix disable other error emails as well? You can configure your email error limit. You only get one email per error type per X time period.

realmr 08-21-2011 04:58 PM

I am getting error, up on adding as mentioned in the instructions:

Code:

Fatal error: Class declarations may not be nested in /home/frm1/public_html/forum/includes/class_core.php on line 1103

Hornstar 04-25-2012 07:12 PM

Can't believe I've only found this now. This is really good.

Zachery 04-25-2012 08:04 PM

Some users might be having problems (depending on their setup)

We'll look at updating the product in the near future.

In the short run, you can move the sql file into its own folder and chmod it. You'll need to update the code manually to reflect this.

creative-friend 09-12-2013 06:48 PM

Will This work in 4.x.x....??

Zachery 09-12-2013 07:01 PM

There is a vB4 version https://vborg.vbsupport.ru/showthread.php?t=228146


All times are GMT. The time now is 01:05 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.01411 seconds
  • Memory Usage 1,776KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (26)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