Improving detail in error reporting

bunner_bob

I'm logging PHP errors to a file on one of my sites (using a directive in an .htaccess file). Unfortunately the error messages aren't specific enough for me to track down where the user was when they occurred. I get something like

17-Oct-2005 09:13:39] PHP Fatal error:  SQL in /usr/www/users/earthcor/includes/classes/table_default.class.php on line 166

Which in this case just means a bad sql query, but I don't know where.

Is there a way to write more info - the exact URL for instance?

The relevant .htaccess lines are:
php_flag display_errors off
php_flag log_errors on
php_value error_log /usr/home/earthcor/php_error_logs/phperrors.txt

I probably need to build some kind of custom error handler, right? Any tips?

mmonaco

I'm pretty sure there is a way to customize the logs using symbols something like
%t %d %u - %e and so on. You'll have to look it up at the apache website...

In addition it would not hurt to check for errors at he line referenced in the log using mysql_error() or another such function.

Najjar

I would suggest that you add the "page name", "line number", and "query" to the
string whereever you are expecting an error like the database connection.
I used this in one of my applications it works fine.

bunner_bob

Actually I've got pretty detailed reports of MySQL issues - queries & db connections - thanks to using trigger_error() and echoing the query and $_SERVER['REQUEST_URI']. But I'm thinking about non-SQL problems.

For instance, I get a PHP error that a certain foreach() isn't being supplied the correct data type - but the particular foreach() being called is part of a generic code library, so I don't know which page called it, or on which line. If I could get the URL requested and add it to the "displayed" PHP error, since I'm NOT displaying but rather logging errors to a file, seems I could just read what the URL was in my error log file.

Perhaps I need to read more about custom error handlers...

I think the coolest option would be to get an email sent to me when a particular error occurs. I already have an email script - just need to get the data to send to it.