1016 Can't open file: 'nuke_bbsearch_wordmatch.MYD

Nuke Cadet Joined: Jan 01, 2006 Posts: 4

I am having a problem with my forums. It suddenly occured and now no-one can access the threads in the forums. This message appears;

--------------------------------------------------------------------
Could not retrieve word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYD'. (errno: 145)

SELECT m.word_id FROM nuke_bbsearch_wordmatch m, nuke_bbtopics t WHERE m.post_id = t.topic_first_post_id AND t.topic_id = 385

Line : 54
File : /home/www/ubaclane/includes/functions_related.php

-----------------------------------------------------------------------

I searched the forums and found that someone else had a very similar problem but it wasn't answered.

When I check the database in MYSQL 'nuke_bbsearch_wordmatch' seems to be in use? Does anyone know how to fix the problem?

Any help would be much appreciated.

Kind Regards
Ben Foley

Posted: Wed May 03, 2006 9:03 am

This error can be caused by the following:

1. You have run out of space in your MySQL Database

2. the table has been corrupted

Solutions

1. Check with host and if all your space has been used, request more space.

2. Using phpMyAdmin, click on the nuke_bbsearch_wordmatch table in the left window, then the operations tab and then click repair table in the Table Maintenance section. This doesnt always work but it is your best chance. Failing that restore the table from a working backup.

Nuke Cadet Joined: Jan 01, 2006 Posts: 4

Well I definately have enough memory, so I guess I will have to try to repair it. I know there is a code for it to enter in the query window because i've done it before, but I can't remember what it is?

Could you please let me know it?

Thanks.

Posted: Thu May 04, 2006 8:57 am

Code:

REPAIR TABLE nuke_bbsearch_wordmatch