Hi all,
I am experiencing a rare problem: Suddenly the search functionality of my 1.16.0 wiki on 5.2.17 PHP/ 5.0.96 MySQL has vanished.
The database cant find the "searchindex" file and as such the search functionality has gone. There was no maintenance or other event I am aware of that may have caused it. For repair I have tried some progs from the maintenance area (rebuildtextindex and rebuildall) but I get the same error msg:
** Rebuilding fulltext search index (if you abort this will break searching; run this script again to fix): There was a syntaxerror in the database query. Last request made to database was: âSHOW INDEX FROM `searchindex`â Database::indexExistsâ            The DB generated the following error: â1017: Can't find file: 'searchindex' (errno: 2) (localhost)â
-- So it looks like the db just lost that file (or it got corrupted). Does anyone experience the same and how did you solve it, or alternatively what do you suggest?
Many thanks Marcel van Vliet
Disclaimer:
Dit e-mail bericht is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen dan geadresseerden is niet toegestaan. Indien u niet de geadresseerde bent, wordt u verzocht de verzender hiervan op de hoogte te stellen en het bericht te verwijderen. In verband met electronische verzending kunnen aan dit e-mail bericht geen rechten worden ontleend.
On 06/03/13 09:04, van Vliet, M.W. wrote:
-- So it looks like the db just lost that file (or it got corrupted). Does anyone experience the same and how did you solve it, or alternatively what do
you suggest?
Drop searchindex table, recreate it (see the definition from maintenance/tables.sql) and run maintenance/rebuildtextindex.php
mediawiki-l@lists.wikimedia.org