Thanks Jeff,
I remvoed the secound search but I get still the error (sorry for posting whole message!):
Error: Database operation "0or1row" failed (exception NSINT, "Query returned more than one row.")
Database operation "0or1row" failed (exception NSINT, "Query returned more than one row.")
while executing
"ns_pg_bind 0or1row nsdb0 {
select package_id from apm_packages where package_key = :package_key
}"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
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]
}"
(procedure "db_string" line 7)
invoked from within
"db_string apm_package_id_from_key {
select package_id from apm_packages where package_key = :package_key
} -default 0"
(procedure "apm_package_id_from_key_mem" line 2)
invoked from within
"apm_package_id_from_key_mem search"
("eval" body line 1)
invoked from within
"eval $script"
invoked from within
"ns_cache eval util_memoize $script {
list $current_time [eval $script]
}"
(procedure "util_memoize" line 20)
invoked from within
"util_memoize "apm_package_id_from_key_mem $package_key""
(procedure "apm_package_id_from_key" line 2)
invoked from within
"apm_package_id_from_key search"
(procedure "search_indexer" line 3)
invoked from within
"search_indexer"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 43)
invoked from within
"ad_run_scheduled_proc {f f 30 search_indexer {} 1033473296 0 t}"
Debug: db_qd_get_fullname: following query in file: packages.acs-tcl.tcl.request-processor-procs proc: root_of_host