[Bug 557619] [NEW] Import from digikam 1 to 1.1.0 fails

[r2d2]

Public bug reported:

Binary package hint: digikam

lucid:~$ digikam -v
Qt: 4.6.2
KDE Development Platform: 4.4.2 (KDE 4.4.2)
digiKam: 1.1.0


After upgrade I can not import my old digikam4.db. Everytime stops after "imported albums" on the initial splash/import window.

Original mesage :
"The schema updating process from version 4 to 5 failed, caused by an error that we did not expect. You can try to discard your old database and start with an empty one. (In this case, please move the database files "digikam3.db" and "digikam4.db" from the directory "/media/..."). More probably you will want to report this error to the digikam-devel at kde.org mailing list. As well, please have a look at what digiKam prints on the console. "
(only /media/... changed for privacy)

On the old system (backports) I got this message on console:
"digikam(6979)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Inserted album root
digikam(6979)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Populated albums
digikam(6979)/digikam (core) Digikam::DatabaseCoreBackend::exec: Failure executing query:
digikam(6979)/digikam (core) Digikam::DatabaseCoreBackend::exec: "REPLACE INTO Images  (id, album, name, status, category, modificationDate, fileSize, uniqueHash) SELECT id, dirid, name, ?, ?, NULL, NULL, NULL FROM ImagesV3;"
digikam(6979)/digikam (core) Digikam::DatabaseCoreBackend::exec: "constraint failed Zeile kann nicht abgeholt werden" 19
digikam(6979)/digikam (core) Digikam::DatabaseCoreBackend::exec: Bound values:  (QVariant(int, 1) ,  QVariant(int, 0) )
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-165520384' is still in use, all queries will cease to work."

Problem is (as I can understand) this:
"Digikam::DatabaseCoreBackend::exec: "REPLACE INTO Images  (id, album,
name, status, category, modificationDate, fileSize, uniqueHash) SELECT
id, dirid, name, ?, ?, NULL, NULL, NULL FROM ImagesV3;""

I will check first, if you have already a fix. Else, I will mail it to
develper mailing list.

** Affects: digikam (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: digikam import sql sqlite upgrade

** Tags added: import upgrade

-- 
Import from digikam 1 to 1.1.0 fails
https://bugs.launchpad.net/bugs/557619
You received this bug notification because you are a member of Kubuntu
Bugs, which is subscribed to digikam in ubuntu.