Forum OpenACS Q&A: Re: Request error when doing a user search

Collapse
Posted by tool who on
i just installed and loaded the site-wide search package and am getting a similar error when doing a search:

ora8.c:3909:ora_tcl_command: error in `OCIStmtExecute ()': ORA-00904: invalid column name
SQL: select !>>>!im_convert(:query_string) from dual
    while executing
"ns_ora 0or1row nsdb0 {select im_convert(:query_string) from dual}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_ora $type $db $sql] $args"
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
set selection [db_exec 0or1row $db $full_name $sql]
    }"