Forum OpenACS Q&A: Re: About Setting Up OpenFTS

Collapse
Posted by James Bennin on
Well I guess you can say I'm still in the beginning of fully setting up OpenACS. I was trying to install the Full Text Search OpenFTS option and was following every step. So I finished mounting the OpenFTS package. I noticed the error after creating and mounting the new folder called "search". After restarting the server, I looked on the error log and I saw this message:

[12/Aug/2003:10:33:23][2269.16387][-sched-] Error: Database operation "0or1row" failed (exception NSINT, "Query returned more than one row.")

SQL:
        select package_id from apm_packages where package_key = 'search'

Database operation "0or1row" failed (exception NSINT, "Query returned more than one row.")

SQL:
        select package_id from apm_packages where package_key = 'search'

    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 60 search_indexer {} 1060691543 0 t}"

What is the problem? How do I fix this? I hope I was very specific and the information I provided helps you.