[digiKam-users] Database failure
Ray Liggett
liggettray at gmail.com
Sun Apr 26 07:58:17 BST 2020
Thanks Malk
I’ve given digiKam read and write privileges for my entire disc and still get the same message.
Ray
>
>
> Message: 6
> Date: Sun, 26 Apr 2020 08:33:12 +0200
> From: Maik Qualmann <metzpinguin 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: <1627863.VLpDuZHEXP at linux-tpgn>
> Content-Type: text/plain; charset="UTF-8"
>
> This message:
>
>> Following privileges are not assigned to you:
>> CREATE TABLE
>> Check your privileges on the database and restart digiKam.
>
> Indicates that the digikam4.db file is read-only for digiKam. Perhaps you have
> not allowed digiKam to write to your user directory? I don't use MacOS often,
> but when I installed VirtualBox two weeks ago, I have to confirm that
> VirtualBox is allowed to write to the user directory.
>
> Maik
>
>> Am Sonntag, 26. April 2020, 08:23:02 CEST schrieb 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/da
>>>> tabase/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
>>> **********************************************
>
>
>
>
>
>
> ------------------------------
>
> 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 28
> **********************************************
More information about the Digikam-users
mailing list