Philipp wrote:
Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage lautete: REPLACE INTO `searchindex` (si_page,si_title,si_text) VALUES ('1209','it-dokumentation',' [... a big bunch of keywords ...] ') aus der Funktion "SearchUpdate::doUpdate". MySQL meldete den Fehler "1062: Duplicate entry ' ' for key 3".
That doesn't sound like it should be possible.
Have you checked the table for errors with REPAIR TABLE or myisamchk?
Any ideas how to get this back to normal? Is there a probated way to just delete the existing (but obviously somehow corrupted) searchindex and rebuild with the PHP script afterwards? I would guess "delete * from searchindex where 1" might be a bit too brutal.
rebuildtextindex.php
-- brion vibber (brion @ pobox.com)