Forum OpenACS Q&A: Getting all of my SQL query logged on error?

Collapse
1: Getting all of my SQL query logged on error?
Posted by Shalon Wood on 04/26/01 07:37 PM
I'm adding an experience point system to ACS for my site (something
like the system on www.perlmonks.org). I'm getting an error when I try
to look something up, however -- the database is returning more than
one row. Looking at the data in my tables, it *shouldn't* be possible,
so I need to manually run the query and see what the output is.

However, when the ns_db 1row error is logged, it cuts off the query
*before* the where clause, so I don't know what values are being used.

Is there any way to get all of that logged?

Shalon Wood

Collapse
2: Response to Getting all of my SQL query logged on error? (response to 1)
Posted by Don Baccus on 04/26/01 07:41 PM
Set "verbose" to "true" in the database pool in which you're executing the query.  That will cause the driver to write it to the log file.
Collapse
3: Response to Getting all of my SQL query logged on error? (response to 1)
Posted by Shalon Wood on 04/26/01 08:17 PM
Thanks. I had Verbose turned on for everything *except* the main pool.