[digiKam-users] Database failure

[Gilles Caulier]

Hi,

Can you reproduce the problem using current 7.0.0-rc PKG ?

https://files.kde.org/digikam/

I use Mojave here, and it work as expected with a new account and sqlite.

best

Gilles Cauier

Le sam. 25 avr. 2020 à 04:30, Ray Liggett <liggettray at gmail.com> a écrit :
>
> 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
>