Forum OpenACS Q&A: Re: How do you tell OpenFTS to index existing ETP content?

3: Re: How do you tell OpenFTS to index existing ETP content? (response to 1)

Posted by Janine Ohmer on 01/04/04 09:07 PM

Thanks, Dave.

I did that and had 65 items in search_observer_queue. Now, some time later, the table is empty but searching for common words isn't finding any hits. Obviously some sort of sweep has run, but didn't succeed in indexing.

I don't see any relevant errors in the error log. Is there somewhere I can look to see what went wrong? I suspect this is an FAQ, but there are so many hits for OpenFTS that I can't find an actually helpful thread.

TIA!

5: Re: How do you tell OpenFTS to index existing ETP content? (response to 3)

Posted by Malte Sussdorff on 01/05/04 07:30 PM

Is the ETP Service Contract installed? You should have a line in you /acs-service-contract page that states:

FtsContentProvider etp_page_revision etp_page_revision edit-this-page Uninstall

If this is the case, check if the procedure to insert the ETP content into OpenFTS is working. Check if this returns a procedure description.

/api-doc/proc-view?proc=AcsSc%2eftscontentprovider%2edatasource%2eetp%5fpage%5frevision

At least this got it to work for myself.

6: Re: How do you tell OpenFTS to index existing ETP content? (response to 5)

Posted by Janine Ohmer on 01/05/04 09:08 PM

Malte, you may be on to something here.

I have the FtsContentProvider bindings for edit-this-page, but mine are called journal_issue, journal_article, news_item and dotlrn_page. I didn't configure this site so I'm not exactly sure where those came from; I'm guessing that they are the currently defined content types. I *don't* have one for etp_page_revision, nor any obvious way to create one. I also don't have the procedure you referenced.

Hmm.... etp_page_revision is defined in edit-this-page sql/postgresql/edit-this-page-sc-create.sql, but not in the Oracle version. This appears to be true in 5.0 as well. Anyone know if this is intentional, or is this perhaps why search isn't working for me?

7: Re: How do you tell OpenFTS to index existing ETP content? (response to 6)

Posted by Malte Sussdorff on 01/05/04 09:15 PM

The journal_issue, journal_article and such are *not* working for ETP. No clue why, but well.

ETP runs on Oracle? Furthermore, since when does OpenFTS run on Oracle ;). So, just execute the edit-this-page-sc-create.sql and off you should go.