Remove tag association with faces

[Mick Sulley]

Sorry, which database do you mean?  In my album directory I have 
digikam4.db, recognition.db, thumbnails-digikam.db and 
thumbnails-digikam4.db (which is empty)



On 31/12/16 14:09, Simon Frei wrote:
> 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?
>>>>>