1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Welcome to Lightroom Forums! We're a friendly bunch, so please feel free to register and join in the conversation. If you're not familiar with forums, you'll find step by step instructions on how to register and post your first thread under Help on the menubar above. You're also welcome to join our newsletter, download our free Lightroom Quick Start eBook and explore our other FAQ resources.
    Dismiss Notice

Repair of corrupted catalogs

Discussion in 'Lightroom 1-6 for Windows & Mac (perpetual)' started by Tomiron, May 28, 2012.

  1. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    I too have a corrupt LR Catalogue from my desktop crashing. I've tried the SQLite, but now at the end of the process that I was VERY hopeful would be successful, is a huge body of lines reading "Error: near line 335733: Expression tree is too large (maximum depth 1000) (and the 334733 is only one of a gazillion lines with a different number.) Have I lost all hope at recovering this catalog? The file is not empty, and what was rebuilt is also about 792,112 kb, so there is data. Can anyone help? Thank you. I'm new here.
     
  2. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    You're welcome to zip up the catalog (one you haven't played with) and send it to me using www.wetransfer.com to [email protected] and I'll see if the LR engineer has any better luck with it.
     
  3. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    Oh Thank you SO much! Yes, I will upload it this morning! I truly appreciate it and will be forever grateful if it can be recovered.
    Just the catalog, or do you need preview files or anything?
     
  4. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    Got it Pam. I've forwarded it to the engineer, but it doesn't look promising here, so I think it's probably time to restore one of your backups. (I hope you had backups!!)
     
  5. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    um.... no backups... that's why I'm frantic Otherwise I would've done that first.
     
  6. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    Oh dear, so sorry to hear that. I guess you'll be paranoid about backups in future!
     
  7. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    YES I am.... I have multiple drives and multiple catalogs. Some are individual, some are a part of a master. I don't know why, but it was a habit to always skip backups. Stupid, I know.... don't need scolding, (and you didn't) the thought of losing all of that work is punishment enough. And I know better, I have also lost whole drives --- one to dropping, the other to just malfunction. At least the actual image files are all backed up now. (and yes, DriveSavers recovered the broken one. The other one just started working again and was backed up immediately)
     
  8. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    Thank you so much! I do appreciate you forwarding it on and looking at it. I am definitely going to back up from now on, probably as I work. This is HORRIBLE. I'm just getting started as a new sole proprietor and I'm at a level of production I didn't expect. This is crashing and burning before I ever get started. Ugggh! Thank you again. I am so appreciative of your response.
     
  9. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    Oh so sorry to hear that Pam. It's a stressful time for sure!
     
  10. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    In case it helps you get back on your feet, there are companies that can handle the raw processing for you, albeit at a cost.
     
  11. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    Oh PamElla, I've just heard back from Paul. He said he saw your post on the Adobe Forums and has already sent you back a partially repaired catalog. He's not sure how much was lost, as it was badly corrupted, but it's a much better scenario than we hoped for.
     
  12. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    It's fixed It's fixed It's fixed!!!!
     
  13. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    So far I've only noticed a copy of an edited image was not recoverable. I've lost not much! I'm completely over the moon! Thank you Thank youthank you!!!!!
     
  14. RikkFlohr

    RikkFlohr Senior Member Staff Member Moderator Lightroom Guru

    Joined:
    May 27, 2009
    Messages:
    1,820
    Location:
    Twin Cities, MN
    Lightroom Experience:
    Power User
    Primary OS:
    Windows 10
    Lightroom Version:
    Classic 7
    Paul rocks! Glad he was able to get most of it restored.
     
  15. PamElla

    PamElla New Member

    Joined:
    Apr 21, 2017
    Messages:
    8
    Lightroom Experience:
    Advanced
    Primary OS:
    Windows 10
    YES he does! I'm afraid I ran into an individual who was quite the opposite of Paul, and was not helpful at all. (actually he was a jerk, and if he is a representative of Adobe, he is a very poor one.) I gave him that feedback! Thank you! this forum was way more friendly! Thank you!
     
  16. Victoria Bampton

    Victoria Bampton Lightroom Queen Staff Member Administrator Moderator Lightroom Guru

    Joined:
    Sep 29, 2007
    Messages:
    19,674
    Location:
    Southampton, UK
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    CC Cloud
    Thank you, we do our best. We pride ourselves on always being friendly, even if we can't solve the problem (although sometimes don't come over in writing in quite the way we intended!).

    The official Adobe forums get an awful lot of traffic, and sometimes in a rush to cover all posts, things are said without thinking. I've known Jim online a long time, and he's not a bad guy, but yes, he did dig himself into a hole this time. Isn't it always at the worst times, too?!

    Anyway, make yourself at home, and hopefully we can help you avoid any further problems. I'm glad it all worked out ok in the end.
     
  17. johnbeardy

    johnbeardy Senior Member Staff Member Moderator Lightroom Guru

    Joined:
    Oct 8, 2007
    Messages:
    4,457
    Location:
    London
    Lightroom Experience:
    Power User
    Primary OS:
    Windows 10
    Having read the exchange, obviously things went on a spiral, but I do feel it's important to avoid mistaking direct questions for rudeness.
     
  18. holgermischke

    holgermischke New Member

    Joined:
    Sep 20, 2014
    Messages:
    5
    Location:
    Grefrath, Germany
    Lightroom Experience:
    Intermediate
    Primary OS:
    Windows 10
    Does anyone have experience with rebuilding catalog files that weren't corrupt to begin with, but were accidentally deleted and the recovered and THAT actually hurt them? I've had no luck rebuilding these catalogs using SQLite in a couple of cases and it seems when you recover a deleted catalog file, it doesn't have the original data. Can anyone confirm that?
     
  19. Jim Wilde

    Jim Wilde Lightroom Guru Staff Member Moderator Lightroom Guru

    Joined:
    Feb 1, 2010
    Messages:
    10,361
    Location:
    West Sussex, UK
    Lightroom Experience:
    Advanced
    Primary OS:
    Mac 10.11.x El Capitan
    Lightroom Version:
    Classic 7
    I think the only person who might be able to confirm this would be Victoria's contact at Adobe (and Victoria's away at the moment so unlikely to be able to ask him), though from my own experience of such issues I can't recall a catalog being restored successfully after being recovered by a file recovery utility. Some of the other long-standing members here might have a different recollection.
     
  20. holgermischke

    holgermischke New Member

    Joined:
    Sep 20, 2014
    Messages:
    5
    Location:
    Grefrath, Germany
    Lightroom Experience:
    Intermediate
    Primary OS:
    Windows 10
    Hi Jim. Thanks for the quick response. That's exactly what i thought. When i tried rebuilding, it wouldn't even let me open the database in a database viewer. The viewer always asked for a password as it considered the file to be encrypted. I also asked on Stackoverflow and people much more experienced with SQL databases said that a recovery utility would only produce a file full of "garbage data" and it just would not contain the original data. Just what you said. Thanks for confirming so i won't waste more time with those recovered catalogs.
     
  21. johnbeardy

    johnbeardy Senior Member Staff Member Moderator Lightroom Guru

    Joined:
    Oct 8, 2007
    Messages:
    4,457
    Location:
    London
    Lightroom Experience:
    Power User
    Primary OS:
    Windows 10
    Normally, Holger, one would not expect the LR database to be password protected. FYI.
     
  22. holgermischke

    holgermischke New Member

    Joined:
    Sep 20, 2014
    Messages:
    5
    Location:
    Grefrath, Germany
    Lightroom Experience:
    Intermediate
    Primary OS:
    Windows 10
    John, it's not that the Lightroom database is password protected. It's what the recover utility does with the database during the process what makes the database viewer "think" it would be encrypted and password protected. FYI.
     
  23. nordychic

    nordychic New Member

    Joined:
    Apr 12, 2010
    Messages:
    10
    Location:
    AZ
    Lightroom Experience:
    Advanced
    Primary OS:
    Mac 10.13.x High Sierra
    I've been scouring the internet for over a day trying to figure out how to recover my deleted lrcat (I don't recall deleting it, but it's definitely not on my harddrive, nor are my backup files!) ugh. I downloaded Disk Drill and it recovered many lrcat files - but now I don't know what to do with them (nor figure out which is my last one used). I do have a time machine back up from about a week ago, but I am trying to recover edits from a wedding I just finished yesterday (fingers crossed). Any help would be appreciated. Worst off, I will have to re-edit that wedding and half of another.
     
  24. jebir

    jebir New Member

    Joined:
    Jan 9, 2011
    Messages:
    11
    Upgraded my Windows 10 the day before yesterday and used Lightroom for the first time yetserday. No problems to open the latest catalog (named "2015-2017") and worked for a long time cataloging and deleting a backlog of work. I left the computer with LR opened during the night and it seems like the computer switched off unexpectedly during the night.
    Now this morning, I get the message: The catalog is damaged and that Lightroom will try to repair it. When I click OK and it tries to repair but gets back with the message that it failed and can make a new try. It never succeeds no matter how many tries I ask LR to do.
    So, I first got the impression that something had happened to the catalog "2015-2017" which is my current catalog but then I tried to start Lightroom by opening another catalog that had not been used since a long time back and it behaved exactly the same way. Tried a third catalog, also not used in a while, and it gives the same error messages and suggestions to repair the catalogs. This indicates that the fault is not actually a corrupt catalog but rather somewhere in Lightrooms startup procedure. Could that be the case?
    I have tried to search the internet for a solution but never come across this situation where all catalogs give the same error.

    I don't want to fiddle around trying to repair catalogs if the fault is somewhere else. Please give me an advice on how to proceed.

    Best regards, Jens Birch
     
  25. JohanElzenga

    JohanElzenga Lightroom Guru Staff Member Lightroom Guru

    Joined:
    Jul 2, 2015
    Messages:
    6,283
    Location:
    Netherlands
    Lightroom Experience:
    Power User
    Primary OS:
    Mac 10.13.x High Sierra
    Lightroom Version:
    Classic 7

Share This Page