[digiKam-users] Database failure

Ray Liggett liggettray at gmail.com
Sat Apr 25 03:29:41 BST 2020


I am trying to use the latest release of DigiKam (digiKam-6.4.0-MacOS-x86-64) on my Mac running Mohave. I have a large number of photos.
Initially tried the Mysql internal server but it crashed my computer. I deleted DigiKam finding all that I could then reinstalled DigiKam and used SQLite but still received a database fail message. 
I trolled through the archived subscriber entries for 3 months and found no solution but the suggestion to run a diagnostic which I’ve copied below.
What can I do now? Given I have > 200k photos should I be using MySQL?
Thanks

Last login: Sat Apr 25 09:29:36 on console

The default interactive shell is now zsh.
To update your account to use zsh, please run `chsh -s /bin/zsh`.
For more details, please visit https://support.apple.com/kb/HT208050.
Rays-iMac:~ rayliggett$ /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 is disabled
digikam.general: Database Parameters:
   Type:                     "QSQLITE"
   DB Core Name:             "/Users/rayliggett/Pictures/All Our Photos/digikam4.db"
   DB Thumbs Name:           "/Users/rayliggett/Pictures/All Our Photos/thumbnails-digikam.db"
   DB Face Name:             "/Users/rayliggett/Pictures/All Our Photos/recognition.db"
   DB Similarity Name:       "/Users/rayliggett/Pictures/All Our Photos/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/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected:  3  found:  3
digikam.coredb: Core database: running schema update
digikam.coredb: Core 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 [ "CreateDB" ] Statement [ "CREATE TABLE AlbumRoots\n                    (id INTEGER PRIMARY KEY,\n                    label TEXT,\n                    status INTEGER NOT NULL,\n                    type INTEGER NOT NULL,\n                    identifier TEXT,\n                    specificPath TEXT,\n                    UNIQUE(identifier, specificPath));\n                " ]
digikam.coredb: Core database: cannot process schema initialization



More information about the Digikam-users mailing list