[TYPO3-english] indexed_search + deleted tt_news

Luc Muller l.mul-nospam-ler at ameos.com
Tue Nov 30 16:10:26 CET 2010


 > Deleted news could probably be removed from the indexed search with a
 > tcemain hook, but that would not catch e.g. news with a time setting.
 > The param for the news id is hidden in a blob field and there aren't any
 > tags or similar ways to only kill the affected news..

=> I already think about that. I found all the hooks needed, but despite 
this. I did not find any field in the index_search tables where the UID 
of the tt_news is clearly stored.

Of course there is a field where are serialised the get Params that 
should be used with the link to display, but it's not usable to make 
something like.

DELETE "all index_search_info" WHERE itemUid = "id of my news" AND 
item_type = "tt_news";

of course, you have to translate this in real SQL statements.

Luc Muller

Le 22/11/2010 14:34, Andreas Kiessling a écrit :
> Hi,
>
> i've played with indexed_search and crawler in the last days after
> reading your thread.
> But unfortunately, i have not found a way to get this fixed...
> I will probably have to kill the index cache for the page with a cronjob
> and start a reindexing with the crawler or just wget...
>
> Some sort of index validation would be really useful there.
>
> Deleted news could probably be removed from the indexed search with a
> tcemain hook, but that would not catch e.g. news with a time setting.
> The param for the news id is hidden in a blob field and there aren't any
> tags or similar ways to only kill the affected news...
>
> Regards,
> Andreas
>



More information about the TYPO3-english mailing list