Right, I'm stuck.

I've been chugging along with my blog for 18 months and today tried to log in and got this message:

Couldn't load blog; perhaps you have not upgraded your MT database? - Loading data failed with SQL error Can't open file: 'mt_blog.MYI' (errno: 145)

The blog itself displays OK (blogshank.com) but as well as not being able to administrate, I've had different errors when leaving a comment, this being the latest:

"No entry_id"

I'm using version 3.2 through Yahoo hosting. I used Yahoo's Repair Database option but it didn't help.

Can anyone suggest anything? I did nothing weird when I last posted, and now I'm lost.

Thanks

Mike

It sounds like it can not find the database (the MYI file).

I would speak to Yahoo

Thanks, I've sent them a message.

Where is the mt_blog.MYI file normally located? Maybe I could restore it and any other changed files using yahoo's snapshot backup. Or maybe I'll just end up screwing it up further, who knows?

It would be on the database server, I don't really know much about yahoo hosting.

For what its worth I had a similar problem a week or so ago. I use yahoo hosting and my blog displayed but I couldn't log in to the admin console. It was a problem with Yahoo's server handling SQL. It took a day or so and they emailed me when the issue was resolved. They indicated the problem was on a bank of servers that effected many people so it wasn't isolated to just me.

I suggest calling them and they can tell you over the phone if the issue is at their end.

Oh, sorry, I assumed that because it's called blog_MT it'd be buried within the Movable Type structure in a predictable place.

Thanks fmulvaney. That's encouraging.

I believe I have found the quickest and simplest solution for the problem.

Log in into your phpMyAdmin. If you do not have it installed go to http://webhosting.yahoo.com/ and install it. The process if fairly easy.

Then read this tutorial http://www.sixapart.com/movabletype/docs/3...up_restore.html

Back up you DB. You won't be able to backup the mt_blog.MYI but the rest should. Save the backup file.

After that deactivate your blog form the webhosting interface and then re-install it.

The go back to phpMyAdmin and restore your databases.

Log into your blog and click the rebuild site button.

And that is it. All your blog will be up and running like before.

Have a nice day.

Thanks. I didn't have PHPMyAdmin installed, nor did I want to -- I just want a blog! I don't get how stuff should suddenly go wrong without me having to screw up first. One day everything's going along fine, the next I get a cryptic error message with no clue as to how to fix it.

After several attempts I got an answer from Yahoo which worked. For future searchers, here it is:

The error message that you are reporting is usually a result of a locked
table that isn't getting released.

1) Open up your phpMyAdmin control panel (if you haven't installed phpMyAdmin then please follow the steps on the page:http://help.yahoo.com/l/us/yahoo/smallbusiness/webhosting/mysql/mysql-18.html)

2) Select the Database you are having trouble with
3) You should see a list to tables in the center of phpMyAdmin
4) For the table that is being called and having troubles mark the check
box next to the left of the table name
5) Below the table names you will see another <select> box that is
labeled "With Selected:"
6) From the <select> choose "Repair Table"
7) Wait. you don't need to do anything to make it start the repair.
8) Once the repair is finished, it will display a screen that says if
the repair was successful or not.

Mike