[Digikam-devel] [Bug 280678] New: Cannot migrate from sqlite to mysql

[E. Lewis]

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

           Summary: Cannot migrate from sqlite to mysql
           Product: digikam
           Version: 1.9.0
          Platform: Fedora RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: ed.lewis at enlewis.com


Version:           1.9.0 (using KDE 4.6.5) 
OS:                Linux

'tools' - 'database migration' - 'migrate' results in error: 'Error while
creating the database schema' 
'Check DB Connection' shows connection is being made okay.
The database migration creates a single unpopulated table 'AlbumRoots' in
target database. The progress information shows overall progress at 7\% and
step progress at 0\% when error comes up.

Reproducible: Always

Steps to Reproduce:
Create mysql database. Grant all privileges on the database to digikam user.
Test database for creating, editing, dropping \&c. through various mysql
clients.
Go to digikam and elect 'tools' 'database migration'. Migrate from sqlite to
mysql. Enter proper login info for mysql. The error will occur.

Actual Results:  
'Error while creating the database schema'.

Expected Results:  
digikam would create appropriate tables in mysql and then upload data through
series of mysql insert statements or create a temporary file and 'load data
infile'

This is on a Fedora-15 64-bit system.
mysql runs very well on this system.
Appears similar to bug 276171

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.