Got error 127 from table handler - Record-file is crashed

[ilie2]

Intr-o zi a aparut eroarea in pagina de start a forum-ului (index.php) " Got error 127 from table handler " care se pare ca inseamna " Record-file is crashed "

tabelul phpbb_search_wordmatch avea peste 200000 inregistrari

Am executat urmatoarea comanda (in linia de comanda mysql):

mysql> check table phpbb_auth_access, phpbb_banlist, phpbb_categories, phpbb_chatbox, phpbb_chatbox_session, phpbb_config, phpbb_confirm, phpbb_disallow, phpbb_forum_prune, phpbb_forums, phpbb_groups, phpbb_posts, phpbb_posts_text, phpbb_privmsgs, phpbb_privmsgs_text, phpbb_ranks, phpbb_search_results, phpbb_search_wordlist, phpbb_search_wordmatch, phpbb_sessions, phpbb_smilies, phpbb_themes, phpbb_themes_name, phpbb_topics, phpbb_topics_watch, phpbb_user_group, phpbb_users, phpbb_vote_desc, phpbb_vote_results, phpbb_vote_voters, phpbb_words;

care a "refacut" mai multe tabele in afara de phpbb_search_wordmatch care a zis ca e corrupt si se pare ca nu mai poate fi refacut.

apoi:
mysql> repair table phpbb_search_wordmatch;

Dupa aceasta comanda (check table) forum-ul a functionat (nu a mai dat eroarea 127).

Probabil aceasta eroare va mai va trebui sa golesc tabelele:
phpbb_search_wordlist, phpbb_search_wordmatch.

http://dev.mysql.com/doc/mysql/en/perror.html
http://www.databasejournal.com/features ... hp/3300511

http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
http://mysqld.active-venture.com/Repair.html