Skip to main content
Participating Frequently
June 10, 2013
Question

How to repair corrupt Lightroom 4 catalog

  • June 10, 2013
  • 3 replies
  • 14768 views

Hi,

I use Adobe Lightroom 4.3 64bit and am having problem with a corrupt catalog.  The catalog contains a couple years of exposures with approx 87,000 photographs.  I am running LR on Win 7 with quad core CPU and 10Mb RAM.  I have used Lightroom for couple years and only problems I had experienced have been intermittent performance issues with LR.  The years of photographs are in RAW format with editing in Develop module.

I was using Lightroom 4.3 and it froze the computer while using develop module.  I had to power off to reboot and LR catalog was corrupted.  I reverted to the LR backup (I back up daily).  After importing photographs, LR once again froze the computer during Develop work.  And, another backup was corrupted.

I went ahead and upgraded to LR 4.4 in hope that this will improve the situation.  I ran chkdsk and other system utilities as well.

I need Adobe to repair this corrupt catalog so I don;t keep wasting my time.

Please advise next steps.

Thanks,

Frank M

This topic has been closed for replies.

3 replies

Participant
January 1, 2019

If the above doesn’t work, not all is lost. It didn’t work for me, and I tried the following, hoping it would work.

Enter into the sqlite3 program command mode, type the following and hit the enter key:

.open YourCorruptedLRCatalog.lrcat

Then type the following and hit the enter key:

.clone NewCatalog.lrcat

To exit the command prompt (exit out of the sqlite3 application) type the following and hit enter:

.quit

I’m not certain what precisely happens, but my corrupted file was 1.4 GB in size and the newly created file, a clone came back as 980 MB in size. The cloning process must ignore so-called deleted data or whatever.

Anyway, copy the newly created catalog file back to your LR folder, rename it to the original file.

The above worked for me.

Steve

Participant
September 2, 2014

I have a major major major problem. I haven't backed up my catalog in months!

is there anyone here who can tell me how to fix the catalog?

I can't even duplicate it on the mac. It shows (Error code -36).

I am completely devastated.

dj_paige
Legend
September 2, 2014

Instead of saying I have a "major major problem", could you describe the exact symptoms of this problem?

Did you try any of the suggestions in this thread?

Participant
September 2, 2014

Hi

Thanks for responding!

Yes I did try the above solutions.

Unfortunately I cannot import images from the catalog into another catalog, nor can I duplicate the catalog.

I am in the process of using this solution:

http://gerhardstrasse.wordpress.com/2010/08/19/recover-from-a-corrupt-adobe-lightroom-catalog-file/

But for some reason the sql commands won't work and are giving me this : 'Error: near "echo": syntax error',

so I haven't been able to complete step one of the process.

JP Hess
Inspiring
June 10, 2013

How recent of a backup of the catalog do you have?  I assume you do have backups.

wnasfmAuthor
Participating Frequently
June 10, 2013

Yes, daily backups.  Right now, LR has corrupted two days of backup.

dj_paige
Legend
June 10, 2013

Yes, daily backups.  Right now, LR has corrupted two days of backup.

If you made a copy of your backup and moved it to the original catalog file location and then open it, your backup could not get corrupted.

And I remain skeptical that the catalog is really corrupted. How do you know?