[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #20 from José Oliver-Didier --- Fixed: Able to move tags, changes persist after closing and re-opening digiKam. Tested on 7.2.0-rc (46fd680f) 2/16/2021 build with MySQL 8.0.23 on Windows 10. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 Maik Qualmann changed: What|Removed |Added Resolution|--- |FIXED Status|REOPENED|RESOLVED --- Comment #19 from Maik Qualmann --- Trigger now works fine on MySQL-8, tested in a Windows 10 VM. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #18 from Maik Qualmann --- The problem is MySQL. With DELETE it cannot read from the same table in the WHERE clause. Please test the change, if it is available with MySQL, whether the moving of tags works there as well. A new DB must be created. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #17 from Maik Qualmann --- Git commit 1d23c88ca41660d548e2bdf2136c9d4bfda5cbd3 by Maik Qualmann. Committed on 16/02/2021 at 18:26. Pushed by mqualmann into branch 'master'. wrap in SELECT clause for MySQL M +10 -6core/data/database/dbconfig.xml.cmake.in https://invent.kde.org/graphics/digikam/commit/1d23c88ca41660d548e2bdf2136c9d4bfda5cbd3 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #16 from José Oliver-Didier --- I installed MariaDB and was able to move the tags into the People tag. Closing and re-opening Digikam, and the changes persists, confirming the functionality worked as expected. So it may seem to be an issue with MySQL in Windows. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #15 from José Oliver-Didier --- Yes, I can confirm that the issue also affects "regular" tags which cannot be moved either. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #14 from José Oliver-Didier --- MySQL 8.0.23 I first came accross this issue when I created the MySQL db, I deleted it and recreated the database to try to narrow this issue down and it still occurs. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #13 from Maik Qualmann --- According to the error message, it is MySQL. That will be difficult because we are only testing with MariaDB and MySQL is no longer available as a package. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #12 from Maik Qualmann --- I already suspected that something is wrong with your database, namely with the new triggers for the TagsTree. What are you using, MySQL or MariaDB? Which MySQL Server Version? It looks like the TagsTree doesn't exist, did you update or re-create the database? The fact is, with this malfunction, the tags management will be not work. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #11 from José Oliver-Didier --- Created attachment 135719 --> https://bugs.kde.org/attachment.cgi?id=135719&action=edit DebugView logs Attaching DebugView Logs - digilog_move_tag.txt - Opening Digikam, moving "Albert Einstein" tag to people tag in Tag View. - digilog_move_people_tag.txt - Opening Digikam, moving "Albert Einstein" tag to people tag in People View. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #10 from Maik Qualmann --- No, the last patch tries to fix the problem with the internal MySQL server, which is completely managed by digiKam, which results in destroyed database tables. The problem does not affect an external MySQL server. I need the DebugView log from comment 6. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #9 from José Oliver-Didier --- I am using Remote Server (MySQL). Based on your recent comment seems you managed to stomp out the bug. Go Maik! Looking forward to the next available rc build with the fix to test it out. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #8 from Maik Qualmann --- Git commit 8255cb9325deec0a9c95c3621266e536981a2e68 by Maik Qualmann. Committed on 15/02/2021 at 22:04. Pushed by mqualmann into branch 'master'. use "mysqladmin shutdown" to stop MySQL server The call via terminate() does not work for Windows console programs. With kill() at end, so we have data loss in the database under Windows. M +21 -0core/libs/database/server/databaseserver.cpp https://invent.kde.org/graphics/digikam/commit/8255cb9325deec0a9c95c3621266e536981a2e68 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #7 from Maik Qualmann --- Do you use the internal MySQL server? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #6 from Maik Qualmann --- No, the problem definitely does not occur here, also MySQL tested. Install Microsoft's DebugView, activate the debug environment variable and post the log if you move the tag. DebugView is described here: https://www.digikam.org/contribute/ Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 José Oliver-Didier changed: What|Removed |Added Resolution|INTENTIONAL |--- Ever confirmed|0 |1 Status|RESOLVED|REOPENED -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #5 from José Oliver-Didier --- Created attachment 135703 --> https://bugs.kde.org/attachment.cgi?id=135703&action=edit Sample Image I did a clean install with a clean MySQL db and narrowed the steps to reproduce this issue. 1. Load attached sample image into digiKam Album - this sample image has a MS WPG People Tag "Albert Einstein" as well a keyword/tag "Albert Einstein". 2. Note people tag "Albert Einstein" created below special "People" tag 3. Move "Albert Einstein" tag beneath "People" tag 4. Close digiKam 5. Open digiKam Encountered Behavior: - Tag return to previous state, at the same level as "People" tag -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #4 from José Oliver-Didier --- I take my previous comment back, after another restart of digiKam the tags returned back to the previous locations not under the "People" parent tag. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #3 from José Oliver-Didier --- Thanks Maik. Moving the tags within the "People" view as well as using the Tag Manager, but when I restart digiKam they returned to the previous locations. Typically, I do not store people's names in my tags/keywords- only in MS Windows Photo Gallery People Tags. However, I discovered that some of the affected photos had tags in the tag/keyword metadata. I deleted these tags in Windows Photo Gallery and moved the tags in digiKam again and this time it worked. digiKam moved them to its People/ structure. Could it be that given I do not have the setting enabled in digiKam to write the metadata back to the file that digiKam re-reads the metadata on restart and gives precedent to the file metadata? I will do some testing around this. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 --- Comment #2 from Maik Qualmann --- One more explanation and I've read your post in user list. The People Tag was created to keep the tags in order. The standard does not provide a path for face tags. Therefore, found face tags from digiKam are tried to combine them under the people tag. This does not always work, if the scanner scans images first and keywords contain the names of later face tags, these are created outside of the people tag. In any case, you can move face tags to the people tag (drop them on people tag and choose move). If this does not work, your database tags tree is corrupted... Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 432957] Some tags appear beneath "People" parent tag in People view/panel
https://bugs.kde.org/show_bug.cgi?id=432957 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com Status|REPORTED|RESOLVED Resolution|--- |INTENTIONAL Version Fixed In||7.2.0 --- Comment #1 from Maik Qualmann --- The people parent tag is by design, it has always been there. The people tag is created automatically if it doesn't exist. If a parent tag exists that has most of the face tags under it, it will not be created. You can move the face tags outside of the people tag to the people tag. This people tag has been discussed for a long time and we have some bug reports about it. Maik -- You are receiving this mail because: You are watching all bug changes.
