I am receiving this error message when trying to access topics:



Is there a MySql command for rebuilding topics?

It seems to be a topic_views field problem.

Is there a command for rebuilding that field?

Will the repair field command fix the problem?

I tried the repair command and received the following error message:


I am at a loss on what to do next.

What kind of file is that?

I tried creating a new file to test out this viewing problem, however, I received the following error message instead:


I guess I have no other choice now but to wait until somebody here is able to help me as it all seems to impact on this missing ubbt_TOPIC_VIEWS.MYD file.

In the meantime I have closed down my board/forum.

I discovered one topic that I can read, however, when I reply to it I receive the following error message:


The strange thing though is that when I hit my back button, I can see the new post, but, so far, this only works in this one topic, which, so far, is the only topic I can view.

I do hope somebody will be able to tell me exactly what to do in relation to this missing ubbt_TOPIC_VIEWS.MYD file, which seems to be causing the whole mess.

I looked at my fields and this is what I see:


The one causing me all the problem is saying "in use" rather than "MyISAM" like the rest of the fields are also showing.

What does "in use" mean in relation to all of the others?

MySQL databases are stored as flatfiles on the system; where the table "ubbt_TOPIC_VIEWS" has the flat file "ubbt_TOPIC_VIEWS.MYD" that holds the information on the server.

The erorr message is stating that the table is missing from the server; not sure why, or how, this would be missing however...

How can I correct this?

It also says this field is "in use" with zero rows.

What does that mean?