[digiKam-users] Database failure

[Ray Liggett]

Thank you Giles for your suggestion.

I downloaded and installed 7.0.0 (after removing the previously installed version). Set up using sqlite. Digicam started loading my photos as expected. However when it got ~30% of the way through my computer crashed. On resuming digicam had the following message:
You have insufficient privileges on the database.
Following privileges are not assigned to you:
 CREATE TABLE
Check your privileges on the database and restart digiKam.

The program is still open but all I get from it is the message.I have no idea how to check my privileges and I surely I should not have to.

I mistakenly said I’m running Mohave. In fact I’m on Catalina.

Any suggestions, please.

Ray

> On 25 Apr 2020, at 9:00 pm, digikam-users-request at kde.org wrote:
> 
> Send Digikam-users mailing list submissions to
> 	digikam-users at kde.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://mail.kde.org/mailman/listinfo/digikam-users
> or, via email, send a message with subject or body 'help' to
> 	digikam-users-request at kde.org
> 
> You can reach the person managing the list at
> 	digikam-users-owner at kde.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Digikam-users digest..."
> 
> 
> Today's Topics:
> 
>   1. Re:  Database failure (Gilles Caulier)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Sat, 25 Apr 2020 08:43:46 +0200
> From: Gilles Caulier <caulier.gilles at gmail.com>
> To: digiKam - Home Manage your photographs as a professional with the
> 	power of open source <digikam-users at kde.org>
> Subject: Re: [digiKam-users] Database failure
> Message-ID:
> 	<CAHFG6sGdDtF_-i1nm1TYki+dAY7tz6etiSBLWWWrUUsj2TJ9Pg at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
> 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
>> 
> 
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
> 
> 
> ------------------------------
> 
> End of Digikam-users Digest, Vol 179, Issue 27
> **********************************************