Forum OpenACS Q&A: Re: open FTS & tsearch

As you pointed it has a simple solution. The $libdir was not correctly set.

Thank you, I was confused with this. 😊

After setting it everything has been right. Now I'm trying to index existing etp content, with some difficulties...

I'm trying with this:

insert into search_observer_queue(select revision_id, current_timestamp, 'INSERT' from cr_revisions r,cr_items i where r.item_id=i.item_id and i.content_type='etp_page_revision' and r.revision_id = i.live_revision);

and, even, with some more like this:

insert into search_observer_queue(select revision_id, current_timestamp, 'INSERT' from cr_items i where i.content_type='content_folder');

with no success.

Any ideas ?

Thanks in advance.