[digiKam-users] Oddity in tag manager display

[Michael Gauland]

I asked the tag manager to display images tagged 'Farmers Market', and
it included a dozen or so images that were tagged 'dandelions', but
*not* 'Farmers Market'.

I've confirmed both through Digikam and by looking at the sqlite
database that the images do not have the 'Farmers Market' tag, and
restarted Digikam, but the tag manager insists on displaying them.

If I add a filter to show just images tagged 'Farmers Market', the
dandelions disappear, so some part of Digikam knows they aren't 'Farmers
Market' photos.

This isn't causing me any real problems, but I'm curious about what may
be causing it. Any ideas?

[Peter McD]

Am 03.05.2018 um 05:22 schrieb Michael Gauland:

> I asked the tag manager to display images tagged 'Farmers Market', and
> it included a dozen or so images that were tagged 'dandelions', but
> *not* 'Farmers Market'.
>
> I've confirmed both through Digikam and by looking at the sqlite
> database that the images do not have the 'Farmers Market' tag, and
> restarted Digikam, but the tag manager insists on displaying them.
>
> If I add a filter to show just images tagged 'Farmers Market', the
> dandelions disappear, so some part of Digikam knows they aren't 'Farmers
> Market' photos.
>
> This isn't causing me any real problems, but I'm curious about what may
> be causing it. Any ideas?
>

Again, no Digikam Version, no OS :-(

cu
Peter

[Michael Gauland]

On 03/05/18 18:42, Peter McD wrote:

> Am 03.05.2018 um 05:22 schrieb Michael Gauland:
>> I asked the tag manager to display images tagged 'Farmers Market', and
>> it included a dozen or so images that were tagged 'dandelions', but
>> *not* 'Farmers Market'.
>>
>> I've confirmed both through Digikam and by looking at the sqlite
>> database that the images do not have the 'Farmers Market' tag, and
>> restarted Digikam, but the tag manager insists on displaying them.
>>
>> If I add a filter to show just images tagged 'Farmers Market', the
>> dandelions disappear, so some part of Digikam knows they aren't 'Farmers
>> Market' photos.
>>
>> This isn't causing me any real problems, but I'm curious about what may
>> be causing it. Any ideas?
>>
>
> Again, no Digikam Version, no OS :-(
>
> cu
> Peter
>

5.9.0, Debian, 9.4 (64-bit)

[Simon Cropper]

On 03/05/18 19:07, Michael Gauland wrote:

>
> On 03/05/18 18:42, Peter McD wrote:
>> Am 03.05.2018 um 05:22 schrieb Michael Gauland:
>>> I asked the tag manager to display images tagged 'Farmers Market', and
>>> it included a dozen or so images that were tagged 'dandelions', but
>>> *not* 'Farmers Market'.
>>>
>>> I've confirmed both through Digikam and by looking at the sqlite
>>> database that the images do not have the 'Farmers Market' tag, and
>>> restarted Digikam, but the tag manager insists on displaying them.
>>>
>>> If I add a filter to show just images tagged 'Farmers Market', the
>>> dandelions disappear, so some part of Digikam knows they aren't 'Farmers
>>> Market' photos.
>>>
>>> This isn't causing me any real problems, but I'm curious about what may
>>> be causing it. Any ideas?
>>>
>> Again, no Digikam Version, no OS :-(
>>
>> cu
>> Peter
>>
> 5.9.0, Debian, 9.4 (64-bit)

I would suggest rebuilding the tag database.

Tools > Maintenance > Tags Tab

It sounds as if the index has been corrupted.

--
Cheers Simon

[Maik Qualmann]

SQLite or MySQL database? I suspect MySQL. With digiKam < 5.8.0, when tags
were moved, the table for the tags tree was not calculated correctly. Use the
database migration dialog to exporting the database to a new one and using
this, or reimporting into the old database should solve the problem. You can
also execute MySQL-> SQlite-> MySQL

Maik

Am Donnerstag, 3. Mai 2018, 05:22:39 CEST schrieb Michael Gauland:

> I asked the tag manager to display images tagged 'Farmers Market', and
> it included a dozen or so images that were tagged 'dandelions', but
> *not* 'Farmers Market'.
>
> I've confirmed both through Digikam and by looking at the sqlite
> database that the images do not have the 'Farmers Market' tag, and
> restarted Digikam, but the tag manager insists on displaying them.
>
> If I add a filter to show just images tagged 'Farmers Market', the
> dandelions disappear, so some part of Digikam knows they aren't 'Farmers
> Market' photos.
>
> This isn't causing me any real problems, but I'm curious about what may
> be causing it. Any ideas?

[Michael Gauland]

On 04/05/18 08:34, Maik Qualmann wrote:
> SQLite or MySQL database? I suspect MySQL. With digiKam < 5.8.0, when tags
> were moved, the table for the tags tree was not calculated correctly. Use the
> database migration dialog to exporting the database to a new one and using
> this, or reimporting into the old database should solve the problem. You can
> also execute MySQL-> SQlite-> MySQL
>
> Maik

SQLite. Migrating to a new SQLite database took hours, but fixed the
problem.

Another suggestion I received was to use the Maintenance tool:

    Tools > Maintenance > Common Options > Tags Tab

    Check the "Whole tags collection" and click "OK"

That also seems to have done the trick, and was much faster.