Lightroom 2015.9 creates strange duplicate version of folder for HDR/pano images

  • 1
  • Problem
  • Updated 2 years ago
I have a problem regarding how LR 2015.09 presents and handles my MacOS 10.12 file system. The same folder appears in two places in the Folders panel, with different contents shown. Using "Show in Finder" points to the same single folder, though, with all the images.

When I import photos, they arrive by the method I've used for years in a folder hierarchy of YYYY/YYYY-MM/YYYY-MM-DD. However, when I create HDR or panoramic images, they show up in a separate YYYY-MM-DD folder entry lower down the panel. (The folders are all stored on my Mac's built-in SSD in /Pictures folder.)



If I try to manually drag photos from the original folder to the newer one, or vice-versa, LR stops me with an error message: "File already exists at the destination."



If I click "update folder location" on the original folder, LR "moves" all the photos to the second entry farther down and removes the original folder.

If I click "update folder location" on the LR-generated second entry, nothing happens. If I click "show parent folder" for the second folder entry, it adds a YYYY-MM folder. If I click "show parent folder" on that folder, I get an error message:


Database "/Users/sts/Pictures/Lightroom/LR6 full archive.lrcat": UNIQUE constraint failed: AgLibraryFolder.rootFolder, AgLibraryFolder.pathFromRoot

  Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?; (error code 19)


I fear that something in the LR catalog was corrupted during a recent OS reinstall, but I can't be sure. It also could have occurred when I moved to a new Mac a few weeks before that.

I tried searching forums for similar problems but I'm not sure anything matches. This one looks similar on the surface but I think it's different: https://forums.adobe.com/message/9354068#9354068
Photo of Stephen Shankland

Stephen Shankland

  • 87 Posts
  • 14 Reply Likes

Posted 2 years ago

  • 1
Photo of Jim Wilde

Jim Wilde, Champion

  • 294 Posts
  • 97 Reply Likes
It possibly is the same "capitalisation" bug as in the link that you provided. Hover the cursor in turn over each of the two 2107-03-22 subfolders in the Folders Panel, waiting each time until a tool-tip pops up with the full path of the sub-folder. Note each one down, paying careful attention to the capitalisation of each path. If it's the same problem, there will be a difference in the two paths.

Report back with the findings and if it is that problem we can probably provide instructions to fix. A screenshot of the rest of the Folders Panel above the section that you've already shown would also be a help.
Photo of Stephen Shankland

Stephen Shankland

  • 87 Posts
  • 14 Reply Likes
Unfortunately it regressed again today. I think the trigger was some synchronization of some DNGs I took with LR Mobile. Once again my catalog view split. I fixed as before.

I can't fix at a higher level than /2017 because I can't show the parent folder of /2017 (Pictures). I only get an error message:

Database "/Users/sts/Pictures/Lightroom/LR6 full archive.lrcat": UNIQUE constraint failed: AgLibraryFolder.rootFolder, AgLibraryFolder.pathFromRoot

  Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?; (error code 19)

Photo of Jim Wilde

Jim Wilde, Champion

  • 294 Posts
  • 97 Reply Likes
Looking at your screenshots again, I see that only the 2017 folder is showing in the Folders Panel. What about the rest of your 80k images, are they also on the Macintosh HD drive, or a different drive? If they are on the Mac HD drive, are any of their folders listed in the Folders Panel?
Photo of Stephen Shankland

Stephen Shankland

  • 87 Posts
  • 14 Reply Likes
The other images are on an external drive that doesn't seem perturbed by the craziness. (Though I had to get it straightened out before I could copy folders from my Mac's SSD to the external drive.)
Photo of Jim Wilde

Jim Wilde, Champion

  • 294 Posts
  • 97 Reply Likes
OK, do the hovering thing over both the 2011 and 2017 year folders to confirm they still have the "wrong" path. If they do, you should just need to "fix" those two year folders, and that should be the problem solved.
Photo of Stephen Shankland

Stephen Shankland

  • 87 Posts
  • 14 Reply Likes
They have the right path right now, but only because I've gone back and fixed the path several times. LR re-introduces the error if I create a new HDR or pano merge (sometimes but not always) or if I shoot photos with LR mobile that are synced.