[digiKam-users] Database tables error message -- won't go away!

[TN Args]

Hi all, I really need a bit of help please!

I was happily using digiKam through 2018 and early 2019, as a user with limited computer and no software skills. But….

Whenever I start digiKam since about April 2019, I get an error message, “Error message: Failed to create tables in database”. You can see what it looks like on my MacOS here: https://www.dpreview.com/forums/post/63414517

I have tried a few things: 

-delete and re-install digiKam

-deleting digikamrc config file

-deleting my digikam4.db database file (after saving a renamed copy), and it made no difference. In fact, when I started digiKam after 'hiding' the old database, it immediately showed exactly the same error message, even though there was no database at that moment other than its own blank creation.

The 'creating tables' error statement still appears.

I am using Mojave 10.14 on MacOS. I want to wait a bit longer before installing 10.15 Catalina.

I am not really seeing any dysfunction on DigiKam, after the error message appears and I have clicked the OK button. But it sure suggests that something is wrong with my database! So I don’t want to ignore it.

thanks

Grant

[Gilles Caulier-4]

Le jeu. 9 janv. 2020 à 03:02, Arg <[hidden email]> a écrit :

Hi all, I really need a bit of help please!

I was happily using digiKam through 2018 and early 2019, as a user with limited computer and no software skills. But….

Whenever I start digiKam since about April 2019, I get an error message, “Error message: Failed to create tables in database”. You can see what it looks like on my MacOS here: https://www.dpreview.com/forums/post/63414517

I have tried a few things: 

-delete and re-install digiKam

-deleting digikamrc config file

-deleting my digikam4.db database file (after saving a renamed copy), and it made no difference. In fact, when I started digiKam after 'hiding' the old database, it immediately showed exactly the same error message, even though there was no database at that moment other than its own blank creation.

The 'creating tables' error statement still appears.

I am using Mojave 10.14 on MacOS. I want to wait a bit longer before installing 10.15 Catalina.

yes, and delay Catalina migration. It have never been tested yet. digiKAm under MacOS is compiled under Mojave for the moment.

I am not really seeing any dysfunction on DigiKam, after the error message appears and I have clicked the OK button. But it sure suggests that something is wrong with my database! So I don’t want to ignore it.

Please follow instruction here to run digiKAm from a Terminal, and post all debug statements here :

https://www.digikam.org/contribute/

Important :

- which digiKam version do you use exactly ?

- which digiKam database do you use ? sqlite, mysql ?

- The database is stored in local drive, removable, network ?

Best

Gilles Caulier

[TN Args]

Hi, I ran the following Terminal command,
export QT_LOGGING_RULES="digikam*=true"
    /opt/digikam/Applications/KF5/digikam.app/Contents/MacOS/digikam

and this is the output: see attached filedigiKam_terminal_mode_readout.rtf

==

Also, the error message that I keep having, appeared again.

thanks





--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[Maik Qualmann]

The thumbnail database file is corrupt -> "/Users/grantsellek/Pictures/
thumbnails-digikam.db". Rename or delete the file, digiKam will gradually
rebuild the thumbnail database.

Maik

Am Montag, 9. März 2020, 09:31:18 CET schrieb TN Args:

> Hi, I ran the following Terminal command,
> export QT_LOGGING_RULES="digikam*=true"
>     /opt/digikam/Applications/KF5/digikam.app/Contents/MacOS/digikam
>
> and this is the output:
>
>
> Last login: Mon Mar  9 15:26:24 on console
> Grants-MBP-2:~ grantsellek$ export QT_LOGGING_RULES="digikam*=true"
> Grants-MBP-2:~ grantsellek$
> /opt/digikam/Applications/KF5/digikam.app/Contents/MacOS/digikam
> digikam.widgets: Breeze icons resource file found
> digikam.widgets: Breeze-dark icons resource file found
> digikam.general: Switch to widget style:  "Fusion"
> digikam.general: AlbumWatch use QFileSystemWatcher
> digikam.general: Database Parameters:
>    Type:                     "QSQLITE"
>    DB Core Name:             "/Users/grantsellek/Pictures/digikam4.db"
>    DB Thumbs Name:
> "/Users/grantsellek/Pictures/thumbnails-digikam.db"
>    DB Face Name:             "/Users/grantsellek/Pictures/recognition.db"
>    DB Similarity Name:       "/Users/grantsellek/Pictures/similarity.db"
>    Connect Options:          ""
>    Host Name:                ""
>    Host port:                -1
>    Internal Server:          false
>    Internal Server Path:     ""
>    Internal Server Serv Cmd: ""
>    Internal Server Init Cmd: ""
>    Username:                 ""
>    Password:                 ""
>
> digikam.dbengine: Loading SQL code from config file
> "/opt/digikam/Applications/KF5/digikam.app/Contents/Resources/digikam/databa
> se/dbconfig.xml" digikam.dbengine: Checking XML version ID => expected:  3
> found:  3 digikam.coredb: Core database: running schema update
> digikam.coredb: Core database: have a structure version  10
> digikam.coredb: Core database: makeUpdates  10  to  10
> digikam.database: Creating new Location  "/Users/grantsellek/Pictures"  uuid
> "volumeid:?uuid=42640a8e-903e-35e0-89d4-75ff0e2ff76f"
> digikam.database: Creating new Location  "/Pictures"  uuid
> "volumeid:?label=Transcend"
> digikam.database: Creating new Location  "/"  uuid
> "networkshareid:?mountpath=/Volumes/GrantNAS/NAS Pictures"
> digikam.database: location for  "/Users/grantsellek/Pictures"  is available
> true
> digikam.database: location for  "/Volumes/Transcend/Pictures"  is available
> true
> digikam.database: location for  "/Volumes/GrantNAS/NAS Pictures"  is
> available  false
> KMemoryInfo: Platform identified :  "Unknown"
> KMemoryInfo: TotalRam:  -1
> digikam.general: Allowing a cache size of 60 MB
> digikam.thumbsdb: Thumbs database: no database file available
> digikam.dbengine: Failure executing query:
>  ""
> Error messages: "Unable to execute statement" "database disk image is
> malformed" "11" 2
> Bound values:  ()
> digikam.dbengine: Error while executing DBAction [ "CreateThumbnailsDB" ]
> Statement [ "CREATE TABLE Thumbnails\n                    (id INTEGER
> PRIMARY KEY,\n                    type INTEGER,\n
> modificationDate DATETIME,\n                    orientationHint INTEGER,\n
> data BLOB);\n                " ]
> digikam.thumbsdb: Thumbs database: cannot process schema initialization
>
> ==
>
> Also, the error message that I keep having, appeared again.
>
> thanks
>
>
>
>
>
> --
> Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[TN Args]

Ok, thanks. 

On Tue, 10 Mar 2020, 7:02 AM Maik Qualmann <[hidden email]> wrote:

The thumbnail database file is corrupt -> "/Users/grantsellek/Pictures/
thumbnails-digikam.db". Rename or delete the file, digiKam will gradually
rebuild the thumbnail database.

Maik

Am Montag, 9. März 2020, 09:31:18 CET schrieb TN Args:
> Hi, I ran the following Terminal command,
> export QT_LOGGING_RULES="digikam*=true"
>     /opt/digikam/Applications/KF5/digikam.app/Contents/MacOS/digikam
>
> and this is the output:
>
>
> Last login: Mon Mar  9 15:26:24 on console
> Grants-MBP-2:~ grantsellek$ export QT_LOGGING_RULES="digikam*=true"
> Grants-MBP-2:~ grantsellek$
> /opt/digikam/Applications/KF5/digikam.app/Contents/MacOS/digikam
> digikam.widgets: Breeze icons resource file found
> digikam.widgets: Breeze-dark icons resource file found
> digikam.general: Switch to widget style:  "Fusion"
> digikam.general: AlbumWatch use QFileSystemWatcher
> digikam.general: Database Parameters:
>    Type:                     "QSQLITE"
>    DB Core Name:             "/Users/grantsellek/Pictures/digikam4.db"
>    DB Thumbs Name:
> "/Users/grantsellek/Pictures/thumbnails-digikam.db"
>    DB Face Name:             "/Users/grantsellek/Pictures/recognition.db"
>    DB Similarity Name:       "/Users/grantsellek/Pictures/similarity.db"
>    Connect Options:          ""
>    Host Name:                ""
>    Host port:                -1
>    Internal Server:          false
>    Internal Server Path:     ""
>    Internal Server Serv Cmd: ""
>    Internal Server Init Cmd: ""
>    Username:                 ""
>    Password:                 ""
>
> digikam.dbengine: Loading SQL code from config file
> "/opt/digikam/Applications/KF5/digikam.app/Contents/Resources/digikam/databa
> se/dbconfig.xml" digikam.dbengine: Checking XML version ID => expected:  3
> found:  3 digikam.coredb: Core database: running schema update
> digikam.coredb: Core database: have a structure version  10
> digikam.coredb: Core database: makeUpdates  10  to  10
> digikam.database: Creating new Location  "/Users/grantsellek/Pictures"  uuid
> "volumeid:?uuid=42640a8e-903e-35e0-89d4-75ff0e2ff76f"
> digikam.database: Creating new Location  "/Pictures"  uuid
> "volumeid:?label=Transcend"
> digikam.database: Creating new Location  "/"  uuid
> "networkshareid:?mountpath=/Volumes/GrantNAS/NAS Pictures"
> digikam.database: location for  "/Users/grantsellek/Pictures"  is available
> true
> digikam.database: location for  "/Volumes/Transcend/Pictures"  is available
> true
> digikam.database: location for  "/Volumes/GrantNAS/NAS Pictures"  is
> available  false
> KMemoryInfo: Platform identified :  "Unknown"
> KMemoryInfo: TotalRam:  -1
> digikam.general: Allowing a cache size of 60 MB
> digikam.thumbsdb: Thumbs database: no database file available
> digikam.dbengine: Failure executing query:
>  ""
> Error messages: "Unable to execute statement" "database disk image is
> malformed" "11" 2
> Bound values:  ()
> digikam.dbengine: Error while executing DBAction [ "CreateThumbnailsDB" ]
> Statement [ "CREATE TABLE Thumbnails\n                    (id INTEGER
> PRIMARY KEY,\n                    type INTEGER,\n
> modificationDate DATETIME,\n                    orientationHint INTEGER,\n
> data BLOB);\n                " ]
> digikam.thumbsdb: Thumbs database: cannot process schema initialization
>
> ==
>
> Also, the error message that I keep having, appeared again.
>
> thanks
>
>
>
>
>
> --
> Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html