Remove tag association with faces

[Simon Frei]

You also need to remove the persons from the identity table of the face
database. However there is more information in the face database
associated with that identity. I do not know if these will automatically
be cleaned up when digikam is next run or if it will become messy. Just
keep backing up before trying it out.


On 30/12/16 23:08, Mick Sulley wrote:
> OK I have half fixed it.  Here is what I did in case anyone is
> interested -
>
> Create backup of the database, (just copy digikam4.db)
> Open a SQLite Manager in Firefox
> Browse the 'tags' table and note the id of the tag with name 'People',
> mine was 22
> in the 'Execute SQL' tab run
>
> select * from tagproperties
> where property = 'person'
> and tagid not in
> (select t.id from tags t, tagstree tt
> where tt.pid = 22
> and tt.id = t.id)
>
> This should list all of the tags that are listed under People in the
> left tab but are not really people
> If that list looks like the ones you want to remove run
>
> delete  from tagproperties
> where property = 'person'
> and tagid not in
> (select t.id from tags t, tagstree tt
> where tt.pid = 22
> and tt.id = t.id)
>
> I now only see real people tags on the left side, however, when I try
> to tag someone I still get non person tags listed in the suggestions. 
> Does this mean that there is some other rouge data in my database?
>
> How does DK generate the list of suggestions?
>
> Mick
>
>
> On 30/12/16 15:33, Mick Sulley wrote:
>> Hi Simon,
>>
>> Thanks for the info.  I have done some database stuff in the past, so
>> I will have a poke around and see what I can do.
>>
>> Mick
>>
>>
>> On 30/12/16 15:23, Simon Frei wrote:
>>> Hi Mick,
>>>
>>> We are hijacking an unrelated bug with this, it is probably more
>>> appropriate to continue this discussion here.
>>> I am currently working on a feature to remove face identities from the
>>> database and thus also marking the tag as not a people tag. You can
>>> either wait for that or try to fix your problem in the database.
>>> I never ventured into the database code, but I think the sql line
>>> responsible for the people association of a tag is
>>>      INSERT INTO TagProperties (tagid, property, value) VALUES(?, ?,
>>> ?);
>>> where the property value is "person". The existence of this property
>>> marks the tag as a people tag.
>>>
>>> Cheers,
>>> Simon
>>>
>>> On 30/12/16 16:01, Mick Sulley wrote:
>>>> https://bugs.kde.org/show_bug.cgi?id=360155
>>>>
>>>> --- Comment #12 from Mick Sulley <mick at sulley.info> ---
>>>> I have just gone through all of the non-people tags on the left,
>>>> none of them
>>>> link to any pictures, so I guess it is a problem with the
>>>> database.  Do you
>>>> know which table identifies a tag as a face tag?
>>>>
>>>
>>
>