when I try to view the tickets for all the project, I failed. Can
anyone help me to solve.
Thanks in advance.
[10/May/2000:11:10:55][413.33798][-conn18-] Error: Ns_PgExec: result
status: 7 message: ERROR: parser: parse error at or near ";"
[10/May/2000:11:10:55][413.33798][-conn18-] Error: dbinit:
error(localhost::yourdb,ERROR: parser: parse error at or near ";"
): 'select severity_enabled_p from ticket_projects where project_id='
[10/May/2000:11:10:55][413.33798][-conn18-] Error: Database operation
"1row" failed (exception NSDB, "Query was not a statement returning
rows.")
Database operation "1row" failed (exception NSDB, "Query was not a
statement returning rows.")
while executing
"ns_db 1row $db [db_sql_prep $sql"
(procedure "database_to_tcl_string" line 6)
invoked from within
"database_to_tcl_string $db "select severity_enabled_p from
ticket_projects where project_id=$project_id""
(procedure "ticket_severity_enabled_p" line 3)
invoked from within
"ticket_severity_enabled_p $project_id"
invoked from within
"if {[info exists project_id] && (![info exists display_project_p] ||
([info exists display_project_p] && !$display_project_p))} {
set severity_en..."
("uplevel" body line 22)
invoked from within
"uplevel {
set return_html ""
set last_priority "starting"
set count 0
append return_html "<table border=0 width=100%>
<tr bgcolor=lightgrey..."
(procedure "ticket_summary_display" line 2)
invoked from within
"ticket_summary_display"
invoked from within
"append results [ticket_summary_display]"
(file
"/var/lib/aolserver/servers/defaultacs/www/new-ticket/by-creation-user.tcl"
line 260)
invoked from within
"source $script"
(procedure "ns_sourceproc" line 6)
invoked from within
"ns_sourceproc cns328 {}"
10.35.16.65 - - [10/May/2000:11:10:55 +0800] "GET
/new-ticket/by-creation-user.tcl?project_id=&user_id=8 HTTP/1.0" 500
543
"http://10.35.16.65/new-ticket/by-creation-user.tcl?project_id=1&user_id=8"
"Mozilla/4.51 [en] (X11; I; Linux 2.2.5-15 i686)"
~
