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

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Marcel Wiesweg]

> 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?
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

["Umberto" K.]

HI!

Here is the version:

digikam -v
Qt: 4.6.2
KDE: 4.4.1 (KDE 4.4.1)
digiKam: 1.1.0


Package:

dpkg -l digikam
...
ii  digikam                       2:1.1.0-1ubuntu2~karmic1~ppa1 digital photo management application for KDE

Updated from 1.0 (or in other words the last stable in 9.04).

Any ideas?

Best

Umberto

On 30 March 2010 22:09, Marcel Wiesweg <[hidden email]> wrote:

> 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?
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users