2016-08-21, 18:25
Hi Xycl!
It appears that more tags have a similar problem, not just the Person tag. I did an even more minimal test today. I added a single folder to MyPicsDB with 2 pictures. Both pics had the IPTC Caption/Description set to "Wow". I scanned them and I see 2 pics in the Browse by Tags -> Description -> Wow.
Then I edited one of the pictures and changed the caption to "Wowa". I scanned for new & changed pictures and MyPicsDB correctly shows 1 modified. Now Browse by Tags -> Description -> has only Wowa listed and Wow is missing.
However this does not happen always, sometimes both tags stayed - keep changing the caption from Wow to Wowa and back and the problem does happen soon enough. When it happens, I checked with a sqlite browser that the TagsInFiles.idTagContent has values which do not exist in TagContents table. It appears that instead of reusing the existing idTagType<->TagContent unique pair, a new record is added with a new idTagContent and the old pairs are deleted.
Is it a bug in the sqlite engine? I did my tests with v16.1 on Win7. I strongly believe it is the same problem on my main kodibuntu installation.
It appears that more tags have a similar problem, not just the Person tag. I did an even more minimal test today. I added a single folder to MyPicsDB with 2 pictures. Both pics had the IPTC Caption/Description set to "Wow". I scanned them and I see 2 pics in the Browse by Tags -> Description -> Wow.
Then I edited one of the pictures and changed the caption to "Wowa". I scanned for new & changed pictures and MyPicsDB correctly shows 1 modified. Now Browse by Tags -> Description -> has only Wowa listed and Wow is missing.
However this does not happen always, sometimes both tags stayed - keep changing the caption from Wow to Wowa and back and the problem does happen soon enough. When it happens, I checked with a sqlite browser that the TagsInFiles.idTagContent has values which do not exist in TagContents table. It appears that instead of reusing the existing idTagType<->TagContent unique pair, a new record is added with a new idTagContent and the old pairs are deleted.
Is it a bug in the sqlite engine? I did my tests with v16.1 on Win7. I strongly believe it is the same problem on my main kodibuntu installation.