You have to rebuild the search_observer_queue table with pointers to your contents. I once used the following queries (I don't remember who posted them on the forum).
To reindex edit-this-page contents:
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);To reindex file-storage contents:
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 = 'file_storage_object' and
r.revision_id = i.live_revision and
(mime_type = 'application/pdf' or
mime_type = 'application/msword' or
mime_type = 'application/vnd.ms-word' or
mime_type = 'application/excel' or
mime_type = 'application/vnd.ms-excel' or
mime_type like 'text/%'));To reindex news contents:
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 = 'news' and
r.revision_id = i.live_revision);Hope this helps.
