Importing images not possible

[Rüdiger Härtel]

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

[Gilles Caulier-4]

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 <[hidden email]>:

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