[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #13 from Peter --- Ok! Grateful thanks Maik! -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #12 from Maik Qualmann --- A database update is then carried out automatically when digiKam starts. The start scan for new items will then find additional folders and possibly images that previously only differed in upper / lower case. The problem with the view should then be resolved. With this commit we have already made sure that the search for album path and item name is still not case sensitive. https://invent.kde.org/graphics/digikam/-/commit/7c06a091903978bd698067a5b93875f36653a913 Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #11 from Peter --- (In reply to Maik Qualmann from comment #10) > Git commit 56c96d9aadca8a2108c08b09888541e52a0eedea by Maik Qualmann. > Committed on 20/12/2021 at 07:16. > Pushed by mqualmann into branch 'master'. > > use COLLATE utf8_bin for album path and image name > Related: bug 414344, bug 435767, bug 445948 > FIXED-IN: 7.5.0 > > M +4-4NEWS > M +11 -2core/data/database/dbconfig.xml.cmake.in > M +9-1core/libs/database/coredb/coredbschemaupdater.cpp > > https://invent.kde.org/graphics/digikam/commit/ > 56c96d9aadca8a2108c08b09888541e52a0eedea This excellent news! Thanks Maik! In this case, do I need to rebuild the database? Or, what should I do? -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 Maik Qualmann changed: What|Removed |Added Latest Commit||https://invent.kde.org/grap ||hics/digikam/commit/56c96d9 ||aadca8a2108c08b09888541e52a ||0eedea --- Comment #10 from Maik Qualmann --- Git commit 56c96d9aadca8a2108c08b09888541e52a0eedea by Maik Qualmann. Committed on 20/12/2021 at 07:16. Pushed by mqualmann into branch 'master'. use COLLATE utf8_bin for album path and image name Related: bug 414344, bug 435767, bug 445948 FIXED-IN: 7.5.0 M +4-4NEWS M +11 -2core/data/database/dbconfig.xml.cmake.in M +9-1core/libs/database/coredb/coredbschemaupdater.cpp https://invent.kde.org/graphics/digikam/commit/56c96d9aadca8a2108c08b09888541e52a0eedea -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 Maik Qualmann changed: What|Removed |Added Version Fixed In||7.5.0 Status|CONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #9 from Maik Qualmann --- Fixed with commit: https://invent.kde.org/graphics/digikam/-/commit/56c96d9aadca8a2108c08b09888541e52a0eedea Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #8 from Maik Qualmann --- Since the problem occurs more often in bug 414344, I plan to convert the columns Albums:relativePath and Images:name in MySQL as collate utf8-bin. Then album paths and file names can only differ in upper / lower case even under MySQL. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #7 from Peter --- (In reply to Maik Qualmann from comment #6) > Ok, you have another problem. In your collection you have album paths that > only differ in upper / lower case, that is currently not possible with > MySQL, see also Bug 414344. > > Change the following album names: > > /Dokumentumok/Pályázatok/LEADER/tuskevar (tuskevar exists also in upper > case) > > /_BACKUP_/20190928_6_12_duplikatum/X/Dokumentumok/Pályázatok/Pályázatok/ÚJ > LEADERES PÁLYÁZATOK/Jeles napok a Szentek > társaságában/DOKUMENTUMOK/dokumentáció/2013.10.18 - Növények a Bibliából - > Kertbarátkör előadás/fotódokumentáció > > /_BACKUP_/20191001_4_5_duplikatum/X/Dokumentumok/Pályázatok/2016/Alapítvány/ > Norvég Alap/Loli Zumi/Szakmai előrehaladási jelentés/3. Szakmai > előrehaladási jelentés Loli Zumi/Alátámasztó dokumentumok/Szakmai > tevékenység megvalósításába bevont közreműködők > > Maik Long filenames and exotic characters in the names. I knew they were going to cause a problem now or later... I will change the path and filenames. Thank You Maik. Regards Peter -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #6 from Maik Qualmann --- Ok, you have another problem. In your collection you have album paths that only differ in upper / lower case, that is currently not possible with MySQL, see also Bug 414344. Change the following album names: /Dokumentumok/Pályázatok/LEADER/tuskevar (tuskevar exists also in upper case) /_BACKUP_/20190928_6_12_duplikatum/X/Dokumentumok/Pályázatok/Pályázatok/ÚJ LEADERES PÁLYÁZATOK/Jeles napok a Szentek társaságában/DOKUMENTUMOK/dokumentáció/2013.10.18 - Növények a Bibliából - Kertbarátkör előadás/fotódokumentáció /_BACKUP_/20191001_4_5_duplikatum/X/Dokumentumok/Pályázatok/2016/Alapítvány/Norvég Alap/Loli Zumi/Szakmai előrehaladási jelentés/3. Szakmai előrehaladási jelentés Loli Zumi/Alátámasztó dokumentumok/Szakmai tevékenység megvalósításába bevont közreműködők Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #5 from Peter --- > I see a very long path Yes, the girls in the office used very long file path in the past. This is a difficult legacy. :-( -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 Maik Qualmann changed: What|Removed |Added Ever confirmed|0 |1 Status|REPORTED|CONFIRMED --- Comment #4 from Maik Qualmann --- The SQL dump is very helpful, I can reproduce the problem. The cause is the identifier for the item separation by album, the other as format and month do not have the problem. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 Maik Qualmann changed: What|Removed |Added CC||[email protected] --- Comment #3 from Maik Qualmann --- Well the problem is not unknown. The problem occurs when the item identifier is duplicated in the view model. In principle, we've fixed almost all of the problems over the years. The item identifier is formed from the file path in your settings, I see a very long path, there must be duplicate identifications. I'll have a look. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #2 from Peter --- Sorry, an important info missed: "I attached it to the ticket a database dump file and..." Correctly: I attached it to the ticket a MYSQL database dump file and... -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 447233] Incorrect display of album thumbnails
https://bugs.kde.org/show_bug.cgi?id=447233 --- Comment #1 from Peter --- Example database and an Screenshot in the zip archivum: https://mega.nz/file/EN40xCAC#pb0oZO-ebqBuZV84eNwh40Um_fImolLYVIbvb50kAQQ -- You are receiving this mail because: You are watching all bug changes.
