MovableType and corrupted datbases

| 3 Comments

Yesterday the mySQL database on this server crashed, so I apologize if any comments submitted have been lost. I didn't realize that was what happened, but... in case other people have this problem (since a Google search didn't turn up any clues) the error message I was getting was:


Building date-based archive 'Monthly20060201000000' failed: Build error in template 'Date-Based Archive': Error in MTEntries tag: Error in MTIfCommentsActive tag:

My mt_comments table in the mySQL datbase was what was marked as crashed, so I am assuming that had a different table crashed it would be reflected in the error message.
A simple check and repair of the database fixed the problem.




--------

3 Comments

This was unexpectedly useful - ran into this article via Google. Thanks!

I am having this same moveable type error. Im kinda new at all of this and was wondering if you could explain in further detail how you fixed this problem.

You assistance would be greatly appreciated.

Steven.

Sure. You'll need to go into MySQL Administrator (log in as the DBUser you set up for your MT installation) and load up the mt catalog. You should be able to view the various tables that make up Movable Type's database. There should be an option for Maintenance. After clicking that, you should have three options: Optimize, Check and Repair.Run Check, see if there are any errors, and then run Repair. That should resolve this particular error.

Leave a comment

Recent Entries

H1N1 Outbreak At PAX '09
Those of use on the convention circuit know that a lot of fanboys plus convention center equals an epidemiologist's nightmare;…
Scream Sorbet
I don't tend to like sorbet (or sherbet, the fizzier dairy-added version); while flavorful, it always seemed to me that…
Golden Age Comics are the New Benjamins
Recently, a meth ring was broken up, and the investigators discovered over $500,000 worth of comics in plastic cases. It…