[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 Simon changed: What|Removed |Added CC||bernd.mul...@yahoo.de --- Comment

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Latest Commit||https://quickgit.kde.org/?p

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #102 from swatilodh...@gmail.com --- Maik Could this file be closed now, with the last commit? Thanks! -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #101 from caulier.gil...@gmail.com --- Git commit eb6318a45efe1e08f35da450633f3bcb1027fd6a by Swati Lodha. Committed on 16/07/2016 at 09:51. Pushed by swatil into branch 'master'. Remove _digikam_root_tag_ from tag tree-view M +3-1

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #100 from e.longuem...@laposte.net --- Hello, Le samedi 16 juillet 2016 à 09:28 +, via KDE Bugzilla a écrit : > https://bugs.kde.org/show_bug.cgi?id=283323 > > --- Comment #99 from caulier.gil...@gmail.com --- > "In an old DB the tag

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #99 from caulier.gil...@gmail.com --- "In an old DB the tag _Digikam_root_tag_ still exists" It's clear. If this tag still appear in tree-view, certainly it's assigned to item as well (as a normal tag). As Maik can reproduce the problem

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #98 from swatilodh...@gmail.com --- (In reply to caulier.gilles from comment #94) > I confirm : new patch is really better as not _root_ tag appear in tree-view > after face scan. Good job Swati... Thank you! (In reply to caulier.gilles

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #97 from caulier.gil...@gmail.com --- The fuzzy FingerPrints process is done. No _root_ tag here... I restarted digiKam just to be sure, no _root_ tag here... Gilles -- You are receiving this mail because: You are watching all bug

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #96 from caulier.gil...@gmail.com --- Maik, metadathub.cpp::line 553 and imagescanner.cpp::line 840 has all rules to prevent _root_ tag to be imported to DB. So for your problem "In an old DB the tag _Digikam_root_tag_ still exists", I

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #95 from caulier.gil...@gmail.com --- Now i will scan items to generate fuzzy fingerprints to find duplicates. Gilles -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #94 from caulier.gil...@gmail.com --- I confirm : new patch is really better as not _root_ tag appear in tree-view after face scan. Good job Swati... Gilles -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #92 from caulier.gil...@gmail.com --- The first scan is complete with the new patch version. It took 20 mn ! The _root_ tag is not restored. So it's not present in my images metadata or Metadata Hub do the job properly. This point still to

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #91 from caulier.gil...@gmail.com --- Another problem : If images in collection have been previously managed with option to save tags in image metadata, the _root_ tags will be restored in a fresh database. I'm sure that my collection is

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #90 from caulier.gil...@gmail.com --- Maik, Currently i test with new version patch. Do you seen that splashscreen is frozen on screen while long first scanning without any progress indicator and without any text message on the top ?

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #89 from swatilodh...@gmail.com --- (In reply to Maik Qualmann from comment #84) > In an old DB the tag _Digikam_root_tag_ still exists. When a new DB is > created, the tag _Digikam_root_tag_ no longer appear. Do we need QRegExp? Is > enough

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #88 from Maik Qualmann --- Gilles, No slow DB access with a new internal DB on the first scan here. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #87 from Maik Qualmann --- Gilles, I have tested it with patch #100118. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #86 from caulier.gil...@gmail.com --- Maik, Do you seen any slow down performance with a fresh DB created, typically at first scan ? Look in the console if registration to DB take time latency (1/2 seconds here). Previously, i never see

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #85 from caulier.gil...@gmail.com --- Maik, i cannot confirm your comment #84. I run digiKam with patch version 100045 with a fresh database (i delete /var/lib/mysql and restart mysqld to be sure. The DB created is clean. I create myself

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #83 from swatilodh...@gmail.com --- Created attachment 100118 --> https://bugs.kde.org/attachment.cgi?id=100118=edit Updated patch Still the same results? -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #100045|0 |1 is obsolete|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #82 from caulier.gil...@gmail.com --- root tag in Tags view from left and right sidebars. https://www.flickr.com/photos/digikam/27714438463/in/dateposted-public/ Gilles Caulier -- You are receiving this mail because: You are watching all

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #81 from caulier.gil...@gmail.com --- digiKam 5.1.0 screenhot with root tag in face tree-view: https://www.flickr.com/photos/digikam/28219572102/in/dateposted-public/ Gilles Caulier -- You are receiving this mail because: You are

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #80 from swatilodh...@gmail.com --- (In reply to caulier.gilles from comment #79) > Tested here. Context : skip... > * _Digikam_root_tag_ still in DB schema. It's the expected behavior ? Yes. The tag would be present in the schema, but not

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #79 from caulier.gil...@gmail.com --- Tested here. Context : - Mysql DB from host Linux computer - DK client running on a Linux under a VM. - VM is connected to host DB through the network. - DB on host is build from scratch. *

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 caulier.gil...@gmail.com changed: What|Removed |Added Version|2.8.0 |5.0.0 -- You are receiving this

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time [patch]

https://bugs.kde.org/show_bug.cgi?id=283323 caulier.gil...@gmail.com changed: What|Removed |Added Summary|MYSQL : a new label |MYSQL : a new label

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #78 from swatilodh...@gmail.com --- Created attachment 100045 --> https://bugs.kde.org/attachment.cgi?id=100045=edit Please test this with latest git/master and see if this fix this issue. -- You are receiving this mail because: You are

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #100044|moveTag.patch |.patch filename|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #77 from swatilodh...@gmail.com --- Created attachment 100044 --> https://bugs.kde.org/attachment.cgi?id=100044=edit Please test this with latest git/master and see if this fix this issue. -- You are receiving this mail because: You are

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #99954|0 |1 is obsolete|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #76 from Richard Mortimer --- Looks good to me. -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #75 from swatilodh...@gmail.com --- Created attachment 99954 --> https://bugs.kde.org/attachment.cgi?id=99954=edit Combined patch 1) Avoid duplicates in Tags table 2) Removes _digikam_root_tag_ from UI -- You are receiving this mail

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #99945|0 |1 is obsolete|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #99951|0 |1 is obsolete|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #74 from swatilodh...@gmail.com --- Created attachment 99951 --> https://bugs.kde.org/attachment.cgi?id=99951=edit Removes _Digikam_root_tag_ from GUI -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #99945|0 |1 is patch|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added Attachment #99945|0 |1 is obsolete|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #73 from swatilodh...@gmail.com --- Created attachment 99945 --> https://bugs.kde.org/attachment.cgi?id=99945=edit To remove duplicates from Tags table -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #72 from Richard Mortimer --- I've tended to keep LONGTEXT and use a length on the index. That way a long tag name will not totally break things - but will likely cause unexpected behaviour. Try CREATE TABLE IF

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #71 from swatilodh...@gmail.com --- (In reply to Richard Mortimer from comment #69) > First step to resolve this has to be to add UNIQUE(name, pid) to the MySQL > version of the Tags table (around line 1056 in dbconfig.xml.cmake). > > That

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #70 from e.longuem...@laposte.net --- Hello, I still use digikam 3.5 with mysql. As I don't write tags to pictures, only mysql support, I have had never again a double _digikam_root_tag. Exception : importing some images that aren't mine

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 Richard Mortimer changed: What|Removed |Added CC|

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 --- Comment #68 from caulier.gil...@gmail.com --- Yes, it is. Look in Mysql DB schema :

[digikam] [Bug 283323] MYSQL : a new label "_Digikam_root_tag_" is created every time

https://bugs.kde.org/show_bug.cgi?id=283323 swatilodh...@gmail.com changed: What|Removed |Added CC||swatilodh...@gmail.com --- Comment #67