Db Error

[Dempap]

Hello all,

I have been running Yabbse aor around 7-8 months now.  I was running 1.31 until around a week ago, when my board just screwed up.  I was not sure what it was, but I saved as much of the data as i could and I installed the lattest version.

Now After running for about 5 6 days, doing just fine with the new version.  I once again get the same error.

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


This has happened on two different boards now.  What is this?  When I log into phpmyadmin to check out the "Topics" table, I cannot get in, this is the error I recieve:

Error

SQL-query :  

SHOW KEYS FROM `yabbse_topics`

MySQL said:


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


Any help would be greatly appreciated.

[Douglas]

Via phpMyAdmin, load up your database.  Select all tables, and run REPAIR.  What happens is that the table was in the middle of being written to when the MySQL server was restarted.  Because that table is locked down, it prevents any updates from happening.  Running a repair on all tables will remove the lock, if it's truly not being written to.

Hope this helps explain what happened.  

[Dempap]

Thanks soooo much....

This is much easier than dumping my data, and reinstalling  

Demetri