https://bugs.kde.org/show_bug.cgi?id=372312
--- Comment #15 from Kusi <k...@forum.titlis.org> --- update procedure looks now more robust, thanks! It doesn't address yet the issue about having a too long key as reported initially and confirmed here: https://mail.kde.org/pipermail/digikam-users/2016-August/022581.html Does it make sense to have datatype LONGTEXT for column Albums.relativePath when you crop it anyways with UNIQUE (albumRoot, relativePath(255))? If your path is indeed longer than 255 (which is anyways not supported by many fs), you could miss the unique constraint. datatype varchar(255) would prevent that (and solves the initially reported issue for me) -- You are receiving this mail because: You are watching all bug changes.