Forum OpenACS Development: Re: Problem with searching "Static Pages"

Collapse
Posted by Ola Hansson on
I just wanted to report that it worked perfectly once I dropped and recreated the search_observer_queue with the new timestamptz datatype AND once I populated the queue with the proper page *revisions* instead of page *items* as I did before.

BTW, I committed some changes to the search triggers in the CR so that deleted and edited static pages get unindexed/reindexed. All in all, though, the triggers act kind of mysteriously in some cases and sometimes insert duplicate 'INSERT' or 'UPDATE' or 'DELETE' tuples into the queue. But I haven't noticed any immediate ill effects from that ... I tested ETP and it too seemed to work after the changes (knock wood).