Summary: | MySQL : Failed to create tables in database" Error In digiKam [patch] | ||
---|---|---|---|
Product: | [Applications] digikam | Reporter: | Christian Nyman <christianwn> |
Component: | Database-Mysql | Assignee: | Digikam Developers <digikam-bugs-null> |
Status: | RESOLVED FIXED | ||
Severity: | major | CC: | bohacpetr, caulier.gilles, christianwn, marcel.wiesweg |
Priority: | NOR | ||
Version: | 3.5.0 | ||
Target Milestone: | --- | ||
Platform: | openSUSE | ||
OS: | Linux | ||
Latest Commit: | http://commits.kde.org/digikam/e0ed987c93c828f6d7ea515d01138558201db23c | Version Fixed In: | 4.3.0 |
Attachments: | patch to update DB schema about Images.names field |
Description
Christian Nyman
2013-11-15 12:32:48 UTC
Same problem (digiKam 3.4.0 and mariadb 10) on openSUSE Tumbleweed. It is caused by creating too long index CALL create_index_if_not_exists('Images','image_name_index','name(996)'); Workaround: 1) edit /usr/share/kde4/apps/digikam/database/dbconfig.xml line 1002 (version 3.4.0) and replace "name(996)" by "name(255)". 2) Drop all tables in database and rerun digiKam Marcel, Do you see the solution given in #1 ? It's acceptable for you ? Gilles Caulier Yes it works fine and: - filenames are usualy limited to 255 characters by filesystem - IMHO index length 255 is still overkill, length 32 should work fine for most cases (maybe even lower) Marcel, There is a simple fix in comment #1 about this problem. Sound right for you to apply on database schema ? Gilles Caulier Im no MySQL expert. If it fixes the problem, it's fine for me. Created attachment 88162 [details]
patch to update DB schema about Images.names field
Marcel,
A patch to update schema at 2 place where Images.names field is present. Schema version is also increased.
Please take a look if i don't forget something.
Gilles
Comment on attachment 88162 [details]
patch to update DB schema about Images.names field
Looks all right for me
Git commit e0ed987c93c828f6d7ea515d01138558201db23c by Gilles Caulier. Committed on 08/08/2014 at 16:55. Pushed by cgilles into branch 'master'. Update Database schema to version 2 to fix Images.names field size FIXED-IN: 4.3.0 M +8 -3 CMakeLists.txt M +2 -1 NEWS M +2 -2 data/database/dbconfig.xml.cmake.in http://commits.kde.org/digikam/e0ed987c93c828f6d7ea515d01138558201db23c |