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

["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 <marcel.wiesweg at gmx.de> 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
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20100331/3ec7ec85/attachment.html>