Is my table broken or am I missing something?

[EleanorJLH]

Hi all :) Sorry if this is an idiot question, but I'm still feeling my way through the whole PHP/SQL thing.

So, I run a website with a set of user forums using phpBB2. It's got a non-standard template but there are no code hacks or mods in use. There are 55 users and maybe 15 posts a day, if that, so I doubt we're running into the SQL query limit.

However, recently - as in, within the last week or so - we've started having problems with the forums. Replying to any thread gives the error message

Could not insert new word matches

DEBUG MODE

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 2458, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('test', 'drill')

Line : 251
File : $path/functions_search.php

Using the PHPMyAdmin console, I went to check out the phpbb_search_wordmatch table, and maybe try and repair it.

Unfortunately, selecting that table gives me

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

and hovering over the table in the list tells me it has 0 rows. This also means that, not being able to open it, I can't repair it. :/

Now, I don't run any other phpBB2 installs anywhere else for comparison; is this normal? Is the table corrupted; if so, how can I repair it? Is there any way I can salvage the forums?

Thanks heaps for your help, in advance. I'm stumped!

[satis]

It's not normal. However, I'm afraid I don't know a fix. Hopefully someone here would know how to fix that table. Do you have any backups of your database? You also may want to try the phpbb forums and see if someone there can help.

[Kays]

Judging by the error number, the table is corrupt. I use to have similar problems with my sessions table on occasion. What I would do is to drop it and since I had two forums on that database I would copy the table structure from the other forum to replace to one I just dropped.
But you don't have that option..

Now there are a couple of things that you could do.
If you know the structure of that table then drop it and recreate it manually. I don't know phpBB but I don't think it's critical for it to have data in it.
Also, if you go to OPS > my SQL, there's a week of database backups. See if you can restore one of them. Open them first and see if that table does have data. I'd be tempted to restore them to an other database, just in case there is a problem. Then you can either redo the database info in the forums or copy that table and restore it to the existing database.
Temporarily, I think that if you comment out line 251 in functions_search.php that you should be able to use your boards again. But the search feature probably won't work.

Hope this helps. :)