Is my database corrupt?

[munson66]

Version: OOTP 2007, 2.0.3.68

PC/Mac: Mac

What I was doing: auto-playing the last week of my major league's regular season to get to the playoffs.

What happened: OOTP was running on a MacBook. Battery power was low. After autoplaying the last day of the season, I clicked the Finish Today button. As scheduled, OOTP began to auto-save the data. However, the battery power was lower than I thought -- the Mac shut down in the middle of the auto-save.

A minute or two later, I plugged the computer in, but the Mac OS had shut everything down. I rebooted, then loaded OOTP.

Instead of October 3, 1976, the last day of my fictional league's regular season, it was still October 2, 1976. I tried clicking on Play Game, and the program crashed to the desktop.

Relaunched OOTP, and called up the league standings. So far, so good. Everything as it should have been after the games of October 2. Then I went to the manager news and messages screen, and while the text of two messages "sent" on October 2, 1976, was correct, the pictures of the related players were replaced with generic ballplayer pictures, and the player names had changed to #0, Joe Unknown.

I clicked on Review Your Roster, and the program crashed.

I went to the folder OOTP Baseball 2007->data->saved_games->New Game.lg, and noticed that there were the requisite 17 .dat files in place, but the size of retired.dat showed as 0 kilobytes.

It looks to me as though, when OOTP was shut down unexpectedly last night, one of the databases was corrupted.

I don't have any other leagues on the go right now, so I can't troubleshoot that way.

Any suggestions? I'd love to get this season (and the league) back. The league is currently at the end of its 10th season, and after starting an expansion team from scratch, I had gotten it to first place overall (a 100-54 record) in its fifth year.

Any help most appreciated.

[Nutlaw]

If this was the first year of your regular season, the retired.dat file would be okay at 0 kB. Since you wrote that it is your tenth season, that makes me worried.

Could you please create a quick fictional league to test to see if that one is working okay?

[munson66]

I created a fictional league, ran it through a few auto-played seasons. Everything seems to work fine with the new league.

Any thoughts about how I might repair my old database files?

[Nutlaw]

Did you try creating a new .lg folder and putting only the .dat files from the damaged league into it to see if that will load up?

[munson66]

Originally Posted by Nutlaw

Did you try creating a new .lg folder and putting only the .dat files from the damaged league into it to see if that will load up?

I did. No luck. It's looking to me as though, when the daily auto-save was interrupted by my computer powering down, the files got messed up. Another data point: I tried going to the league leaders screen, and everything looks as it should, including the player pictures, but when I click on a player OOTP crashes to the desktop.

I guess there's something to be said for backing up .dat files, although I thought with the frequent auto-saves I'd be covered. Shouldn't have been so eager to finish my season, I guess.

[Nutlaw]

Yeah, I'm sorry, but crashing during the saving process will tend to destroy your saved game.

Is there anything else that I can help you with here?

[munson66]

Originally Posted by Nutlaw

Yeah, I'm sorry, but crashing during the saving process will tend to destroy your saved game.

Is there anything else that I can help you with here?

No, but thanks. Naturally, this happened just as it was getting interesting.