[digikam] [Bug 372312] database upgrade v7 to v8 failed

[Kusi]

https://bugs.kde.org/show_bug.cgi?id=372312

--- Comment #15 from Kusi <kusi at 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 the assignee for the bug.