• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
Locked
0

Photos corrupt / grayed in database (can’t delete)

Community Beginner ,
Apr 03, 2019 Apr 03, 2019

Copy link to clipboard

Copied

Hello

During a file import (approx 300 files) I had four items that seem to be corrupted in the LR database.    These four don’t show any actual image (they just look like a grey box).   In addition there is no file name shown or any other info.    When I right click on them to try to delete them from the library nothing happens.

My question is how I can remove these corrupted entries from the database?   I tried to run optimize and the back up (which claims it is checking database integrity).    Neither option seems to have help bring these to a state that I can do anything with them.

Has anyone seen this issue before or have any ideas?

Thanks

Harley

Views

449

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Apr 03, 2019 Apr 03, 2019

Copy link to clipboard

Copied

Are they identifiably shots you are missing?

I can see that you can't delete them from Lightroom, but is there any metadata attached to the thumbnail?

It might others to see screen shot of this as well as have LR system version and OS thanks

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 03, 2019 Apr 03, 2019

Copy link to clipboard

Copied

They are shots that were part of the import for sure.   The problem is that I was moving the items as part of the import and since they were a few hundred of them I don’t know exactly which files are the problem.    I am at work but can send a screen shot when I get home.    I am running LR Classic latest version on an iMac running latest OSX.

Basically the items show up in the grid, but the boxes are just grey (like it would look before it generated thumbnails).    Plus there is no information on the items (no file name, metadata, anything).    If I try to do anything with them (like develop etc) it either does nothing or freezes up.     When I try to right click on the items to go to remove nothing happens.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 03, 2019 Apr 03, 2019

Copy link to clipboard

Copied

These are false database records. I have seen this problem discussed here a few times, and apart from perhaps manually removing them with some SQL editor, the best option seems to be to restore the catalog from a backup.

-- Johan W. Elzenga

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 03, 2019 Apr 03, 2019

Copy link to clipboard

Copied

Interesting....   so you need to basically restore it from just before the import?   They don’t have any cleanup/repair utility that you can run on the db?     Do you happen to have a link to the previous discussion?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 03, 2019 Apr 03, 2019

Copy link to clipboard

Copied

Yes, restore the catalog from a backup just before the import and then import the images again. Another option is to select all images except the empty cells, and then export these as a new catalog. See Grey thumbnails that can't be deleted? and Grey boxes appearing in Lightroom

There is no repair utility that I know of.

-- Johan W. Elzenga

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Oct 15, 2023 Oct 15, 2023

Copy link to clipboard

Copied

Has this been fixed yet? I imported thousands of files today from a stack of disks and wiped the disks as I went. The last disk had some corrupt files that I now can't delete because I get this internal error message. I get the message every time I try to delete the corrupt files along with some legitimate files. If I try to delete just the corrupt files, Lightroom freezes. And freezes so badly that I can't call up task manager with Ctrl-Alt-Del. And I even have to reboot by holding the power button in.  If I restore to yesterday's catalog backup, I lose thousands of photos that I worked on today, permanently, since the disks are wiped. What a mess!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Oct 16, 2023 Oct 16, 2023

Copy link to clipboard

Copied

LATEST

You’ve posted to an ancient thread. It is highly unlikely that the issue described in this thread, though not impossible, is the same one you are currently experiencing. Rather than resurrect an old thread that is seemingly similar, you are better off posting to a new thread with fresh, complete information, including system information, a complete description of the problem, and step-by-step instructions for reproduction. 

 

If the issue is the same, we will merge you back into the appropriate location. 

 

Thank you!

 

Rikk Flohr - Customer Advocacy: Adobe Photography Products

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines