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!


All times are GMT. The time now is 08:07 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.01772 seconds
  • Memory Usage 1,746KB
  • 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
  • (3)bbcode_code_printable
  • (3)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