https://bugs.kde.org/show_bug.cgi?id=327646
Bug ID: 327646 Summary: Failed to create tables in database" Error In digiKam Classification: Unclassified Product: digikam Version: 3.5.0 Platform: openSUSE RPMs OS: Linux Status: UNCONFIRMED Severity: major Priority: NOR Component: Database Assignee: [hidden email] Reporter: [hidden email] I have a NAS with some form of linux and a MySQL server on it. I have full access from the network. I have tried this on both OpenSUSE 13.1 with Digikam 3.5 and Kubuntu 13.10 with Digikam 3.4. What I do is, fresh install of Digikam, fresh user settings. Start digikam add folder for photos and then enter settings for MySQL database, click check db connection getting ok, then clicking [OK]. Now i get Failed to create tables in database" Error In digiKam. If I restart Digikam now I get some other fail message about some missing table entery or version. Here are mu SQL commands: CREATE DATABASE digikamdb; GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY '*****'; FLUSH PRIVILEGES; CREATE DATABASE digikamthumbdb; GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY '*****'; FLUSH PRIVILEGES; Reproducible: Always Steps to Reproduce: 1. Add MySQL to Digikam settings, click [OK] 2. 3. Actual Results: Failed to create tables in database" Error In digiKam. Expected Results: Working database connection I have tried with a regular user also to only root. I can create and drop schemas/databases and have full access. -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
https://bugs.kde.org/show_bug.cgi?id=327646
Petr Bohac <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] --- Comment #1 from Petr Bohac <[hidden email]> --- 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 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email], | |[hidden email] --- Comment #2 from Gilles Caulier <[hidden email]> --- Marcel, Do you see the solution given in #1 ? It's acceptable for you ? Gilles Caulier -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
--- Comment #3 from Petr Bohac <[hidden email]> --- 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) -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Failed to create tables in |MySQL : Failed to create |database" Error In digiKam |tables in database" Error | |In digiKam -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|MySQL : Failed to create |MySQL : Failed to create |tables in database" Error |tables in database" Error |In digiKam |In digiKam [patch] --- Comment #4 from Gilles Caulier <[hidden email]> --- Marcel, There is a simple fix in comment #1 about this problem. Sound right for you to apply on database schema ? Gilles Caulier -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
--- Comment #5 from Marcel Wiesweg <[hidden email]> --- Im no MySQL expert. If it fixes the problem, it's fine for me. -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
--- Comment #6 from Gilles Caulier <[hidden email]> --- Created attachment 88162 --> https://bugs.kde.org/attachment.cgi?id=88162&action=edit 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 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
--- Comment #7 from Marcel Wiesweg <[hidden email]> --- Comment on attachment 88162 --> https://bugs.kde.org/attachment.cgi?id=88162 patch to update DB schema about Images.names field Looks all right for me -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Latest Commit| |http://commits.kde.org/digi | |kam/e0ed987c93c828f6d7ea515 | |d01138558201db23c Status|UNCONFIRMED |RESOLVED Version Fixed In| |4.3.0 Resolution|--- |FIXED --- Comment #8 from Gilles Caulier <[hidden email]> --- 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 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Christian Nyman
https://bugs.kde.org/show_bug.cgi?id=327646
[hidden email] changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database |Database-Mysql -- You are receiving this mail because: You are the assignee for the bug. |
Free forum by Nabble | Edit this page |