SQL Error : 1016

[flamacue]

DEBUG MODE

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

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 369, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('may', '2006', 'enrollments', 'summer', 'low', 'affects', 'planning', 'fall', 'whats', 'ive', 'posted', 'confidential', 'poll', 'figure', 'folks', 'signing', 'classes', 'appreciate', 'feedback', 'makes', 'difference', 'quantity', 'courses', 'offer', 'type', 'course', 'melissa')

Line : 251
File : functions_search.php

Any ideas and or help is greatly appreciated. Thanks in advance.

[espicom]

Ask and you shall receive... Fixing MySQL 1016/1030 errors

[jwunderly]

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

Fixing 1016 errors

[flamacue]

Thanks guys. I ran the script several times but to no avail still getting the 1016 error. Any more ideas?

[espicom]

Next suggestion is the MOD to rebuild search tables, assuming that the fixtables script was able to complete (it might time out, depending upon your database and the web server's timeout limitations).

Did the status display get all the way down to "Now checking and repairing table phpbb_words ... OK"?

[flamacue]

I got no status message from the script. It looked like it ran in about a second.

[Booswig]

Hi. Perhaps others may know, but being new to phpbb2, I have this particular error since this morning when I try to go to my forum:

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_config.ibd' (errno: 1)

SELECT * FROM phpbb_config

Line : 219
File : common.php

I have installed wamps on another PC, copied the site, didn't work.
Copied the old site from my old PC (it used to work if I copy the database and the site), same error.

I have spend days on gettting this thing working and posting information, now this. It worked 100% the last few days, and I did not make any changes (apart from adding an additional forum topic, and made one post). I cannot lose my data and information.

Now this error.

I tried this fixtables script (as proposed), but, what is this secret code, or where can I get it. Also, from another post, I tried using myphpadmin, but, when I try to open the database, it just gives me the same error, no matter on which table I click:

Error
SQL-query:

SHOW KEYS FROM `phpbb_auth_access` ;

and
MySQL said:

#1016 - Can't open file: 'phpbb_auth_access.ibd' (errno: 1)

What can I do. I do not know alot of php and sql ... just want a nice plain small forum for a few like minded people. Now I know why there is a:
"I want to committ suicide" topic here ... not funny at all.

[espicom]

I got no status message from the script. It looked like it ran in about a second.

This is very strange - you should get lines like:

Now checking and repairing table phpbb_auth_access ... OK

Repeating for each table that it was able to fix during the current run. If it stops before it gets to the phpbb_words table, re-running it should get it further along, as each run should trigger the repair of at least one table, and, once a table is repaired, it is skipped past with an OK on the next run.

I'd ask your host if they're having problems with the MySQL server, because your getting an error that says to repair the table, but you can't.

[espicom]

SQL Error : 1016 Can't open file: 'phpbb_config.ibd' (errno: 1)

Answered in your other message in the Fixing 1016 topic. This is an InnoDB error, caused by an operating system problem.

[flamacue]

I finally got it to work and the script fixed the tables. Thank you all so much for your help!