[digiKam-users] Database failure
Maik Qualmann
metzpinguin at gmail.com
Sun Apr 26 07:33:12 BST 2020
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
> > **********************************************
More information about the Digikam-users
mailing list