Hi,
I'm getting a searchindex error when trying to save a particular article after
editing:
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".
When it appeared the first time the trailing remark about where the error
occurred was different (AFAIR, can't reproduce the "first-time-message")
saying
also one should try to update the searchindex. Which gives me the same error on
the command line with some more info around:
~/tools/php/bin/php -f updateSearchIndex.php
Updating searchindex between
20050421063319 and 20050422063319
--- Waiting for lock ---
Warning: Missing argument 1 for locksearchindex() in
/home/cddoc/tools/httpd/htdocs/wiki/maintenance/updateSearchIndex.inc
on line 79
Diba-Tips
TA-Feedback_JAVA-CodeFormatter
Loadbalancer_SZZ
Client-Interface-Philosophie
AutoHotkey
News_and_ToDoS_VA
Dokumentation
IT-DokumentationA database error has occurred
Query: REPLACE INTO `searchindex` (si_page,si_title,si_text) VALUES
('1209','it-dokumentation',' [... big bunch of keywords ...] ')
Function: SearchUpdate::doUpdate
Error: 1062 Duplicate entry ' ' for key 3
Backtrace:
Database.php line 345 calls wfdebugdiebacktrace()
Database.php line 297 calls databasemysql::reportqueryerror()
Database.php line 1057 calls databasemysql::query()
SearchUpdate.php line 112 calls databasemysql::replace()
updateSearchIndex.inc line 66 calls searchupdate::doupdate()
updateSearchIndex.php line 51 calls updatesearchindex()
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.
Regards
Philipp