Forum OpenACS Q&A: How to interpret error logs

Collapse
1: How to interpret error logs
Posted by Dave Bauer on 11/30/00 01:55 AM
When I get an error message such as:
[29/Nov/2000:22:06:35] Error: Filter bboard_restrict_access_to_group returned error #1: Database operation "1row" failed (exception NSDB, "Query was not a statement returning rows.")

How do I know what page or whatever is causing this error? I also get errors like this one:

[27/Nov/2000:14:19:57] Error: Ns_PgExec: result status: 7 message: ERROR: parser: parse error at or near "("

I don't know where to begin to look to track this down. How do I determine what SQL statement caused these errors?

Collapse
2: Response to How to interpret error logs (response to 1)
Posted by Don Baccus on 11/30/00 03:50 AM
Go read the documentation for database pools.  You can either log every SQL statement or those that fail, only.  Both are useful for debugging ...