Forum .LRN Q&A: Site-wide-search?

Collapse
Posted by Bruno Mattarollo on

I try to "search" in a forum I just created in dotLRN 1.0 and this is the error I get:

Request Error


        
ora8.c:3908:ora_tcl_command: error in `OCIStmtExecute ()': ORA-20000: interMedia Text error:
DRG-10599: column is not indexed

SQL: 
            select forums_messages.*,
                   person.name(forums_messages.user_id) as user_name,
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
                   score(1) as the_score
            from forums_messages,
                 forums_forums
            where forums_forums.forum_id = :forum_id
            and forums_forums.package_id = :package_id
            and forums_messages.forum_id = forums_forums.forum_id
            and forums_messages.state = 'approved'
            and contains(forums_messages.content, '%' || :search_text || '%', 1) > 0
            order by the_score desc,
                     forums_messages.posting_date desc
        
    while executing
"ns_ora select nsdb0 {
            select forums_messages.*,
                   person.name(forums_messages.user_id) as user_name,
                   t..."
    ("uplevel" body line 1)
    invoked from within

Should I install site-wide-search from openacs 4.6 and mount it under "search"?

Collapse
2: Re: Site-wide-search? (response to 1)
Posted by Bruno Mattarollo on

To reply to my own message, I have been looking at the code and found forums/sql/oracle/forums-search-create.sql and I messing with this file now! :).

always exhaust your search before asking a question ... Sorry! :(