[Digikam-users] Digikam unable to convert DB4 to 5 - SQL error

["Umberto" K.]

Hi!

After an upgrade of digikam package (ubuntu backports) I get this output on
konsole. It looks like the DB file has a

...
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.
...
A I know this is the problem:
"SELECT id, dirid, name, ?, ?, NULL, NULL, NULL FROM ImagesV3;"
...it's missing column names (SQL-prepare failed?)


Best
Umberto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20100330/4cc68c46/attachment.html>