Forum OpenACS Q&A: Response to Prototype Tool Error

Collapse
Posted by Jason Khong on
Taken from my server error log...
[26/May/2000:03:11:44][22198.8196][-conn4-] Error: Ns_PgExec: result status: 7 message: ERROR:  Relation 'user_tab_columns' does not exist

[26/May/2000:03:11:44][22198.8196][-conn4-] Error: nsd.tcl: Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_db 0or1row $db [db_sql_prep $sql]"
    invoked from within
"set selection [ns_db 0or1row $db [db_sql_prep $sql]]..."
    (procedure "database_to_tcl_string_or_null" line 2)
    invoked from within
"database_to_tcl_string_or_null $db $sql foo"
    invoked from within
"set table_length [database_to_tcl_string_or_null $db $sql foo]..."
    (procedure "max_col_length" line 5)
    invoked from within
"max_col_length $table_name $column"
    invoked from within
"set maxlength [max_col_length $table_name $column]..."
    (procedure "handle_textbox" line 4)
    invoked from within
"handle_textbox $column $eione $eitwo $value"
    invoked from within
"append form_html  [handle_textbox $column $eione $eitwo $value]..."
    ("textbox" arm line 1)
    invoked from within
"switch $form_type {
        textbox {append form_html  [handle_textbox $column $eione $eitwo $value] "

"}
        textarea {append form_html [ ..."
    (procedure "make_form" line 4)
    invoked from within
"make_form $column [set $form_var] [set $prompt_var] [set $eione_var] [set $eitwo_var]  [set $eithree_var] [set $error_var]"
    invoked from within
"append my_html "[make_form $column [set $form_var] [set $prompt_var] [set $eione_var] [set $eitwo_var]  [set $eithree_var] [set $error_var]]..."
    invoked from within
"if ![string compare [set $form_var] "date"] {
    #we are of type date. This requires special processing
#    ns_write "<tr><th valign=top align=right ..."
    ("foreach" body line 24)
    invoked from within
"foreach column $list_ord_cols {
    set form_var $column
    append form_var "_form_type"
    set form_type($column) [set $form_var]
    set prompt_va ..."
    (file "/web/gqcc/www/admin/prototype/tableinfo-3.tcl" line 113)
    invoked from within
"source $script"
    invoked from within
"if ![file exists $script] {
		ns_returnnotfound $conn
	} else {
		source $script
	}"
    (procedure "ns_sourceproc" line 3)
    invoked from within
"ns_sourceproc cns4 {}"