Importing images not possible

[Gilles Caulier]

Hi,

It' clear : Error messages: "Der Datensatz konnte nicht abgeholt werden"
"unable to open database file" 14 1

The sqlite database cannot be open. HDD failure, user right to access to
file, DB file corrupted... etc...

Well check you system first.

Gilles Caulier

2017-09-05 22:09 GMT+02:00 Rüdiger Härtel <r_haertel at gmx.de>:

> Hello,
>
> I created a new album in the import dialog. Digikam does not show the new
> album although it is physically there (checked with ls). I can retry it
> and stays the same.
>
> Then started digikam from command line and I got this output:
>
> -----8<-----------------8<-------------------
> digikam.geoiface: "ROADMAP"
> digikam.general: scan mode: ScanDeferredFiles
> digikam.general: total scan value :  10534
> digikam.dbengine: Failure executing query:
>  "REPLACE INTO Albums (albumRoot, relativePath, date, caption, collection)
> VALUES(?, ?, ?, ?, ?);"
> Error messages: "Der Datensatz konnte nicht abgeholt werden" "unable to
> open database file" 14 1
> Bound values:  (QVariant(int, 1), QVariant(QString,
> "/Ausfluege/Umgebung/201708-AllerRadweg"), QVariant(QString,
> "2017-09-05"), QVariant(QString, ""), QVariant(QString, ""))
> digikam.database: items to tag ()
> digikam.dbengine: Failure executing query:
>  "REPLACE into Settings VALUES (?,?);"
> Error messages: "Der Datensatz konnte nicht abgeholt werden" "unable to
> open database file" 14 1
> Bound values:  (QVariant(QString, "DeleteRemovedCompleteScanCount"),
> QVariant(QString, "4"))
> digikam.dbengine: Failure executing query:
>  "REPLACE into Settings VALUES (?,?);"
> Error messages: "Der Datensatz konnte nicht abgeholt werden" "unable to
> open database file" 14 1
> Bound values:  (QVariant(QString, "Scanned"), QVariant(QString,
> "2017-09-05T21:40:36"))
> digikam.database: Complete scan took: 816 msecs.
> digikam.general: Event is dispatched through a passive pop-up
>
> -----8<-----------------8<-------------------
>
> I get this output now on every startup. There are also other messages with
> folders that I also don't see in digikam
> although they are physically there. So I have the same problem with other
> files, too.
>
> I ran this command: sqlite3 -line digikam4.db 'pragma integrity_check;'
> It tells me the integrity_check is ok.
>
> What else can I do to repair the database?
>
> For completeness
> $ uname -a
> Linux elbe 4.4.0-93-generic #116-Ubuntu SMP Fri Aug 11 21:17:51 UTC 2017
> x86_64 x86_64 x86_64 GNU/Linux
> $ digikam --version
> digikam 5.5.0
>
>
> Regards
>
> Rüdiger
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170905/6c42c954/attachment.html>