Search | Search Adv | Versions

Is FC caching to files??????

Issue SOLVED:

The problem was that we still had old entries in tables:

jos_flexicontent_items_versions
jos_flexicontent_items_ext

The search retrieved data from this tables.
When I deleted the faulty data the problem was gone!

So, search does in fact query this two tables.

Issue NOT SOLVED

Sorry but after if I remove lines from this tables some original content disappeared.

So whats wrong?

How can we safely remove content versions from _flexicontent_items_versions?

How can we safely remove lines from _flexicontent_items_ext search_index column - After purge, still can find data here ?

Thanks in advance

The table jos_flexicontent_items_versions is not used during search

The table jos_flexicontent_items_ext is used during search
-- it contains the Search index for title and description (plus the Extended data of every item)

You should never manually delete anything from those tables

So, you mean that in the search unpublished items were included ?

ggppdk wrote: So, you mean that in the search unpublished items were included ?

No, I mean:

Search view print the value present in jos_flexicontent_items_ext column search_index - Not the item description.

Our problem:

If we edit an item the new value for search_index its not recalculated

Advanced Search view shows descriptions of an outdated item description(retrieved from search_index!!)

In Advanced Search view if we click the item the resulting item view is correct

So, the problem is that we cant recalculate the new search_index value when saving an item.

How can we solve this?
Thanks in advance

search uses exactly this column the search-index,

but this column in the table #__flexicontent_items_ext should be updated on every save.

do you use versioning?
is the new version approved when you save the item, i mean is the one saving the item able to publish and thus able to change item current version?