Forum OpenACS Q&A: Re: How do you tell OpenFTS to index existing ETP content?
The proc that does the sweep through this table takes each item and calls [acs_object_type $object_id], where object_id is the item_id inserted above. Unfortunately, the object type being returned is not etp_page_revision, it's content_item, and there's no binding for that.I think that the stuff that goes into the search_observer_queue should be content_revisions (or subtypes of content_revision), not content_items. So, I would try the query:
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;