By running 'perror 145', I see:
Error code 145: Unknown error: 145 145 = Table was marked as crashed and should be repaired
Your searchindex table is corrupt. You can either use REPAIR TABLE from within mysql, or you can use the myisamchk app to try to fix the file. There's a lot of info on this at http://www.mysql.com
I'd probably repair the file, and then re-run the maintenance script 'rebuildtextindex.php' with the command: php rebuildtextindex.php
I'd also suggest figuring out the root cause of that table corruption, but I don't have any great advice for you. When I was having corruption problems, it turned out to be an OS bug or corruption in my partition, I don't know which. I'd worry if you see this corruption again, but for now, maybe it's no huge issue.
good luck! -nick
Markus Klaus Schäffauer wrote:
Hello,
since I installed MediaWiki 1.3.3, I get sometimes the following error message from the search engine (and have to repair the table):
"SearchEngine::showResults". MySQL meldete den Fehler "1016: Can't open file: 'searchindex.MYI'. (errno: 145)".
What can be the reason for that behaviour and what can I do to avoid it?
Thank you! Markus
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l