Browsing by tag sometimes shows items with alternative tag

[Mario Frank]

Hey Meku,

I think this is a bug. But I

1) do not have a MySQL (and currently not the possibility to create one)
to test and confirm

2) Thus also cannot fix the problem shorthand.

I opened a bugzilla entry with your and mine findings here:

https://bugs.kde.org/show_bug.cgi?id=383326

I hope one of the other devs can fix it faster than I.

Best,

Mario


"Am 09.08.2017 um 14:36 schrieb meku:
Studying the database there appears to be some inconsistent data in the
Tags table causing this.

Tag B probably used to be a child of Tag A, but some time ago Tag B was
moved to the root.

Tag B's 'pid' is '0' because it a child of the root node, but the 'lft'
and 'rgt' fields have not been updated so still fall within the range of
Tag A's 'lft' and 'rgt'.

If browsing using Tags with "Include Tag Sub-Tree" enabled relies on the
'lft' and 'rgt' fields then it would explain the inconsistent behaviour
I'm seeing - and it appears it only happens to Tags that have been moved
in the hierarchy.

Is this a bug, and is there a mysql query to repair it?"

Am 08.08.2017 um 15:45 schrieb Mario Frank:
>
> Hi Meku,
>
> this is odd, as when the disabling solves the problem, the unexpected
> items must have
>
> a tag that is a child tag of A. At least for sanity reasons.
>
> The source code itself looks good. Gilles, can you take a look at the
> definition of
>
> getItemIDsInTagRecursive in the dbconfig? For me, it looks correct, too.
>
> Can you send a screenshot or something like this?
>
> Cheers,
> Mario
>
> Am 08.08.2017 um 15:10 schrieb meku:
>> Hi Mario,
>>
>> Yes, disabling "Include Tag Sub-Tree" hides the unexpected items.
>>
>> Tag B is not a child of Tag A and the unexpected items do not have
>> Tag A or any of A's child tags.
>>
>> I can work with mysql queries.
>>
>> On 8 August 2017 at 22:55, Mario Frank <mafrank at uni-potsdam.de
>> <mailto:mafrank at uni-potsdam.de>> wrote:
>>
>>     Hi Meku,
>>
>>     can you check the following?
>>
>>     In menu View: is the option "include tag tree" (I do not know how
>>     it is
>>     called exactly in the English version, I have the German one)
>>
>>     checked? If yes, images with subtags are also shown in the
>>     browser and
>>     may have tag B.
>>
>>     Otherwise, do you have experience with MySQL queries?
>>
>>     Cheers,
>>
>>     Mario
>>
>>
>>     Am 08.08.2017 um 14:46 schrieb meku:
>>     > I am seeing some inconsistent behaviour when browsing items by
>>     Tags.
>>     >
>>     > Selecting a single tag (A) in the tree shows all items with tag (A)
>>     > but also unrelated items with tag (B).  So far I have only
>>     discovered
>>     > this happening for a few specific tags, but it continues happening
>>     > after restarting Digikam.
>>     >
>>     > If I use the Search for tag (A) then it shows the expected results,
>>     > it's only within the Tag browser that this issue is occurring.
>>     >
>>     > Using Digikam 5.7 appbundle with mysql.
>>
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170809/1f912f20/attachment.html>