Import from digikam 1 to 1.1.0 fails

Bug #557619 reported by r2d2 on 2010-04-07
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
digikam (Ubuntu)
Undecided
Unassigned

Bug Description

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 <email address hidden> 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.

r2d2 (r2d2-c3p0) wrote :

database (digikam4.db) will not work as original and not as original->sql->sqlite3_create_database (export & import ok)

tags: added: import upgrade
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers