[Digikam-devel] [digikam] [Bug 325331] When adding a new face tag with tagging face tool, tag is created with a new _Digikam_root_tag in mysql database

[e.longuemare at laposte.net]

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

--- Comment #2 from e.longuemare at laposte.net ---
Digikam mysql db before moving created tag and suppress "false"
"_Digikam_root_tag_" :

SELECT * FROM Tags where id=219; #ID of root tag for faces
id,pid,name,icon,iconkde,lft,rgt
'219', '0', 'Personnes', '0', NULL, '226', '265'

SELECT * FROM Tags where pid=219 order by id;
id,pid,name,icon,iconkde,lft,rgt
21,219,eric,0,NULL,852,853
36,219,charlotte,0,NULL,736,737
38,219,christelle,0,NULL,732,733
39,219,gonzague,0,NULL,730,731
46,219,chloe,0,NULL,716,717
48,219,anais,0,NULL,712,713
50,219,allan,0,NULL,708,709
52,219,simba,0,NULL,704,705
53,219,joel,0,NULL,702,703
54,219,viviane,0,NULL,700,701

SELECT * FROM Tags where name="IanGold" order by id;
id,pid,name,icon,iconkde,lft,rgt
'700', '699', 'IanGold', '0', NULL, '7', '8'

SELECT * FROM Tags where pid=699 order by id;
id,pid,name,icon,iconkde,lft,rgt
'700', '699', 'IanGold', '0', NULL, '7', '8'

SELECT * FROM Tags where id="699"
id,pid,name,icon,iconkde,lft,rgt
'699', '0', '_Digikam_root_tag_', '0', NULL, '6', '9'

SELECT * FROM Tags where name="_digikam_root_tag_" order by id;
id,pid,name,icon,iconkde,lft,rgt
'0', '-1', '_Digikam_root_tag_', '0', NULL, '5', '962'
'699', '0', '_Digikam_root_tag_', '0', NULL, '6', '9'

There is 2 _Digikam_root_tag. The new tag parent is the second
"Digikam_root_tag".

Now move tag to good parent, Personne (Faces in english), suppress bad
"_digikam_root_tag", stop and start digikam, then query on name "IanGolds"

SELECT * FROM Tags where name like "Ian%";
3    17:10:02    SELECT * FROM Tags where name like "Ian%" order by id LIMIT 0,
1000    0 row(s) returned

It has disapeared from mysql and digikam, nor face picture is no more in face
recognation.

In recognition.db (sqlite), the tag "IanGold" is still there :
"id", "attribute", "value"
"1", "fullName", "chloe"
"1", "name", "chloe"
"1", "uuid", "{3b6d168a-ea42-4407-8b10-6fedd8fc6f67}"
"2", "fullName", "fredb"
"2", "name", "fredb"
"2", "uuid", "{c9c862e8-9c34-437b-afb5-76c021ec6fc7}"
"3", "fullName", "francoisd"
"3", "name", "francoisd"
"3", "uuid", "{b8725e4c-978c-4b3a-9535-a19acc6ec408}"
"4", "fullName", "IanGold"
"4", "name", "IanGold"
"4", "uuid", "{3110f941-5181-4947-a0e4-9149c7861c2b}"

tags disapearing before too (fredb wich was created from tag face tool). The
two other ones, francoisd and chloe where created in tag list (left tab) and
attribute to face pictures so they are well created in recognation.db .

-- 
You are receiving this mail because:
You are the assignee for the bug.