8 Messages
•
240 Points
Thu, Oct 11, 2018 2:54 AM
Acknowledged
Lightroom Classic: Library Filter using Location Metadata does not reflect removed location metadata
When adding/changing location metadata on images, the Library Filter location columns are updated to reflect this change. However, when removing location metadata (sublocation, city, possibly others) from an image with GPS coordinates, the Library Filter location columns continue to show the previous value. Removing this metadata from images without GPS coordinates results in the Library Filter correctly updating to "Unknown Location".
In the screenshot below, I had set this image to have a sublocation of "Out of date". I then erased the sublocation in the metadata pane. As you can see, The Library Filter is filtering to only show images with a location of "Out of date", yet that field is empty in the selected image.

If I then change the sublocation to a non-empty value, the Library Filter correctly updates itself.

This is happening on Lightroom Classic 7.5.
It appears to me that the problem is that Lightroom is not correctly updating the AgHarvestedIptcMetadata table when clearing the location data. Below is a SQL dump of this table when adding/clearing sublocation on two new images (one with GPS data, one without). This dump and the above screenshots are from different tests.
Initial state:
After setting sublocation to "abc" in Lightroom:
After clearing sublocation in Lightroom:
Notice how the image without GPS coordinates was reset to the initial state, yet the one with GPS coordinates retained the sublocation data (958442 is the ID given to the location).
If I manually null out the sublocation on this entry in the DB, Lightroom immediately shows the expected "Unknown Location" in Library Filter:
Obviously, I don't want to be manually editing my catalog. But I would like to be able to clear out location data after incorrectly setting it, and still have Library Filter work correctly.
In the screenshot below, I had set this image to have a sublocation of "Out of date". I then erased the sublocation in the metadata pane. As you can see, The Library Filter is filtering to only show images with a location of "Out of date", yet that field is empty in the selected image.
If I then change the sublocation to a non-empty value, the Library Filter correctly updates itself.
This is happening on Lightroom Classic 7.5.
It appears to me that the problem is that Lightroom is not correctly updating the AgHarvestedIptcMetadata table when clearing the location data. Below is a SQL dump of this table when adding/clearing sublocation on two new images (one with GPS data, one without). This dump and the above screenshots are from different tests.
Initial state:
sqlite> select * from AgHarvestedIptcMetadata where image in (570455,570463);
572347|570455|||||||unset|-1.0||
572457|570463|||||||gps|-1.0||
After setting sublocation to "abc" in Lightroom:
sqlite> select * from AgHarvestedIptcMetadata where image in (570455,570463);
572347|570455|||||||unset|-1.0|958442|
572457|570463|||||||gps|-1.0|958442|
After clearing sublocation in Lightroom:
sqlite> select * from AgHarvestedIptcMetadata where image in (570455,570463);
572347|570455|||||||unset|-1.0||
572457|570463|||||||gps|-1.0|958442|
Notice how the image without GPS coordinates was reset to the initial state, yet the one with GPS coordinates retained the sublocation data (958442 is the ID given to the location).
If I manually null out the sublocation on this entry in the DB, Lightroom immediately shows the expected "Unknown Location" in Library Filter:
sqlite> update AgHarvestedIptcMetadata set locationRef=null where image in (570463);
sqlite> select * from AgHarvestedIptcMetadata where image in (570455,570463);
572347|570455|||||||unset|-1.0||
572457|570463|||||||gps|-1.0||
Obviously, I don't want to be manually editing my catalog. But I would like to be able to clear out location data after incorrectly setting it, and still have Library Filter work correctly.
Problems
•
Updated
2 years ago
72
10
Helpful Widget
How can we improve?
Tags
No tags available
Responses
John_R_Ellis
Champion
•
5.6K Messages
•
98.1K Points
2 years ago
1
0
John_R_Ellis
Champion
•
5.6K Messages
•
98.1K Points
2 years ago
0
0
nathan_hunsperger
8 Messages
•
240 Points
2 years ago
0
0
nathan_hunsperger
8 Messages
•
240 Points
2 years ago
- Create a new catalog
- Import 2 photos. One with GPS coordinates, one without.
- Open the Metadata Filter and choose Location Columns.
- Observe that all 4 Metadata Filter columns show "Unknown ___ (2)".
- Select both photos (or do it to both individually), and set Sublocation, City, State, and Country to "Out of date".
- Observe that all 4 Metadata Filter columns show "Out of date (2)". This is expected.
- Select both photos (or do it to both individually), and erase the Sublocation metadata.
- Observe that all 4 Metadata Filter columns still show "Out of date (2)". My expectation is that the Sublocation column show "Unknown ___ (2)", since the metadata field is blank for both photos.
- Select both photos (or do it to both individually), and erase the Country metadata.
- Observe that all 4 Metadata Filter columns still show "Out of date (2)". My expectation is that the Sublocation and Country columns show "Unknown ___ (2)".
- Select both photos (or do it to both individually), and erase the City metadata.
- Observe that all 4 Metadata Filter columns still show "Out of date (2)". My expectation is that the Sublocation, Country, and City columns show "Unknown ___ (2)".
- Select both photos (or do it to both individually), and erase the State metadata.
- Observe that all 4 Metadata Filter columns now show "Out of date (1), Unknown ___ (1)". My expectation is that all 4 columns show "Unknown ___ (2)".
- Select "Out of date" from any of the 4 columns.
- Observe that Lightroom filters to show the photo with GPS coordinates, and that the metadata pane clearly shows that none of the fields have "Out of date" for a value.
Steps 7-14 show that the Metadata Filter does not update to show erased location data until all location data is erased. As a user, my expectation is that the Metadata Filter updates to show "Unknown ___" for each field individually after erasing that field in the metadata pane. The Metadata Filter immediately updates when setting/changing any of these fields individually, so clearing any should also cause an immediate update.Steps 13-16 show that photos with GPS coordinates get stuck in this "Out of date" state. At a minimum, the photo with GPS coordinates should have returned to "Unknown ___" state in the Metadata Filter like the photo without GPS coordinates did at step 14. But I would still prefer to see the Metadata Filter update to "Unknown ___" for each field individually when erasing them.
0
0
John_R_Ellis
Champion
•
5.6K Messages
•
98.1K Points
2 years ago
0
0
reetesh_mukul
49 Messages
•
744 Points
2 years ago
0
Rikk
Adobe Administrator
•
9.5K Messages
•
130.5K Points
2 years ago
Quality Engineering - Customer Advocacy
0
0
roland_smiderkal
3 Messages
•
132 Points
2 years ago
Screenshot here: https://www2.pic-upload.de/img/36181976/Lightroom8.0Issue.jpg
0
0
alan_harper
480 Messages
•
10.5K Points
2 years ago
Lightroom Classic version: 8.0 [ 1193777 ]License: Creative Cloud
Language setting: en-US
Operating system: Mac OS 10
Version: 10.14.0 [18A391]
Application architecture: x64
Logical processor count: 8
Processor speed: 4.0 GHz
Built-in memory: 32,768.0 MB
Real memory available to Lightroom: 32,768.0 MB
0
0
ianbutty
26 Messages
•
1.2K Points
2 years ago
I know I can type my own values into the field but how do I delete the 'italicised' version because as soon as I click on the field it disappears but then reappears when I click away.
I've created a short screen capture to show what the problem is (John R Ellis suggested a workround with Any Tag but event that doesn't work the video also shows that failing)
Problem with Lightroom Address Lookup - YouTube
1
0