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-de...@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.

-- 
kubuntu-bugs mailing list
kubuntu-b...@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs

Reply via email to