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

Marcel Wiesweg marcel.wiesweg at gmx.de
Tue Mar 30 21:09:31 BST 2010


> 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?)

It says constraint failed. Dont know, this has never happend before to my 
knowledge. The two question marks are replaced by the two bound values.

Which digikam version? Updating from which version?



More information about the Digikam-users mailing list