phpBB3 Error Logging Tool

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
User avatar
intel352
Registered User
Posts: 27
Joined: Sat Jul 19, 2003 9:26 am
Location: NC, USA
Contact:

Re: phpBB3 Error Logging Tool

Post by intel352 »

i don't even see the need to keep a constant history. maybe 1 month max.

and if a log hits 1gb, someone is in serious trouble :-) many users would max out their hosting acct fast like that, lol
User avatar
3Di
Former Team Member
Posts: 16032
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: phpBB3 Error Logging Tool

Post by 3Di »

IMO this MOD is like a TOOL that's used for debugging purposes (see developpers/modders), I reached 150 MB in a month.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
intel352
Registered User
Posts: 27
Joined: Sat Jul 19, 2003 9:26 am
Location: NC, USA
Contact:

Re: phpBB3 Error Logging Tool

Post by intel352 »

Agreed this is geared mostly for devs, but even tho I'm not developing anything for phpBB, I still prefer to keep tabs on errors ;-)
User avatar
3Di
Former Team Member
Posts: 16032
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: phpBB3 Error Logging Tool

Post by 3Di »

Agreed, some kind of improvement then will be nice. ;)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: phpBB3 Error Logging Tool

Post by ham1299 »

Highway of Life wrote:How about per-week and not > 1GB. That way you could have 52 logs after a year instead of 365 log files. :P
That would be perfect! :)
Heather
User avatar
3Di
Former Team Member
Posts: 16032
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: phpBB3 Error Logging Tool

Post by 3Di »

Highway of Life wrote:It just needs to detect filesize and rotate once the file size reaches 1GB
2GB seems to be the maximum.. BTW.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
MartectX
Translator
Posts: 1324
Joined: Wed Dec 19, 2007 8:05 pm
Location: Marienplatz

Re: phpBB3 Error Logging Tool

Post by MartectX »

I keep getting loads of SQL errors recently... how can I enable the detailed admin output with the query and line of file executing it?
User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Seattle, WA
Name: David Lewis
Contact:

Re: phpBB3 Error Logging Tool

Post by Highway of Life »

OPEN config.php

ENABLE: DEBUG and DEBUG_EXTRA
The phpBB Weekly Podcast - Discussing the developments of phpBB4 and beyond.

New to phpBB3? Want to learn about programing?
Visit phpBB Academy at StarTrekGuide to learn how.
User avatar
MartectX
Translator
Posts: 1324
Joined: Wed Dec 19, 2007 8:05 pm
Location: Marienplatz

Re: phpBB3 Error Logging Tool

Post by MartectX »

Hmm... yes thanks but I meant just for logging in error.log (don't want to harass users with technobabble :D); I gave it a try and it works well thus far, now just wait till some errors get into my net:

OPEN includes/db/dbal.php

FIND

Code: Select all

	/**
	* display sql error page
	*/
	function sql_error($sql = '')
	{
		global $auth, $user, $config;
ADD, AFTER

Code: Select all

		// LOG SQL ERRORS
		global $phpbb_root_path;
FIND

Code: Select all

		if (!$this->return_on_error)
		{
			$message = 'SQL ERROR [ ' . $this->sql_layer . ' ]<br /><br />' . $this->sql_error_returned['message'] . ' [' . $this->sql_error_returned['code'] . ']';
ADD, AFTER

Code: Select all

			// LOG SQL ERRORS
			{
				$error_log = $phpbb_root_path . '/store/php_error.log';

				$backtrace = get_backtrace();

				$error_msg = 'SQL ERROR [ ' . $this->sql_layer . ' ]<br /><br />' . $this->sql_error_returned['message'] . ' [' . $this->sql_error_returned['code'] . ']';
				$error_msg .= ($sql) ? '<br /><br />SQL<br /><br />' . htmlspecialchars($sql) : '';
				$error_msg .= ($backtrace) ? '<br /><br />BACKTRACE<br />' . $backtrace : '';
				$error_msg .= '<br />';

				$error_timestamp = date('d-M-Y  H:i:s Z');
				error_log("[$error_timestamp] [phpBB SQL Debug]" . $error_msg . "\n", 3, $error_log);
			}
PS: I know this is rudimentary ^^
colnector
Registered User
Posts: 180
Joined: Tue Aug 19, 2008 5:04 pm
Contact:

Re: phpBB3 Error Logging Tool

Post by colnector »

Perhaps it's better to use PHP's error handlers to make sure all errors are caught. What happens, for example, if your database is down?
User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Seattle, WA
Name: David Lewis
Contact:

Re: phpBB3 Error Logging Tool

Post by Highway of Life »

That’s not the point of this tool. Please read the description.

Regarding the database, this tool does not rely on the database being online to operate.
The phpBB Weekly Podcast - Discussing the developments of phpBB4 and beyond.

New to phpBB3? Want to learn about programing?
Visit phpBB Academy at StarTrekGuide to learn how.
crazyfruitbat
Registered User
Posts: 9
Joined: Sun Nov 16, 2008 2:45 am

Re: phpBB3 Error Logging Tool

Post by crazyfruitbat »

hey guys, I have some major query issue on my board, I'm trying to get this installed to help figure out the cause tho it's my first mod install. I have looked up the how-to install mods area, but I am at a loss here.

Can someone post a basic how-to?

Thanks,
Chris
crazyfruitbat
Registered User
Posts: 9
Joined: Sun Nov 16, 2008 2:45 am

Re: phpBB3 Error Logging Tool

Post by crazyfruitbat »

Thank you very much! Perfect!
User avatar
Ahri89
Registered User
Posts: 524
Joined: Sat Apr 07, 2007 2:53 pm
Location: Spain
Contact:

Re: phpBB3 Error Logging Tool

Post by Ahri89 »

Thanks Highway of Life ^_^
MODs translated to Spanish: ACP Add User MOD, ACP Announcement Centre, Advertisement Management, Custom Profile Fields, Update Reminder, Flood time setting per forum, MOD Version Check, Posting template, Prune Log, Simple Trash Bin, TinyPic Plugin, User Reminder, View Profile, View your topics, and more...

Sorry for my bad english xD
Locked

Return to “[3.0.x] MOD Database Releases”