Forum OpenACS Q&A: Re: Problem and a doubt with the Search package.

3: Re: Problem and a doubt with the Search package. (response to 2)

Posted by Emmanuelle Raffenne on 07/03/07 04:27 PM

Hi Jorge,

I'm glad to see you around :).

Regarding the missing template dotlrn-search and the missing search::url callback implementation in file-storage, both have been fixed on the oacs-5-3 branch and those fixes will be included in the next release (dotlrn 2.3.1). You can update your local installation of file-storage and search from the repository using the oacs-5-3 tag.

5: Re: Problem and a doubt with the Search package. (response to 3)

Posted by Jorge Couchet on 07/03/07 04:37 PM

Hi Emmanuelle!

I'm around with some troubles 😊

Excellent! I'm doing that you suggest and reporting the advances.

Cheers

Jorge

6: Re: Problem and a doubt with the Search package. (response to 3)

Posted by Jorge Couchet on 07/03/07 05:20 PM

Hi Emmanuelle,

The actual versions of file-storage and search that I have are:

File Storage (FS): 5.3.0d1
Search: 5.3.1

Those versions are under the oacs-5-3 branch. If I try to upgrade through acs-admin/install/ (using "Upgrade from repository"), I have the message: "No packages on your system need upgrading." And if try to reload the package through the APM, I have the message: "There are no changed files to reload in this package.".

Under the oacs-5-4 branch, the FS version changes to 5.4.0d4 and the Search version didn't change. Is the 5.4.0d4 version of FS that I need to install?. If the answer is yes, which is the procedure for that?.

Cheers

Jorge

7: Re: Problem and a doubt with the Search package. (response to 6)

Posted by Emmanuelle Raffenne on 07/03/07 05:40 PM

Jorge,

I assume you installed from the 2.3.0 tarball. In this case, to upgrade from the repository:

- cd to your packages/ directory (/var/lib/aolserver/service0/packages?)
- remove file-storage/ and search/ directories
- from your packages/ directory, type:

cvs -d :pserver:mailto:anonymous@cvs.openacs.org:/cvsroot co -r oacs-5-3 search
cvs -d :pserver:mailto:anonymous@cvs.openacs.org:/cvsroot co -r oacs-5-3 file-storage

- restart your server

8: Re: Problem and a doubt with the Search package. (response to 7)

Posted by Jorge Couchet on 07/03/07 06:13 PM

Emmanuelle,

Excellent! Your instruction worked very well!!. Thanks a lot!

Only remains a problem:
I have searched the word "Estrategia" that is in the Forum and Faq, and the search brought me what is in Forum, but not that is in FAQ. It would seem to be that the Search Package isn't indexing the FAQ's content. Is there any extra trick in order to have the FAQ's content indexed?.

Cheers

Jorge.

9: Re: Problem and a doubt with the Search package. (response to 8)

Posted by Jorge Couchet on 07/03/07 06:43 PM

Well, I have inserted in the search_observer_queue the FAQ:

***************
insert into search_observer_queue ( select entry_id, current_timestamp, 'INSERT' from faq_q_and_as );
***************

And now the content of the FAQ is indexed. But if I put a new question with the word "estrategia" in the FAQ, the new question didn't appear in the search. It would seem to be that is failing the automatic indexing. Any clue for this?.

10: Re: Problem and a doubt with the Search package. (response to 9)

Posted by Jorge Couchet on 07/03/07 10:03 PM

Reading the document that states how to make an object searchable (in OpenACS documentation) appears the following:

**********
"if your object type uses the content repository to store its items, then you are done. If not, an extra step is required to inform the search_observer_queue of new content items, updates or deletions. We do this by adding triggers on the table that stores the content items of your object type"
**********

Isn't the FAQ package using the Content Repository and is necessary to add manually to the FAQ table the triggers to inform the search_observer_queue?.

11: Re: Problem and a doubt with the Search package. (response to 10)

Posted by Emmanuelle Raffenne on 07/04/07 11:29 AM

Jorge,

I don't think FAQ is using the content repository. The triggers to fill up the search_observer_queue table are missing in the FAQ package, that's why the content is not indexed.

12: Re: Problem and a doubt with the Search package. (response to 11)

Posted by Jorge Couchet on 07/04/07 01:16 PM

Emmanuelle,

Thanks a lot!! I'm adding the triggers to the FAQ Package!

13: Re: Problem and a doubt with the Search package. (response to 12)

Posted by Jorge Couchet on 07/04/07 03:22 PM

Ready! The content of the FAQ Package is now indexed automatically. For that I have added the following in the database:

******************

create function faq_sc__itrg ()
returns opaque as '
begin
perform search_observer__enqueue(new.entry_id,''INSERT''); return new;
end; ' language 'plpgsql';

create function faq_sc__dtrg ()
returns opaque as '
begin
perform search_observer__enqueue(old.entry_id,''DELETE''); return old;
end; ' language 'plpgsql';

create function faq_sc__utrg ()
returns opaque as '
begin
perform search_observer__enqueue(old.entry_id,''UPDATE''); return old;
end; ' language 'plpgsql';

create trigger faq_sc__itrg after insert on faq_q_and_as for each row execute procedure faq_sc__itrg ();

create trigger faq_sc__dtrg after delete on faq_q_and_as for each row execute procedure faq_sc__dtrg ();

create trigger faq_sc__utrg after update on faq_q_and_as for each row execute procedure faq_sc__utrg ();

******************

Thanks a lot for the help!

Jorge.

14: Re: Problem and a doubt with the Search package. (response to 13)

Posted by Emmanuelle Raffenne on 07/11/07 11:57 AM

Thanks Jorge. I've added the triggers to the repository at the oacs-5-3 branch.

15: Re: Res: Re: Problem and a doubt with the Search package. (response to 14)

Posted by Jorge Couchet on 07/11/07 02:51 PM

Emmanuelle, you are welcome!!!