SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MY

[lokirj]

I saw some topics with this..but dont resolve this problem.
I rapair my table using Phpmyadmin but error back about 10 minutes later.

TABLE: phpbb_search_wordmatch

HOW can i resolve this problem ? version 2.05 have this error ?

Thanks.

================================================
Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 55295, word_id, 0 FROM

phpbb_search_wordlist WHERE word_text IN ('fsdf')

Line : 249
File : /home/lokirj/public_html/forums/includes/functions_search.php

================================================

[lokirj]

Anyone have a reply for my problem ?

[arhodes16]

All you can do is repair the tables, if it reoccurs regularly you should contact your host as there is most likely a problem with their mySQL server.

[lokirj]

How can i update phbb 2.06 to 2.06c ?

What process i need to do ?

[A_Jelly_Doughnut]

Just update the changed files: bbcode.php, search.php, groucp.php, and one other...privmsg.php (?) with the updated 2.0.6c files.

[lokirj]

Hummm
and the update will resolve my problem ? or not ?

[A_Jelly_Doughnut]

Most likely not. Arhodes16 gave you all the applicalbe information

[lokirj]

OK....i will check

[lokirj]

My host admin installed new mysql server..
But the error appear again...

Wha is the problem ?

in phpmyadmin appear this:

phpbb_search_wordmatch in use

When i repair back to normal...but 10 minutes later ou more back the error.

thanks for any help

[lokirj]

hummm if i install ver 2.05 this bug over ?

[A_Jelly_Doughnut]

www.phpbb.com/kb/article.php?article_id=25 is one way to fix it

[lokirj]

OK...
Fix my table....but the error back later again.



What is this ?

[A_Jelly_Doughnut]

This is the perfect reason to move web hosts. The problem is caused by overloaded/overcrowded serveders

[lokirj]

The overloaded/overcrowded cause this error ? why ?

thanks

[A_Jelly_Doughnut]

Because mysql gets interrupted with requests, and abandons your table, rendering it useless until it is repaired.