Dupe folders in Lightroom catalog, throws internal error

  • 9
  • Problem
  • Updated 5 years ago
Bug report, Adobe Lightroom 4.1RC2 (build 825534), Mac OS X Lion:

I have the following directory structure in my catalog:

Life
2012
20120102... (etc)

I import into subfolders in the “2012′′ directory. When I import from a card, it makes the subfolder in the right place in the file system, but in the Lightroom catalog, makes the new subfolder at the top level. If I right click and select “Show Parent Folder”, it shows “2012′′. If I right click on “2012′′ and select “Show Parent Folder,” I get an internal error:

“Database “/Volumes/Mako/Users/echeng/Pictures/Lightroom Libraries/Lightroom Life v4/Lightroom Life v4.lrcat”: columns rootFolder, pathFromRoot are not unique
Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?;”

It’s trying to show a second “Life” folder, which shouldn’t be possible.

To fix this, I have to “update location,” which merges the two “2012′′ folders properly, even they they are both pointing to the same location on the file system.
Photo of Eric Cheng

Eric Cheng

  • 1 Post
  • 0 Reply Likes

Posted 7 years ago

  • 9
Photo of etm117

etm117

  • 1 Post
  • 0 Reply Likes
I don't want to do the update location for fear of losing something. I just want it to work without having duplicates around. This makes me nervous about my catalog at this point.
Photo of Michael Houlden

Michael Houlden

  • 4 Posts
  • 0 Reply Likes
etm117, you won't lose data, Update folder location move the folder reference to the correct position in your hierarchy. This is a real PITA. I, too, experience this everytime I import and choose "Add" versus copy or move.
Photo of Michael Houlden

Michael Houlden

  • 4 Posts
  • 0 Reply Likes
I also experience this issue when round tripping some images to Photoshop. I haven't been able to narrow down the specific circumstances causing it, but after saving and closing an image I sent to photoshop from Lightroom, I find a new reference to the folder location at the top level of the hierarchy in LR, rather than including the file in the existing folder reference within the existing folder hierarchy.
Photo of Daniel Arbeeny

Daniel Arbeeny

  • 46 Posts
  • 0 Reply Likes
I have installed LR 4.1 RC and converted my PSE 10 catalog of ~37k images & videos. The import seemed to go well keeping the keyword tags and captions (I checked only a small a random sample so far). 99% of my images are in a specific folder C:\Our Files\Pictures

In the Library, I rightclick on a folder and select Show Parent Folder, I get the following error:

An internal error has occurred: Database "c:\Users\Daddy\Pictures\Lightroom\Lightroom\Lightroom 4 Catalog.Iract": columns rootFolder,pathFromRoot are not unique

Statement: UPDATE AgLibreryFolder SET rootFolder = ? WHERE id_local = ?;

The images are in the following folder:
C:\Our Files\Pictures

However, IT WORKS when I do the very same thing to a folder in:
c:\Users\Daddy\Documents\Adobe\Premiere Elements 4.0\
This folder and others like it are the default folder that Premiere Elements uses for it’s videos.

Any help would be greatly appreciated.

PS: I am new to LR but PSE is no longer able to safely handle a large catalog so I am attempting to move to LR.

This reply was created from a merged topic originally titled
Show Parent Folder Bug in LR 4.1 RC.
Photo of Susan Ferber

Susan Ferber

  • 3 Posts
  • 0 Reply Likes
When I updated to Lightroom 4, I found that previews were missing from some folders (ie. the folder reported 16 photos when [in Lightroom 3] there had been 50 that were previously imported and worked on). The only previews that remain are to psds created from some of the photos within the folder.

On a forum it was suggested that I try to view the parent folder in the nav sidebar. I got this internal error message:

Database "/Users/susanferber/Pictures/Lightroom/Lightroom 4 Catalog.lrcat": columns rootFolder, pathRomRoot are not unique
Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?

This must be a bug within LR4 that renders it kind of useless as a photo database.

This reply was created from a merged topic originally titled
Previews/photos missing in Lightroom 4.
Photo of David Skok

David Skok

  • 4 Posts
  • 1 Reply Like
I have Lightroom 4.1 and have a problem with one of my folders "2012 Photos". Half of the folders that are contained inside of 2012 Photos, show up in the tree below it, but the name of the folder has been capitalized to "2012 PHOTOS". Some of the folders that are inside of "2012 Photos" show up as their own level in the tree. When I try to "Show Parent Folder", I get the following error:

Database "/Users/David/Pictures/Lightroom/Lightroom Catalog.lrcat": columns rootFolder, pathFromRoot are not unique
Statement: UPDATE AgLibraryFolder SET rootFolder = ?,pathFromRoot = ? WHERE id_local = ?;

When I try "Show Parent Folder" on one of the folders that is not in the tree below "2012 Photos", I get a similar error.

Eventually I corrected the problem by creating a new directory in Finder and copying all the folders there in Finder, then in Lightroom I used "Locate Missing folder" to find them in their new location. Then finally deleted the offending "2012 Photos".

However this is not the first time I have seen this problem, and I see on the web that others have the same issue.

This reply was created from a merged topic originally titled
Lightroom 4.1 "Show parent folder" database error.
Photo of Gary Stoy

Gary Stoy

  • 1 Post
  • 0 Reply Likes
So...I see this topic has been around for over a year, Has Adobe address it yet? Or is this not the right place to expect an answer? I have the "split database" problem described about and would like to correct it.
Photo of Daniel Arbeeny

Daniel Arbeeny

  • 46 Posts
  • 0 Reply Likes
I need to check v4.1 to see if they did anything about it.
Photo of Harald Mühlhoff

Harald Mühlhoff

  • 2 Posts
  • 0 Reply Likes
I'm using Lightroom v5.3 and the bug is still there ... what is worse is that by using update location I loose the information in the LR catalog (for the subtree) - gladly I had a very recent backup ...

PS: Just exporting and reimporting the "duplicate" root as a catalog didn't help (the folder "2013" reappeared outside of "images\2013"). I had to export the metadata (xmp), delete the subtree in Lightroom and add the "new" files again.