Forum OpenACS Q&A: Search not picking up messages automatically

Collapse
1: Search not picking up messages automatically
Posted by Randy Ferrer on 08/02/03 09:49 PM

Hi - I'm running the blogger and have installed the sc facilities and the search set-up looks good. Problem is I have to do the following to get Search to pick-up entries (thanks to Dave Bauer):

insert into search_observer_queue (select entry_id, now(), 'INSERT' from pinds_blog_entries);
 
select * from search_observer_queue;
To see what is in the search queue - and

select count(*) from txt;
To see the number of succesful insertions.

It just won't happen on it's own. Any ideas?

Collapse
2: Re: Search not picking up messages automatically (response to 1)
Posted by Randy Ferrer on 08/07/03 03:56 AM
This problem still persists. I don't get what's going on but it just won't do it automatically. Has anyone run into this or have any ideas?
Collapse
3: Re: Search not picking up messages automatically (response to 1)
Posted by Dave Bauer on 08/07/03 04:02 AM
Randy,

You need to make sure there is a trigger on the pinds_blog_entries table.

I don't know if this is created automatically or not. I think it depends on which version you are using.

Collapse
4: Re: Search not picking up messages automatically (response to 1)
Posted by Randy Ferrer on 08/07/03 04:12 AM

Hi Dave - Not sure if one if these is the right one, checking that now. Thanks for the tip...

Triggers: pinds_blog_entries__dtrg,
          pinds_blog_entries__itrg,
          pinds_blog_entries__utrg
Collapse
5: Re: Search not picking up messages automatically (response to 1)
Posted by Randy Ferrer on 08/07/03 04:17 AM

Looks right. This is what was installed when I applied the ...sc-create.sql script. I'm using version 0.8.7.... 😟(((

Collapse
6: Re: Search not picking up messages automatically (response to 1)
Posted by Dave Bauer on 08/07/03 04:22 AM
Hmmm.

Check yoursite/acs-service-contract to make sure the FtsContentProvider service contract for pinds_blog_entry is installed correctly.

Collapse
7: Re: Search not picking up messages automatically (response to 1)
Posted by Randy Ferrer on 08/07/03 04:43 AM

Yup - looks good. I'm really at a loss here.