It shows you the full SQL error message and complete post-bind query in the TCL error string which gets dumped to the web page. So you don't have to go to the log to find it.
Before
Request Error
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
while executing
"ns_pg_bind 0or1row nsdb0 {
select first_name || ' ' || last_name as name, email
from persons, parties
where person_id = :user_id
and person_id = ..."
("uplevel" body line 1)
invoked from within
After
Request Error
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: Attribute 'first_name' not found
SQL:
select first_name || ' ' || last_name as name, email
from persons, parties
where person_id = '2604'
and person_id = party_id
while executing
"ns_pg_bind 0or1row nsdb0 {
select first_name || ' ' || last_name as name, email
from persons, parties
where person_id = :user_id
and person_id = ..."
("uplevel" body line 1)
Also, a mistake in my instructions - postgres.so is in /usr/local/aolserver/bin.
