kimberly_ward's profile

4 Messages

 • 

120 Points

Tue, Oct 18, 2011 3:49 PM

Lightroom: LR 2 catalog corrupted after power failure. Need help with recovery.

My computer crashed during a sudden storm last night and Lighroom 2 was running. The catalog is now corrupt, and I really need it fixed. I followed the prompts to correct the corruption, and it didn't work. Can you please help me?

Responses

12 Messages

 • 

182 Points

10 y ago

Hi,

Unfortunately I made a collection from images from 2 folders on my hard drive and renamed a selection of those combined in a collection. So I can't rename back. I can use finder to locate files one by one. And that is what I will have to do if nothing else.

Here is the link to the zip to the corrupt file (75 mb). Hope that is not too large. Let me know if you can figure something out. Thanks so much!
65.36.140.139/dropbox/2011corruptlrcat.zip

4.5K Messages

 • 

76.3K Points

Maybe put on some music and type to the rhythm...

I should be able to recover your develop settings from the corrupt catalog (it is readable by my sqlite app). I assume you can recreate other metadata with less trouble, no?

UPDATE: See post below about WreckHover.

4.5K Messages

 • 

76.3K Points

10 y ago

Use WreckHover (for Lr3) to recover develop settings from your previous corrupt catalog (Lr2 or Lr3 catalog) and apply them to corresponding photos in the current catalog.

Note: Photos must have same ID (current catalog must be a recovered backup catalog), but may have different filenames.

PS - This plugin includes source code, and can easily be extended to recover other metadata as well, but @2011-11-07 only recovers develop settings.

Employee

 • 

166 Messages

 • 

3K Points

10 y ago

I repaired that catalog file you linked to above:
http://dl.dropbox.com/u/7739202/repai...

The only damage I saw was in the develop history and even that seemed fairly minor. Hopefully that'll save you some trouble.

4.5K Messages

 • 

76.3K Points

I noticed develop history was the only bad table, but did not know how to repair it. Would it jeopardize job security to cite recovery technique used, in a nutshell...

12 Messages

 • 

182 Points

Thank you, thank you, thank you! Both to Rob and Dan! I spent all night clicking through to link associated files because of the renaming issue, and you just saved me an entire day of editing with this repaired catalog. The job is already past deadline so this really helps. Can't thank you enough!
Page

4.5K Messages

 • 

76.3K Points

You're welcome Page.

PS - I nosiced you are from SF bay area when I was combing through your catalog metadata (me too). Maybe post link to some of your photos if you have any online? (or send me a private message...)

So, Lr3 yet??

Employee

 • 

166 Messages

 • 

3K Points

The technique is fairly simple. I just use the sqlite command line tool's .dump command and do some very basic sanity checks on the schema afterward.

Employee

 • 

166 Messages

 • 

3K Points

I have some ideas on a more advanced technique for cracking the (rare) tough cases, but once LR3 showed almost no corruption incidents, I tabled it. No pun intended.

4.5K Messages

 • 

76.3K Points

Thanks Dan.
R

12 Messages

 • 

182 Points

10 y ago

I follow up question to the corrupted catalog. Now my LR destination folder that am using currently (with LR 3 now!) looks like this with the a dew versions of the corrupted catalog. The most recent one, which is now the fixed one, is called "2011.corrupt 2.lrcat". Should I move the others to a different folder using Finder to clean up this folder? Can I rename this catalog that I am using just by renaming in Finder? Will that screw up LR? This is a screen shot of my folder currently:



Thanks for the help!
ALso, is there any reason to keep old LR backups? I have a lot and they take up space. Should I just keep just the most recent ones?

Thanks again!
Page

Employee

 • 

166 Messages

 • 

3K Points

Lightroom only uses one lrcat and its accompanying Previews.lrdata package at a time, so it would be a good idea to move all the alternate copies elsewhere so you don't get thrown off by them at some point in the future.

Also, as long as you keep the names of the lrcat and lrdata matched, you can remove "corrupt" from the name as well so that doesn't create any confusion.

12 Messages

 • 

182 Points

Perfect, thank you!

1 Message

 • 

62 Points

9 y ago

I got an error message "The catalog "Lightroom 2 Catalog" is corrupt and cannot be repaired at this time."
As far as all the details go... long story.
2 months ago the logic board on my macbook pro fried. I purchased a new macbook pro and swapped hard drives and everything seems to be functioning fine. I'm traveling around the Americas on motorcycle so in the two months that I was waiting for my new macbook pro, I purchased a PC netbook to download and store my images. I moved all the images from the netbook to a external hardrive (formated for mac and on the PC netbook I have MacDrive 9) and imported them into my Lightroom catalog. Everything seemed fine and about 12 hours later Lightroom crashed and cannot read the catalog file since. I was not using the computer when it crashed.
Also there were duplicate files in the import as windows wasn't smart enough to realize it but I expected Lightroom not to have a problem with it.
Any advice?

This reply was created from a merged topic originally titled
Lightroom catalog is corrupt....