<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I have a bizarre and somewhat frustrating situation. I am using
digikam 7.5.0, as that is what my distribution provides.<br>
</p>
<p>I have a set of images which are spread across many folders in my
media library. They are sorted into various folders based on
date, and they span a few months. They are organized as <Media
Library Root>/<Year>/<Month>/<Date><br>
</p>
<p>Each image is tagged with a "Date of Import" tag, which is the
date when I added the images to my library.</p>
<p>There are 843 images tagged with an import date of 2018-05-17.</p>
<p>However, when I click on my media library root folder and I
filter based that import date tag (no other filters activated), I
get a count of <b>830</b>, which is incorrect. It is missing 13
images. Even more bizarre, if I click on the year "2018" in my
album hierarchy, the count is 843, which is correct. </p>
<p>I traced the issue to 13 images in a specific folder. If I move
images in that folder to another folder, like the day before or
after, then they are included in the count even at the library
root folder. If I move images from another folder into the
problem folder, they are removed from the root-folder count. I
tried deleting that folder and re-creating it, and it still has
the same problem. The problem appears to be isolated to this
folder, and to this particular tag.<br>
</p>
<p>I dug into the database using sqlitebrowser (read-only mode).
The only difference I could find between this folder all the
others is in the "Caption" and "Collection" fields. The "Caption"
field is blank, while all the other albums are "NULL". The
"Collection" field is "Uncategorized Album", while all the other
albums are "NULL" in that field. I generally don't use or edit
those fields in the UI - these albums are auto-generated when I
import images into my database.</p>
<p>I noted that when I create a new album, the "Collection" field is
set to "Uncategorized Album" by default. I also noted that the
drop-down for "Collection" in the album creation and album
properties dialogs has two blank entries before the other entries
(which are things like "Friends", "Family", etc). I checked a few
other albums, they have the second blank "Collection" item
selected, and this one has the first one selected. Setting it to
the second one appears to have no effect - the database still says
"Uncategorized Album". Setting it to another value does update
the database (i.e. it now says "Party") but when I set it back to
either of the blank entries shown in the UI, it reads
"Uncategorized Album" again.</p>
<p>I suspect that maybe the database schema was updates to use
"Uncategorized Album" instead of "NULL" at some point. But even
if that's true, I'm not sure how it relates to my main problem
above.</p>
<p>Can someone help me figure this out? I need accurate tag counts,
I use it to make sure my media library is properly updated and
managed.<br>
</p>
</body>
</html>