[digikam] [Bug 327646] New: Failed to create tables in database" Error In digiKam

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] New: Failed to create tables in database" Error In digiKam

Christian Nyman
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] Failed to create tables in database" Error In digiKam

Bugzilla from bohacpetr@bohyn.cz
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] Failed to create tables in database" Error In digiKam

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] Failed to create tables in database" Error In digiKam

Bugzilla from bohacpetr@bohyn.cz
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam [patch]

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam [patch]

Marcel Wiesweg
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam [patch]

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam [patch]

Marcel Wiesweg
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam [patch]

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 327646] MySQL : Failed to create tables in database" Error In digiKam [patch]

bugzilla_noreply
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.