Forum OpenACS Q&A: ticket error

Collapse
1: ticket error
Posted by Budi Wiyono on 06/11/01 01:39 PM
registered_proc blew up --- backtrace follows: Database
operation "select" failed (exception NSDB, "Query was not a statement
returning rows.") while executing "ns_db select $db $query" invoked
from within "set selection [ns_db select $db $query]"
Dear All,

I'm klik on http://127.0.0.1/ticket/, but error occure below.
How to fix ?

Thank You.

(file "/var/opt/www/pp1-dev/www/ticket/index.tcl" line 216) invoked
from within "source $ad_conn(file)"
(procedure "ad_handle_abstract_url" line 67) invoked from
within "ad_handle_abstract_url conn {}"Database operation "select"
failed (exception NSDB, "Query was not a statement returning rows.")
while executing "ns_db select $db $query" invoked from within "set
selection [ns_db select $db $query]" (file "/var/opt/www/pp1-
dev/www/ticket/index.tcl" line 216) invoked from within "source
$ad_conn(file)" (procedure "ad_handle_abstract_url" line 67) invoked
from within "ad_handle_abstract_url conn {}"

Collapse
2: Response to ticket error (response to 1)
Posted by John Lowry on 06/12/01 07:38 AM
You should be using /new-ticket/ rather than /ticket/. You can search the bboard archives for more background info on this.

I have to admit that I got this same error myself. It's not very well documented. I was just about to try to figure out how quick it would be to port /ticket/ to postgres when I came across previous posts on this issue in the bboard.

Collapse
3: Response to ticket error (response to 1)
Posted by Budi Wiyono on 06/19/01 04:50 AM
/ticket of OpenACS 3.2.5 could not working to...
Any idea ?

Thank You.

registered_proc blew up --- backtrace follows: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") while executing "ns_db select $db $query" invoked from within "set selection [ns_db select $db $query]" (file "/var/opt/www/myacs325/www/ticket/index.tcl" line 216) invoked from within "source $ad_conn(file)" (procedure "ad_handle_abstract_url" line 67) invoked from within "ad_handle_abstract_url conn {}"Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") while executing "ns_db select $db $query" invoked from within "set selection [ns_db select $db $query]" (file "/var/opt/www/myacs325/www/ticket/index.tcl" line 216) invoked from within "source $ad_conn(file)" (procedure "ad_handle_abstract_url" line 67) invoked from within "ad_handle_abstract_url conn {}"