[Bug 283323] New: a new label _Digikam_root_tag_ is created every time
Locked
123456
123456
[Bug 283323] a new label _Digikam_root_tag_ is created every time
 
|
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #20 from Michael Holtermann <linux michael-holtermann de> 2011-11-06 11:46:26 --- I've deleted the _digikam_root_tag_ from digikam and applied the reverse geocoding again. Now the tag is gone, at least, it does not re-appear again. Digikam: 2:2.1.1-0ubuntu1 mysql: 5.1.58-1ubuntu1 But I had not to update digikam, I've installed Kubuntu 11.10 in mid-october with the named versions. So there is a way to get rid of the tag manually by deleting it from digikam an re-applying geocoding. mysql> show create table Tags ; CREATE TABLE `Tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) DEFAULT NULL, `name` longtext CHARACTER SET utf8 NOT NULL, `icon` int(11) DEFAULT NULL, `iconkde` longtext CHARACTER SET utf8, `lft` int(11) NOT NULL, `rgt` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=363 DEFAULT CHARSET=latin1 -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #21 from qwexy <qwq121qwq gmx net> 2011-11-06 15:58:49 --- Hi Francesco, The second issue (post #9) still exists with dk 2.2.0.-109.5 Can we help debugging somehow? in reply to post #17: AUTO_INCREMENT=983 BTW I never had a _Digikam_root_tag_ as tag in the tag list. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #22 from Michael Holtermann <linux michael-holtermann de> 2011-11-06 16:04:10 --- In comment #20 I removed the dummy tag. Now, while running some face recognition, the tag re-appears, with the "Unknown" tag below it. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #23 from qwexy <qwq121qwq gmx net> 2011-11-06 16:32:52 --- in addition to comment #19 I guess, that somewhere in the sql statement (that puts together the tag hierarchy; I don't know how it works) is a condition (IF...), to stop the chaining after reaching "pid = 0". Maybe the IF THEN condition is supposed to stop before reaching "pid = 0". -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
Francesco Riosa <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |ASSIGNED Ever Confirmed|0 |1 --- Comment #24 from Francesco Riosa <francesco+kde pnpitalia it> 2011-11-06 17:07:34 --- I've discovered that the new tag is created as root of the "Persons", I've excluded a pair of things that could have created it, but not yet found the real bug -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] Component|Face Detection |Database -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #25 from qwexy <[hidden email]> --- Hello, In my database I did change in table "Tags" the entry "_Digikam_root_tag_"'s id 0 to -1. This solved my issue. Regards -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #26 from Leo <[hidden email]> --- Hi all, I'm back my system got updated, but the problem persist :( Ubuntu 12.04 LTS with digikam 4:2.7.0-precise~ppa3 mysql> SELECT * FROM Tags ORDER BY id LIMIT 10; +----+------+----------------------------+------+---------+-----+-----+ | id | pid | name | icon | iconkde | lft | rgt | +----+------+----------------------------+------+---------+-----+-----+ | 0 | -1 | _Digikam_root_tag_ | 0 | NULL | 1 | 60 | | 1 | 0 | _Digikam_Internal_Tags_ | 0 | NULL | 16 | 59 | | 2 | 1 | Need Resolving History | 0 | NULL | 57 | 58 | | 3 | 0 | Cham | 0 | NULL | 14 | 15 | | 4 | 1 | Need Tagging History Graph | 0 | NULL | 55 | 56 | | 5 | 1 | Original Version | 0 | NULL | 53 | 54 | | 6 | 1 | Current Version | 0 | NULL | 51 | 52 | | 7 | 1 | Intermediate Version | 0 | NULL | 49 | 50 | | 8 | 1 | Version Always Visible | 0 | NULL | 47 | 48 | | 9 | 1 | Color Label None | 0 | NULL | 45 | 46 | +----+------+----------------------------+------+---------+-----+-----+ 10 rows in set (0.00 sec) mysql> SELECT * FROM TagsTree ORDER BY id LIMIT 10; +----+------+ | id | pid | +----+------+ | 0 | -1 | | 1 | 0 | | 2 | 1 | | 3 | 0 | | 4 | 1 | | 5 | 1 | | 6 | 1 | | 7 | 1 | | 8 | 1 | | 9 | 1 | +----+------+ 10 rows in set (0.02 sec) -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #27 from schultzter <[hidden email]> --- This still seems to be happening in 2.7.0! mysql Ver 14.14 Distrib 5.5.24, On Slackware64-current mysql> select * from Tags where name='_Digikam_root_tag_'; +-----+------+--------------------+------+---------+-----+-----+ | id | pid | name | icon | iconkde | lft | rgt | +-----+------+--------------------+------+---------+-----+-----+ | 0 | -1 | _Digikam_root_tag_ | 0 | NULL | 1 | 290 | | 138 | 0 | _Digikam_root_tag_ | 0 | NULL | 2 | 15 | +-----+------+--------------------+------+---------+-----+-----+ 2 rows in set (0.00 sec) The worst part is I had tagged a bunch of photos with me before I realised my tag appear twice in the tag list. So I tried to drag 'n drop the photos from the duplicate tag to the original one and somewhere in that maneuver I lost both the original and duplicate assignment! So how can I re-scan those photos and get digikam to re-find my face? -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #28 from Michael Holtermann <[hidden email]> --- I can confirm the problem still exists in 2.7.0 (installed from http://ppa.launchpad.net/philip5/extra/ubuntu/ at Ubuntu 12.04). I've tried to re-read metadata from images - that creates a new _digikam_root_tag_. If a imported tag exists under another branch already, it's impossible to remove the messed stuff from the images itself. May I suggest to get rid of the internal tags at all? There are two alternative options that don't need any "magic" tags that must be hidden from most parts of the software: a) a real root tag that must be created by the user b) no root tags at all Option a) would make it necessary to mark that tag as "uninteresting", so it won't be written to the JPG or sidecar files. But this must be an *explicit* setting, maybe during setup wizard. And not some implicit c**p. Rule of thumb: If the user don't see it - don't store it :-) BTW: This would be a nice feature for any other tag as well. If set on a tag, that tag won't be exposed to the images. So the user may create a semantic tree, but skip some structural nodes. Option b) would make it necessary to allow nulls in column Tags.pid. But who says a tree must start with a single root? Please think about it. The internal tags causes lots of problems to the users, so this should be solved in the very near future. Currently, I'd consider this the most annoying bug in the whole software. Because of another issue, I have to rebuild my tag database. That's nearly impossible for 25.000 images with this issue still present. Regards, Michael -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
Hello,
I've got the same problem with digikam 2.8.0 from Philips PPA (xubuntu 12.04). I've tried from mysql 5.1.61 and mysql 5.5.28-0ubuntu0.12.04.2, always the same. Cleaning the tags and rewrite it to image, the tag _Digikam_root_tag is always there. + this "bugs" : so tagging is not usable. Query Output: > SELECT * FROM digikam.Tags ORDER BY id LIMIT 10 + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + | id | pid | name | icon | iconkde | lft | rgt | + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + | 0 | -1 | _Digikam_root_tag_ | 0 | | 1 | 542 | | 1 | 0 | _Digikam_root_tag_ | 0 | | 246 | 541 | | 2 | 1 | lieu | 0 | | 461 | 540 | | 3 | 2 | capblancnez | 0 | | 538 | 539 | | 4 | 0 | _Digikam_Internal_Tags_ | 0 | | 204 | 245 | | 5 | 4 | Color Label None | 0 | | 243 | 244 | | 6 | 4 | Color Label Red | 0 | | 241 | 242 | | 7 | 4 | Color Label Orange | 0 | | 239 | 240 | | 8 | 4 | Color Label Yellow | 0 | | 237 | 238 | | 9 | 4 | Color Label Green | 0 | | 235 | 236 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + 11 rows Query Output: > show create table digikam.TagsTree + --------- + ---------------- + ------------------------- + ------------------------- + | View | Create View | character_set_client | collation_connection | + --------- + ---------------- + ------------------------- + ------------------------- + | TagsTree | CREATE ALGORITHM=UNDEFINED DEFINER=`sospcdk`@`192.168.1.10` SQL SECURITY DEFINER VIEW `digikam`.`TagsTree` AS select `digikam`.`Tags`.`id` AS `id`,`digikam`.`Tags`.`pid` AS `pid` from `digikam`.`Tags` | utf8 | utf8_general_ci | + --------- + ---------------- + ------------------------- + ------------------------- + 1 rows Is there a solution ? Greatings, Eric |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
[hidden email] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] --- Comment #29 from [hidden email] --- Hello, I've got the same problem with digikam 2.8.0 from Philips PPA (xubuntu 12.04). I've tried from mysql 5.1.61 and mysql 5.5.28-0ubuntu0.12.04.2, always the same. Cleaning the tags and rewrite it to image, the tag _Digikam_root_tag is always there. + this "bugs" : so tagging is not usable. Query Output: > SELECT * FROM digikam.Tags ORDER BY id LIMIT 10 + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + | id | pid | name | icon | iconkde | lft | rgt | + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + | 0 | -1 | _Digikam_root_tag_ | 0 | | 1 | 542 | | 1 | 0 | _Digikam_root_tag_ | 0 | | 246 | 541 | | 2 | 1 | lieu | 0 | | 461 | 540 | | 3 | 2 | capblancnez | 0 | | 538 | 539 | | 4 | 0 | _Digikam_Internal_Tags_ | 0 | | 204 | 245 | | 5 | 4 | Color Label None | 0 | | 243 | 244 | | 6 | 4 | Color Label Red | 0 | | 241 | 242 | | 7 | 4 | Color Label Orange | 0 | | 239 | 240 | | 8 | 4 | Color Label Yellow | 0 | | 237 | 238 | | 9 | 4 | Color Label Green | 0 | | 235 | 236 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + 11 rows Query Output: > show create table digikam.TagsTree + --------- + ---------------- + ------------------------- + ------------------------- + | View | Create View | character_set_client | collation_connection | + --------- + ---------------- + ------------------------- + ------------------------- + | TagsTree | CREATE ALGORITHM=UNDEFINED DEFINER=`sospcdk`@`192.168.1.10` SQL SECURITY DEFINER VIEW `digikam`.`TagsTree` AS select `digikam`.`Tags`.`id` AS `id`,`digikam`.`Tags`.`pid` AS `pid` from `digikam`.`Tags` | utf8 | utf8_general_ci | + --------- + ---------------- + ------------------------- + ------------------------- + 1 rows Is there a solution ? Greatings, Eric -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
[Bug 283323] a new label _Digikam_root_tag_ is created every time
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|2.1.1 |2.8.0 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #30 from [hidden email] --- Hello, I have a mix of this bug and this one : https://bugs.kde.org/show_bug.cgi?id=230602 So tagging is not usable. As I try to reorder the tree view of the tags (Same tags are in a first tree with _Digikam_root_tag and to root with same pictures in multiple branches or not ?), this bug occurs : https://bugs.kde.org/show_bug.cgi?id=230602) Greatings, Eric -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #31 from [hidden email] --- TagsTree view : > SELECT * FROM digikam.TagsTree ORDER BY id LIMIT 10 + ------- + -------- + | id | pid | + ------- + -------- + | 0 | -1 | | 1 | 0 | | 2 | 1 | | 3 | 2 | | 4 | 0 | | 5 | 4 | | 6 | 4 | | 7 | 4 | | 8 | 4 | | 9 | 4 | + ------- + -------- + 10 rows -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #32 from [hidden email] --- > show create table digikam.Tags + ---------- + ----------------- + | Table | Create Table | + ---------- + ----------------- + | Tags | CREATE TABLE `Tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) DEFAULT NULL, `name` longtext CHARACTER SET utf8 NOT NULL, `icon` int(11) DEFAULT NULL, `iconkde` longtext CHARACTER SET utf8, `lft` int(11) NOT NULL, `rgt` int(11) N... | + ---------- + ----------------- + -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #33 from [hidden email] --- Diff between /usr/share/kde4/apps/database/dbconfig.xml in my digikam database conf file and the dbconfig.xml given by Francesco : 1 / /usr/share/kde4/apps/database/dbconfig.xml 2 / dbconfig.xml given by Francesco line 908 : 1 / CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50), index_name_vc varchar(50), field_list_vc varchar(1024)) 2 / CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50), index_name_vc varchar(50), field_list_vc varchar(1024), is_unique int) line 924 : 1 / CONVERT( ' ADD INDEX ' USING latin1), 2 / CONVERT( IF(is_unique = 0, ' ADD INDEX ', ' ADD UNIQUE INDEX ') USING latin1), line 936 to 950 : 1/ <statement mode="plain">CALL create_index_if_not_exists('Images','dir_index','album');</statement> <statement mode="plain">CALL create_index_if_not_exists('Images','hash_index','uniqueHash');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTags','tag_index','tagid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTags','tag_id_index','imageid');</statement> <statement mode="plain">CALL create_index_if_not_exists('Images','image_name_index','name(996)');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageInformation','creationdate_index','creationDate');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageComments','comments_imageid_index','imageid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageCopyright','copyright_imageid_index','imageid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageHistory','uuid_index','uuid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageRelations','subject_relations_index','subject');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageRelations','object_relations_index','object');</statement> <statement mode="plain">CALL create_index_if_not_exists('TagProperties','tagproperties_index','tagid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTagProperties','imagetagproperties_index','imageid, tagid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTagProperties','imagetagproperties_imageid_index','imageid');</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTagProperties','imagetagproperties_tagid_index','tagid');</statement> 2 / <statement mode="plain">CALL create_index_if_not_exists('Images','dir_index','album', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('Images','hash_index','uniqueHash', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTags','tag_index','tagid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTags','tag_id_index','imageid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('Images','image_name_index','name(996)', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageInformation','creationdate_index','creationDate', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageComments','comments_imageid_index','imageid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageCopyright','copyright_imageid_index','imageid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageHistory','uuid_index','uuid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageRelations','subject_relations_index','subject', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageRelations','object_relations_index','object', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('TagProperties','tagproperties_index','tagid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTagProperties','imagetagproperties_index','imageid, tagid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTagProperties','imagetagproperties_imageid_index','imageid', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('ImageTagProperties','imagetagproperties_tagid_index','tagid', 0);</statement> line 989 + one more line for 2 (not in 1): 1 / <statement mode="plain">SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';</statement> 2 / <statement mode="plain">SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';</statement> <statement mode="plain">UPDATE tags SET pid = 0 WHERE pid < 0 AND id > 0;</statement> line 995 : 1 / <statement mode="plain">SET SQL_MODE=@OLD_SQL_MODE;</statement> 2 / not in Francesco File line 1236 : 1 /CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50), index_name_vc varchar(50), field_list_vc varchar(1024)) 2 / CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50), index_name_vc varchar(50), field_list_vc varchar(1024), is_unique int) line 1252 : 1 / CONVERT( ' ADD INDEX ' USING latin1), 2 / CONVERT( IF(is_unique = 0, ' ADD INDEX ', ' ADD UNIQUE INDEX ') USING latin1), line 1264 to 1266 : 1 / <statement mode="plain">CALL create_index_if_not_exists('UniqueHashes','id_uniqueHashes','thumbId');</statement> <statement mode="plain">CALL create_index_if_not_exists('FilePaths','id_filePaths','thumbId');</statement> <statement mode="plain">CALL create_index_if_not_exists('CustomIdentifiers','id_customIdentifiers','thumbId');</statement> 2 / <statement mode="plain">CALL create_index_if_not_exists('UniqueHashes','id_uniqueHashes','thumbId', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('FilePaths','id_filePaths','thumbId', 0);</statement> <statement mode="plain">CALL create_index_if_not_exists('CustomIdentifiers','id_customIdentifiers','thumbId', 0);</statement> line 1493 : 1 / not in file 2 / <statement mode="plain">CALL create_index_if_not_exists('Tags','name_pid_index','name(128), pid', 1);</statement> Greatings, Eric -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #34 from [hidden email] --- No diff for QSQLITE, the only diffs are on QMYSQL. -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #35 from [hidden email] --- Hello, Francesco give this in bugs [Bug 299173] http://mail.kde.org/pipermail/digikam-devel/2012-May/060073.html with this link : http://www.sitepoint.com/hierarchical-data-database-2/ This is my table Tags order by left values : Query Output: > SELECT * FROM digikam.Tags ORDER BY lft + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + | id | pid | name | icon | iconkde | lft | rgt | + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + | 0 | -1 | _Digikam_root_tag_ | 0 | | 1 | 542 | | 270 | 0 | Personnes | 0 | | 2 | 3 | | 251 | 0 | ver | 0 | | 4 | 7 | | 252 | 251 | nereis | 0 | | 5 | 6 | | 231 | 0 | poisson2 | 0 | | 8 | 15 | | 260 | 231 | brochet | 0 | | 9 | 10 | | 242 | 231 | merlan | 0 | | 11 | 12 | | 232 | 231 | grande castagnole | 0 | | 13 | 14 | | 206 | 0 | ver coréen | 0 | | 16 | 17 | | 124 | 0 | plomb grappin | 0 | | 18 | 19 | | 112 | 0 | vegetal | 0 | | 20 | 27 | | 191 | 112 | fleur | 0 | | 21 | 24 | | 192 | 191 | perceneige | 0 | | 22 | 23 | | 113 | 112 | algue | 0 | | 25 | 26 | | 99 | 0 | trombine2 | 0 | | 28 | 35 | | 238 | 99 | gribouille | 0 | | 29 | 30 | | 141 | 99 | xavier | 0 | | 31 | 32 | | 100 | 99 | eric | 0 | | 33 | 34 | | 96 | 0 | lieu2 | 0 | | 36 | 51 | | 263 | 96 | vendee | 0 | | 37 | 38 | | 226 | 96 | mormal | 0 | | 39 | 40 | | 182 | 96 | cessenonorb | 0 | | 41 | 42 | | 154 | 96 | lestouches | 0 | | 43 | 44 | | 140 | 96 | saumonard | 0 | | 45 | 46 | | 122 | 96 | bretignolles la sauzaie | 0 | | 47 | 48 | | 97 | 96 | Chevret | 0 | | 49 | 50 | | 55 | 0 | lieu | 0 | | 52 | 73 | | 250 | 55 | chassiron | 0 | | 53 | 54 | | 228 | 55 | tournehem | 0 | | 55 | 56 | | 218 | 55 | dyck | 0 | | 57 | 58 | | 209 | 55 | riumar | 0 | | 59 | 60 | | 205 | 55 | platja de la marquesa | 0 | | 61 | 62 | | 200 | 55 | creche | 0 | | 63 | 64 | | 198 | 55 | cranpoulet | 0 | | 65 | 66 | | 197 | 55 | cranauxoeufs | 0 | | 67 | 68 | | 142 | 55 | fort boyard | 0 | | 69 | 70 | | 56 | 55 | salsperwick | 0 | | 71 | 72 | | 49 | 0 | poisson | 0 | | 74 | 101 | | 258 | 49 | brochet | 0 | | 75 | 76 | | 247 | 49 | marbré | 0 | | 77 | 78 | | 240 | 49 | merlan | 0 | | 79 | 80 | | 236 | 49 | flet | 0 | | 81 | 82 | | 229 | 49 | grande castagnole | 0 | | 83 | 84 | | 216 | 49 | girelle | 0 | | 85 | 86 | | 214 | 49 | sar | 0 | | 87 | 88 | | 211 | 49 | mulet | 0 | | 89 | 90 | | 203 | 49 | sardine | 0 | | 91 | 92 | | 137 | 49 | tacaud | 0 | | 93 | 94 | | 118 | 49 | maquereau | 0 | | 95 | 96 | | 116 | 49 | lancon | 0 | | 97 | 98 | | 50 | 49 | anguille | 0 | | 99 | 100 | | 45 | 0 | animal | 0 | | 102 | 181 | | 46 | 45 | vertebre | 0 | | 103 | 180 | | 150 | 46 | reptile | 0 | | 104 | 109 | | 158 | 150 | lezard | 0 | | 105 | 106 | | 151 | 150 | grenouille | 0 | | 107 | 108 | | 61 | 46 | mammifere | 0 | | 110 | 119 | | 234 | 61 | herisson | 0 | | 111 | 112 | | 163 | 61 | ane | 0 | | 113 | 114 | | 161 | 61 | cheval | 0 | | 115 | 116 | | 62 | 61 | mouton | 0 | | 117 | 118 | | 58 | 46 | oiseau | 0 | | 120 | 135 | | 169 | 58 | aigrette | 0 | | 121 | 122 | | 167 | 58 | vanneau | 0 | | 123 | 124 | | 160 | 58 | heron | 0 | | 125 | 126 | | 156 | 58 | hirondelle | 0 | | 127 | 128 | | 153 | 58 | cigogne | 0 | | 129 | 130 | | 60 | 58 | canard | 0 | | 131 | 132 | | 59 | 58 | cygne | 0 | | 133 | 134 | | 47 | 46 | poisson | 0 | | 136 | 179 | | 259 | 47 | brochet | 0 | | 137 | 138 | | 248 | 47 | marbré | 0 | | 139 | 140 | | 241 | 47 | merlan | 0 | | 141 | 142 | | 237 | 47 | flet | 0 | | 143 | 144 | | 230 | 47 | grande castagnole | 0 | | 145 | 146 | | 217 | 47 | girelle | 0 | | 147 | 148 | | 215 | 47 | sar | 0 | | 149 | 150 | | 212 | 47 | mulet | 0 | | 151 | 152 | | 204 | 47 | sardine | 0 | | 153 | 154 | | 173 | 47 | maigre | 0 | | 155 | 156 | | 139 | 47 | tacaud | 0 | | 157 | 158 | | 128 | 47 | cabillaud | 0 | | 159 | 160 | | 123 | 47 | turbot | 0 | | 161 | 162 | | 119 | 47 | maquereau | 0 | | 163 | 164 | | 117 | 47 | lancon | 0 | | 165 | 166 | | 107 | 47 | petite roussette | 0 | | 167 | 168 | | 105 | 47 | vieille | 0 | | 169 | 170 | | 98 | 47 | raie | 0 | | 171 | 172 | | 90 | 47 | sole | 0 | | 173 | 174 | | 51 | 47 | anguille | 0 | | 175 | 176 | | 48 | 47 | bar | 0 | | 177 | 178 | | 38 | 0 | materiel | 0 | | 182 | 191 | | 143 | 38 | tente | 0 | | 183 | 184 | | 127 | 38 | plomb grappin | 0 | | 185 | 186 | | 39 | 38 | vehicule | 0 | | 187 | 190 | | 40 | 39 | volvo-240 | 0 | | 188 | 189 | | 25 | 0 | trombine | 0 | | 192 | 199 | | 57 | 25 | gonzague | 0 | | 193 | 194 | | 27 | 25 | gribouille | 0 | | 195 | 196 | | 26 | 25 | eric | 0 | | 197 | 198 | | 24 | 0 | gribouille | 0 | | 200 | 201 | | 23 | 0 | eric | 0 | | 202 | 203 | | 4 | 0 | _Digikam_Internal_Tags_ | 0 | | 204 | 245 | | 269 | 4 | Version Always Visible | 0 | | 205 | 206 | | 268 | 4 | Intermediate Version | 0 | | 207 | 208 | | 267 | 4 | Current Version | 0 | | 209 | 210 | | 266 | 4 | Original Version | 0 | | 211 | 212 | | 265 | 4 | Need Tagging History Graph | 0 | | 213 | 214 | | 194 | 4 | Need Resolving History | 0 | | 215 | 216 | | 18 | 4 | Pick Label Accepted | 0 | | 217 | 218 | | 17 | 4 | Pick Label Pending | 0 | | 219 | 220 | | 16 | 4 | Pick Label Rejected | 0 | | 221 | 222 | | 15 | 4 | Pick Label None | 0 | | 223 | 224 | | 14 | 4 | Color Label White | 0 | | 225 | 226 | | 13 | 4 | Color Label Black | 0 | | 227 | 228 | | 12 | 4 | Color Label Gray | 0 | | 229 | 230 | | 11 | 4 | Color Label Magenta | 0 | | 231 | 232 | | 10 | 4 | Color Label Blue | 0 | | 233 | 234 | | 9 | 4 | Color Label Green | 0 | | 235 | 236 | | 8 | 4 | Color Label Yellow | 0 | | 237 | 238 | | 7 | 4 | Color Label Orange | 0 | | 239 | 240 | | 6 | 4 | Color Label Red | 0 | | 241 | 242 | | 5 | 4 | Color Label None | 0 | | 243 | 244 | | 1 | 0 | _Digikam_root_tag_ | 0 | | 246 | 541 | | 165 | 1 | vegetal | 0 | | 247 | 254 | | 179 | 165 | vigne | 0 | | 248 | 249 | | 166 | 165 | fleur | 0 | | 250 | 253 | | 180 | 166 | coquelicot | 0 | | 251 | 252 | | 148 | 1 | reptile | 0 | | 255 | 260 | | 157 | 148 | lezard | 0 | | 256 | 257 | | 149 | 148 | grenouille | 0 | | 258 | 259 | | 110 | 1 | vegetaux | 0 | | 261 | 268 | | 189 | 110 | fleur | 0 | | 262 | 265 | | 190 | 189 | perceneige | 0 | | 263 | 264 | | 111 | 110 | algue | 0 | | 266 | 267 | | 108 | 1 | volvo-240 | 0 | | 269 | 270 | | 92 | 1 | arenicole | 0 | | 271 | 272 | | 43 | 1 | poisson | 0 | | 273 | 290 | | 172 | 43 | maigre | 0 | | 274 | 275 | | 126 | 43 | cabillaud | 0 | | 276 | 277 | | 121 | 43 | turbot | 0 | | 278 | 279 | | 106 | 43 | petite roussette | 0 | | 280 | 281 | | 104 | 43 | vieille | 0 | | 282 | 283 | | 95 | 43 | raie | 0 | | 284 | 285 | | 89 | 43 | sole | 0 | | 286 | 287 | | 44 | 43 | bar | 0 | | 288 | 289 | | 41 | 1 | trombine | 0 | | 291 | 342 | | 264 | 41 | matthis | 0 | | 292 | 293 | | 246 | 41 | hassan | 0 | | 294 | 295 | | 245 | 41 | mathias | 0 | | 296 | 297 | | 244 | 41 | phil | 0 | | 298 | 299 | | 219 | 41 | julien | 0 | | 300 | 301 | | 210 | 41 | florian | 0 | | 302 | 303 | | 199 | 41 | jenny | 0 | | 304 | 305 | | 184 | 41 | oxanne | 0 | | 306 | 307 | | 170 | 41 | crapule | 0 | | 308 | 309 | | 155 | 41 | vincent | 0 | | 310 | 311 | | 138 | 41 | xavier | 0 | | 312 | 313 | | 135 | 41 | magalie | 0 | | 314 | 315 | | 133 | 41 | francoise | 0 | | 316 | 317 | | 132 | 41 | andre | 0 | | 318 | 319 | | 80 | 41 | whitney | 0 | | 320 | 321 | | 79 | 41 | kenzo | 0 | | 322 | 323 | | 75 | 41 | viviane | 0 | | 324 | 325 | | 74 | 41 | joel | 0 | | 326 | 327 | | 73 | 41 | simba | 0 | | 328 | 329 | | 71 | 41 | allan | 0 | | 330 | 331 | | 69 | 41 | anais | 0 | | 332 | 333 | | 67 | 41 | chloe | 0 | | 334 | 335 | | 54 | 41 | christelle | 0 | | 336 | 337 | | 52 | 41 | charlotte | 0 | | 338 | 339 | | 42 | 41 | marco | 0 | | 340 | 341 | | 33 | 1 | _Digikam_root_tag_ | 0 | | 343 | 368 | | 34 | 33 | animal | 0 | | 344 | 367 | | 63 | 34 | vertebre | 0 | | 345 | 356 | | 64 | 63 | mammifere | 0 | | 346 | 355 | | 235 | 64 | herisson | 0 | | 347 | 348 | | 164 | 64 | ane | 0 | | 349 | 350 | | 162 | 64 | cheval | 0 | | 351 | 352 | | 65 | 64 | mouton | 0 | | 353 | 354 | | 35 | 34 | invertebre | 0 | | 357 | 366 | | 36 | 35 | crustace | 0 | | 358 | 365 | | 103 | 36 | araigneedemer | 0 | | 359 | 360 | | 102 | 36 | araignéedemer | 0 | | 361 | 362 | | 37 | 36 | callianasse | 0 | | 363 | 364 | | 31 | 1 | crustace | 0 | | 369 | 374 | | 101 | 31 | araignéedemer | 0 | | 370 | 371 | | 32 | 31 | callianasse | 0 | | 372 | 373 | | 19 | 1 | animal | 0 | | 375 | 460 | | 84 | 19 | invertebre | 0 | | 376 | 421 | | 187 | 84 | crustace | 0 | | 377 | 380 | | 188 | 187 | crabe | 0 | | 378 | 379 | | 171 | 84 | insecte | 0 | | 381 | 384 | | 193 | 171 | coccinelle | 0 | | 382 | 383 | | 114 | 84 | cnidaire | 0 | | 385 | 390 | | 145 | 114 | etoile de mer | 0 | | 386 | 387 | | 115 | 114 | anemone | 0 | | 388 | 389 | | 93 | 84 | mollusque | 0 | | 391 | 412 | | 257 | 93 | buccin | 0 | | 392 | 393 | | 256 | 93 | littorine | 0 | | 394 | 395 | | 255 | 93 | patelle | 0 | | 396 | 397 | | 254 | 93 | huitre | 0 | | 398 | 399 | | 249 | 93 | crepidule | 0 | | 400 | 401 | | 213 | 93 | telline | 0 | | 402 | 403 | | 208 | 93 | praire | 0 | | 404 | 405 | | 196 | 93 | couteau | 0 | | 406 | 407 | | 195 | 93 | coque | 0 | | 408 | 409 | | 94 | 93 | moule | 0 | | 410 | 411 | | 85 | 84 | ver | 0 | | 413 | 420 | | 253 | 85 | nereis | 0 | | 414 | 415 | | 207 | 85 | ver coréen | 0 | | 416 | 417 | | 86 | 85 | arenicole | 0 | | 418 | 419 | | 20 | 19 | vertebre | 0 | | 422 | 459 | | 77 | 20 | poisson | 0 | | 423 | 430 | | 239 | 77 | congre | 0 | | 424 | 425 | | 109 | 77 | emissole | 0 | | 426 | 427 | | 78 | 77 | dorade | 0 | | 428 | 429 | | 28 | 20 | oiseau | 0 | | 431 | 442 | | 261 | 28 | paon | 0 | | 432 | 433 | | 225 | 28 | sitelle | 0 | | 434 | 435 | | 168 | 28 | rapace | 0 | | 436 | 437 | | 68 | 28 | faisan | 0 | | 438 | 439 | | 29 | 28 | goeland | 0 | | 440 | 441 | | 21 | 20 | mammifere | 0 | | 443 | 458 | | 262 | 21 | ragondin | 0 | | 444 | 445 | | 227 | 21 | cerf-biche | 0 | | 446 | 447 | | 202 | 21 | chevreuil | 0 | | 448 | 449 | | 181 | 21 | chat | 0 | | 450 | 451 | | 159 | 21 | vache | 0 | | 452 | 453 | | 83 | 21 | sanglier | 0 | | 454 | 455 | | 22 | 21 | mustelide | 0 | | 456 | 457 | | 2 | 1 | lieu | 0 | | 461 | 540 | | 243 | 2 | dakhla | 0 | | 462 | 463 | | 233 | 2 | Jetee du dyck | 0 | | 464 | 465 | | 224 | 2 | Minerve | 0 | | 466 | 467 | | 223 | 2 | Sigean | 0 | | 468 | 469 | | 222 | 2 | Santiago | 0 | | 470 | 471 | | 221 | 2 | San Francisco | 0 | | 472 | 473 | | 220 | 2 | Torreira | 0 | | 474 | 475 | | 201 | 2 | crecy | 0 | | 476 | 477 | | 186 | 2 | clipon | 0 | | 478 | 479 | | 185 | 2 | berlou | 0 | | 480 | 481 | | 183 | 2 | sete | 0 | | 482 | 483 | | 178 | 2 | cahors | 0 | | 484 | 485 | | 177 | 2 | vendee | 0 | | 486 | 487 | | 176 | 2 | pointe de la coubre | 0 | | 488 | 489 | | 175 | 2 | vert bois | 0 | | 490 | 491 | | 174 | 2 | pointedegatseau | 0 | | 492 | 493 | | 152 | 2 | embellie | 0 | | 494 | 495 | | 147 | 2 | lestouches | 0 | | 496 | 497 | | 146 | 2 | pointeespagnole | 0 | | 498 | 499 | | 144 | 2 | ronce les bains | 0 | | 500 | 501 | | 136 | 2 | saumonard | 0 | | 502 | 503 | | 134 | 2 | cessenonorb | 0 | | 504 | 505 | | 131 | 2 | dauphinbleu | 0 | | 506 | 507 | | 130 | 2 | carnot | 0 | | 508 | 509 | | 129 | 2 | capgrisnez | 0 | | 510 | 511 | | 125 | 2 | ruytingen | 0 | | 512 | 513 | | 120 | 2 | bretignolles la sauzaie | 0 | | 514 | 515 | | 91 | 2 | Chevret | 0 | | 516 | 517 | | 88 | 2 | rondins gravelines | 0 | | 518 | 519 | | 87 | 2 | dunkerque | 0 | | 520 | 521 | | 82 | 2 | mormal | 0 | | 522 | 523 | | 81 | 2 | annoeullin | 0 | | 524 | 525 | | 76 | 2 | Vendres | 0 | | 526 | 527 | | 72 | 2 | cazedarnes | 0 | | 528 | 529 | | 70 | 2 | gorgedheric | 0 | | 530 | 531 | | 66 | 55 | amsterdam | 0 | | 532 | 533 | | 53 | 2 | oye plage | 0 | | 534 | 535 | | 30 | 2 | diguebreak | 0 | | 536 | 537 | | 3 | 2 | capblancnez | 0 | | 538 | 539 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | + ------- + -------- + --------- + --------- + ------------ + -------- + -------- + 272 rows There must not be two _Digikam_root_tag. The second _Digikam_root_tag has a left value of 246 and a right value of 541. This mean I think that it has been created after the first one with incorrect left and right values. This occur every time I created a new Digikam database in all the case : - One database for Digikam data and thumbs data. - two database, one for digikam data and one for thumbs data. - new fresh install of mysql server and linux with different versions. - Database or Databases are always on a remote server in my local network Why ? I continue to search . Greatings, Eric -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
|
|
In reply to this post by Leo-2
https://bugs.kde.org/show_bug.cgi?id=283323
--- Comment #36 from [hidden email] --- Hello, This is what is read for a picture with two tags "_Digikam_root_tag" and some other tags with no "_Digikam_root_tag", using /Album/reread metadata : --- digikam(14382)/KEXIV2 KExiv2Iface::KExiv2::getXmpTagStringSeq: XMP String Seq ( Xmp.digiKam.TagsList ): ("_Digikam_root_tag_/lieu/lestouches", "lieu/lestouches", "animal/vertebre/mammifere/ane", "lestouches", "animal", "animal/vertebre", "animal/vertebre/mammifere", "lieu2/lestouches", "_Digikam_root_tag_/_Digikam_root_tag_/animal", "_Digikam_root_tag_/_Digikam_root_tag_/animal/vertebre", "_Digikam_root_tag_/_Digikam_root_tag_/animal/vertebre/mammifere", "_Digikam_root_tag_/_Digikam_root_tag_/lieu/lestouches", "_Digikam_root_tag_/lieu2/lestouches", "_Digikam_root_tag_/_Digikam_root_tag_/animal/vertebre/mammifere/ane") --- This is the list of Digikam Component : (/help/view component) -- digiKam version 2.8.0 Codec PGF parallélisé: Non Composant graphique Marble: 0.13.4 (stable release) Dématriçage parallélisé: Oui Exiv2 peut écrire dans un fichier JP2: Oui Exiv2 peut écrire dans un fichier JPEG: Oui Exiv2 peut écrire dans un fichier PGF: Oui Exiv2 peut écrire dans un fichier PNG: Oui Exiv2 peut écrire dans un fichier TIFF: Oui Exiv2 prend en charge les métadonnées XMP: Oui LibCImg: 130 LibClapack: bibliothèque interne LibExiv2: 0.23 LibJPEG: 80 LibJasper: 1.900.1 LibKDE: 4.8.5 (4.8.5) LibKExiv2: 2.3.0 LibKGeoMap: 2.0.0 LibKdcraw: 2.1.0 LibLCMS: 2020 LibLensFun: bibliothèque partagée externe LibLqr: bibliothèque interne LibPGF: 6.12.27 - bibliothèque interne LibPNG: 1.2.46 LibQt: 4.8.1 LibRaw: 0.14.7 LibTIFF: LIBTIFF, Version 3.9.5 Copyright (c) 1988-1996 Sam Leffler Copyright (c) 1991-1996 Silicon Graphics, Inc. LibGphoto2: 2.4.14 LibKface: 2.0.0 LibKipi: 1.6.0 LibOpenCV: 2.4.2 Libface: 0.2 Moteur de base de données: QMYSQL Serveur interne de base de données: Non -- Greatings, Eric -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
«
Return to digikam-devel
|
1 view|%1 views
| Free forum by Nabble | Edit this page |