[Typo3] duplicate entry

[Martin Poelstra]

Hi Ben,

> I have this error on a site:
>
> Duplicate entry '147531' for key 1
>
> I tried to troubleshoot it, but couldn't find a good answer. It has 
> probably got something to do with a new MySQL version, because this error 
> seems to be there after we moved to Debian on our production machine. 
> Fortunately it happens only on one particular site.

We had the same problem on one of our site too (you know which one ;)).
I never got around to track it down completely, but it seems to be caused by 
the indexed_search-extension.

It occurs when the page is regenerated and going to be cached. In that case, 
the content is passed to the indexer, which generates the error.
If you view the page again, it is fetched from the cache, and the error is 
gone (until the cache is cleared).

Grtz,
Martin