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

Collapse
2: Re: About Setting Up OpenFTS (response to 1)
Posted by Dave Bauer on 08/12/03 04:13 PM
James,

Plese tell us more so we can help you. Specifically, what were you doing when the error occured. What did you expect to happen, and what happened instead. That is elaborate on what "everything worked" means and give more information on what went wrong.

Turn on VERBOSE LOGSQLERRORS in the database driver section of your aolserver config file.

Please post the actual query that caused the error. If you check the log file and have verbose and logsqlerrors set to true the entire query will show in the log. You might have to scroll back a bit to find it.

Feel free to post the relevant section from the log. Use the HTML format and place the log between <PRE></PRE> tags.

Collapse
3: Re: About Setting Up OpenFTS (response to 2)
Posted by James Bennin on 08/12/03 04:30 PM
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.