4 Replies Latest reply on Aug 31, 2014 9:12 PM by areohbee

    Cannot repair corrupted catalog.


      My Mac crashed in the middle of editing images in Lightroom 5.  It just completely froze (no keyboard lights, no cursor moving, etc.) and had to have a hard shut down.  I didn't get the option to submit a crash report.  When I reopened at first it said it couldn't write to the catalog because it was on an external drive, but the second time I opened the catalog it simply said that it cannot open due to an unexpected error.  I looked online for solutions and I do not have a .lock file in the folder (so it's not that) and when I try to open it while checking for catalog integrity it says to repair it, but then says it is temporarily unable to repair corrupt catalog.  I've tried copying the catalog to a new location to see if that would do the trick, but no dice.  Does anyone have any suggestions!?  I just lost a week's worth of work from my friends' wedding!  Argh!

        • 1. Re: Cannot repair corrupted catalog.
          areohbee Level 6

          I presume you don't have a recent-enough catalog backup (?)


          I bet you won't let that happen again..


          Anyway, depending on what's wrong with the catalog, you may be able to recover develop settings (only) via a plugin called WreckHover (free, by me).


          In addition to catalog, settings may be stored in:

          * xmp if you've saved metadata (if not, I bet you won't let that happen again either) - recovered when importing new photos, or reading metadata (Library menu) of already-imported photos.

          * exported versions (if exported with all metadata) - you can recover settings from those via the same plugin: WreckHover.

          Note: you'll need to restore a backup catalog first, or start a new one if no backups (really?).


          Good luck,


          • 2. Re: Cannot repair corrupted catalog.
            THG_BO Level 3



            may be this article can help you: Mein Lightroom Tag: Einen Katalog reparieren, welchen Lightroom nicht mehr öffnen kann! 


            Basic idea is to make a sql dump and re-import this dump in an new catalog. (Don't forget to make backups before)

            • 3. Re: Cannot repair corrupted catalog.
              yozhik202 Level 1

              Hi Rob,


              Thanks for the advice.  I tried using the plug-in, but I'm not sure if the catalog is too corrupted or something.  When I do part 1, I get a warning which states, "WARNING #6: sql query error: Non-zero exit code returned by command" and then the path name for the plugin, then the path for the source file and the fields from the source file you are querying and then it says, "exit code: 2816." 


              Any idea what this means?


              Thanks again for the help!



              • 4. Re: Cannot repair corrupted catalog.
                areohbee Level 6

                Hmm - not sure what that means Andy, but it may mean that sqlite can't read the develop settings table.


                As you said, it could be that the catalog file is too far gone.


                Have you tried opening it with an sqlite app, like SQLiteSpy (Windows). If it can be opened, then there is a chance at recovery. If not, it doesn't bode well.. - you could also try the article posted by THG_BO, if you speak German.


                Anyway, sometimes Adobe personnel will help with corrupt catalogs, if you can get their attention.


                Not sure what else to say..


                Fingers crossed,