Copy link to clipboard
Copied
I've been using LR Classic since it's release. I have some 17,000 images in my collection. Everything was fine until yesterday. I've been spending weeks updating keywords and moving files from within LR Classic so I can be better organized. Late yesterday I opened LR Classic and all my file folders show 0 images. My Catalog still shows all the photo's however the folders still show zero. I have gotten the following error message when attempting to look at another catalog saved on my system:
Database "/Users/douglaschapman/Pictures/Lightroom/Lightroom Catalog-2.lrcat": UNIQUE constraint failed: AgLibraryFolder.rootFolder, AgLibraryFolder.pathFromRoot Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?; (error code 19)
I have a Lightroom Catalog. Ircat file on the system but Lightroom says it is NOT a current file and is not up to date. The Catalog-2.Ircat if the latest catalog.
If I try to import photo's from the existing folder it says the photo's are ALREADY imported. So the system knows where the files are... just won't display them.
You can see the images via the grid if I select All Photographs.
I created a new folder and moved some of my pics to that folder and I was able to import images from there... however, i LOST all the keywords, etc from those files. This is not acceptable. I've not looked but I image that I've lost all my edits too??
Can anyone recommend a way to get these photo's to show up so I don't lose years worth of keywords and edits?
Doug
Please go to the Catalog flyout panel. Once the images are in the grid - select one image and right-click - select Go to Folder in Library. Post a screen shot of that result. The images that you are posting are not showing that you have selected and image and right clicked on it. I'm happy to help you further if you want to private message me here.
Copy link to clipboard
Copied
Hi Doug,
We're sorry to hear about this, I believe this error occur due to a permissions issue. Could you please let us know where is that catalog stored?
Also, please try the steps mentioned on this article and let us know if it helps: Solutions to Adobe Lightroom Lightroom user permission issues on launch
Regards,
Sahil
Copy link to clipboard
Copied
the catalog is stored at: /Users/douglaschapman/Pictures/Lightroom/Lightroom Catalog-2.lrcat on my MAC Mini computer. I'll look at your solutions link.
Copy link to clipboard
Copied
I checked and I have permissions to access Read/Write on all those folders listed.
Copy link to clipboard
Copied
chapmand1952 wrote
I've been using LR Classic since it's release. I have some 17,000 images in my collection. Everything was fine until yesterday. I've been spending weeks updating keywords and moving files from within LR Classic so I can be better organized. Late yesterday I opened LR Classic and all my file folders show 0 images. My Catalog still shows all the photo's however the folders still show zero. I have gotten the following error message when attempting to look at another catalog saved on my system:
Database "/Users/douglaschapman/Pictures/Lightroom/Lightroom Catalog-2.lrcat": UNIQUE constraint failed: AgLibraryFolder.rootFolder, AgLibraryFolder.pathFromRoot Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?; (error code 19)
I have a Lightroom Catalog. Ircat file on the system but Lightroom says it is NOT a current file and is not up to date. The Catalog-2.Ircat if the latest catalog.
If I try to import photo's from the existing folder it says the photo's are ALREADY imported. So the system knows where the files are... just won't display them.
You can see the images via the grid if I select All Photographs.
Great, you can see them in Lightroom under "All Photographs", but they are not in the folder you think they are in. You have accidentally imported them into a different folder, and so you can't import the same photo twice (nor is it a good idea to import the photo more than once). In Lightroom, right-click on the photo and select Show in Finder (Mac) or Show in Explorer (Windows) so you can see what folder the files were accidentally imported into.
Depending on what you want to do next, we can advise you.
Please remember that Importing should only be done once on each photo, and importing is NOT a solution to catalog problems like this one. In fact, importing would make this problem worse.
Copy link to clipboard
Copied
I followed all 4 steps as requested. It points me right where I think it should be.
… and yet I cannot import or synchronize that folder. I feel that something is corrupted. Any other thoughts?
Doug
Copy link to clipboard
Copied
The method you gave me to find the photo's using Show in Finder is locating the file exactly where it has always been. It has not moved. Yet, LR Classic is not displaying under that folder... only in ALL in the Catalog All Photographs. I can do a series of screenshots to see if I can demo this for you. I am open to just about anything to try and solve this.
Thanks so much for your help.
Copy link to clipboard
Copied
Show us a screen capture of the entire Finder screen after you try the above.
Copy link to clipboard
Copied
Belos are my screenshots:
Above screenshot shows what LR Classic looks like prior to my Show in Finder...
The above screenshot shows the results when I right-click and Show in Finder...
The above screenshot shows results when I look for a filename in the folders in LR Classic... I thought this might help?
Thank YOU!
Copy link to clipboard
Copied
At this point, my unfamiliarity with Macintosh computers might become a problem. But it seems to me you are looking for folders on a disk called "Macintosh HD" in a subfolder named "Archives", while your screen capture of the Finder window does not show a disk named "Macintosh HD".
So either one of these two is correct:
Copy link to clipboard
Copied
could be lack of familiarity of MAC computers. The Macintosh HD is what I would call the root drive. There are several folders under that… one of which is the Users folder. I am the only user on the system… douglaschapman. This is where ‘my’ folders start… one of which is Pictures. In Pictures… you can see the screenshot showing Archives, Archives2, etc… my LR Classic photo’s start with the Archives Folder. From the 2 screenshots you can see all the subfolders from there.
To me…. the file system and the LR Classic are in sync as to where the pictures are physically stored on my computer. It’s just odd that that they show 0 files in those locations.
I’m willing to Uninstall the LR Classic software and reinstall it. I’d like to know what I will lose if I do so as there are years of keyboarding and photo edits associated with those 17K images.
Question… how do I get direct response from Adobe on this issue?
Doug
Copy link to clipboard
Copied
I tried to remove a folder with 0 images listed... LR Classic popes up a message saying it is removing the folder but it is still showing under the folder list in the Library.
Here are several screen shots I hope shows what you were looking for by your 3. request:
Here is the screenshot of LR Classic after I right clicked on an image and then clicked on Find in Folder:
I hope this is showing you what you needed to see.
Doug
Copy link to clipboard
Copied
Here is the screenshot of LR Classic after I right clicked on an image and then clicked on Find in Folder:
The request was: select a photo, right click and then choose "Go to Folder in Library"
One folder will be highlighted in the Folder Panel, you may have to scroll up or down to see the highlighted folder, show us a screen capture so we can see what was highlighted in the Folder Panel
Copy link to clipboard
Copied
right click image 1 and then clicked on Go to Folder in Library... note that the metadata on the right side of the screen indicates the image is in my 2018 folder... which agrees with my file finder too.
Below are 2 screenshots showing all the file folders... I don't see any of them highlighted.
Thank you... Doug
Copy link to clipboard
Copied
Please forgive me... but I went back to repeat the steps you gave me and this time I got a different result... this screenshot shows the result of Go To Library Folder... you originally requested. This is repeatable... I must have erred somehow a few minutes ago.
Copy link to clipboard
Copied
Are there any other hard disks shown in the Folder Panel, if you scroll down?
What happens if you restart your computer?
Copy link to clipboard
Copied
Are there any other hard disks shown in the Folder Panel, if you scroll down? NO
What happens if you restart your computer? No change.
Doug
Copy link to clipboard
Copied
Please go to the Catalog flyout panel. Once the images are in the grid - select one image and right-click - select Go to Folder in Library. Post a screen shot of that result. The images that you are posting are not showing that you have selected and image and right clicked on it. I'm happy to help you further if you want to private message me here.
Copy link to clipboard
Copied
Thank you cmgap! Turns out I had a corrupt Catalog.
I am back up and running with Lightroom Classic.
Thanks Again!!!
Doug
Copy link to clipboard
Copied
Hey Doug,
What did you end up doing to fix the corrupte Catalog? It seems I'm having the same issue you had.
thanks,
Marco
Copy link to clipboard
Copied