Weird error... help?

[thebassman]

my forum members (and myself) are getting the following error when trying to post to a specific topic.... people can post to other topics fine, though.

Code: Select all

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 126601, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('test')

Line : 251
File : functions_search.php

Any ideas?

[AdamR]

If you have access to phpMyAdmin, try running the following query on the database:

Code: Select all

REPAIR TABLE phpbb_search_wordmatch;

If you need help with running queries in phpMyAdmin, here is a great tutorial on it:
http://www.phpbb.com/kb/article.php?article_id=151

If you don't have access to phpMyAdmin, paste that code into a text file and save it on your computer.

Then, login to your forum, go to Admin Panel > General Admin > Restore Database

Browse to the location where you saved the file, and restore it.

- Adam

[thebassman]

I won't lose any info doing that, will I?

[AdamR]

No. All data should be preserved.

- Adam

[thebassman]

Thanks Adam! Worked like a charm. Now, just out of curiosity, why did that happen in the first place?

[AdamR]

Error 145 means a corrupted table, or the like, and is in need of repair, which is what you did. This is almost impossible to prevent from happening as it can be caused by numerous things, from a query being interrupted while being executed or another "bump" in the server. If it only happens rarely, it's nothing to be worried about. However, if it becomes an often experience, there's probably something more serious behind it, in which case you should contact your hosting provider. Though, as I said, rarely is absolutly nothing to worry about.

- Adam

[thebassman]

Cool... good to know. Thanks Adam.