Forum OpenACS Q&A: Re: troubles with openfts

9: Re: troubles with openfts (response to 1)

Posted by Gilbert Price on 01/06/03 04:03 AM

Has there been any information for getting openfts indexing and searching through the forums package? I'm using 4.6 and I didn't see anything in the forums/sql directory that looks like notes-sc-create.sql...

Any information about how openacs.org got openfts search working for the forums will be greatly appreciated.

Also, I'm betting ETP is another one of those apps not searched by openfts. If not, has anybody done the work to get openfts and ETP working together?

Thanks...

10: Re: troubles with openfts (response to 9)

Posted by Bart Teeuwisse on 01/06/03 04:41 AM

Gilbert,

you'll find the necessary files in the openacs.org-dev repository. These changes haven't been comitted to openacs-4 repository. Checkout a copy of the packages/forums/sql/postgresql/ directory in the openacs.org-dev repository and move the forums-sc-create.sql and forums-sc-drop.sql files to your openacs-4 copy of the forums package.

Then run the forums-sc-create.sql script in your database to enable openfts searching.

The ETP pages are searchable by virtue of the content repository (CR). However, link to the indexed content as returned by the content repository uses CR templates. If that is not what you want then read https://openacs.org/forums/message-view?message_id=68487.

/Bart

11: Re: troubles with openfts (response to 10)

Posted by Geert De Witte on 04/29/03 04:42 PM

Bart,

I've been to http://cvs.openacs.org/cvs/openacs-4/packages/forums/sql/postgresql/ to try and pick up the 2 SQL files you refer to, but they don't seem to exist. Am I looking in the right place? If not, could you possibly let me know where I can get hold of them

TIA
Geert

12: Re: troubles with openfts (response to 11)

Posted by Bart Teeuwisse on 04/29/03 09:24 PM

Geert,

you'll find the files in the openacs.org-DEV repository:

http://cvs.openacs.org/cvs/openacsorg-dev/packages/forums/sql/postgresql/

/Bart