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"?