[digiKam-users] Database failure
Locked
 
|
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 |
|
|
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 <[hidden email]> 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 > |
|
|
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, [hidden email] wrote: > > Send Digikam-users mailing list submissions to > [hidden email] > > 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 > [hidden email] > > You can reach the person managing the list at > [hidden email] > > 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 <[hidden email]> > To: digiKam - Home Manage your photographs as a professional with the > power of open source <[hidden email]> > Subject: Re: [digiKam-users] Database failure > Message-ID: > <[hidden email]> > 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 <[hidden email]> 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 > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > > > ------------------------------ > > End of Digikam-users Digest, Vol 179, Issue 27 > ********************************************** |
|
|
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, [hidden email] wrote: > > > > Send Digikam-users mailing list submissions to > > > > [hidden email] > > > > 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 > > > > [hidden email] > > > > You can reach the person managing the list at > > > > [hidden email] > > > > 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 <[hidden email]> > > To: digiKam - Home Manage your photographs as a professional with the > > > > power of open source <[hidden email]> > > > > Subject: Re: [digiKam-users] Database failure > > > > Message-ID: > > <CAHFG6sGdDtF_- > > > > 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 <[hidden email]> 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 > > [hidden email] > > https://mail.kde.org/mailman/listinfo/digikam-users > > > > > > ------------------------------ > > > > End of Digikam-users Digest, Vol 179, Issue 27 > > ********************************************** |
|
|
In reply to this post by Gilles Caulier-4
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 <[hidden email]> > To: digiKam - Home Manage your photographs as a professional with the > power of open source <[hidden email]> > Subject: Re: [digiKam-users] Database failure > Message-ID: <1627863.VLpDuZHEXP@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, [hidden email] wrote: >>> >>> Send Digikam-users mailing list submissions to >>> >>> [hidden email] >>> >>> 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 >>> >>> [hidden email] >>> >>> You can reach the person managing the list at >>> >>> [hidden email] >>> >>> 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 <[hidden email]> >>> To: digiKam - Home Manage your photographs as a professional with the >>> >>> power of open source <[hidden email]> >>> >>> Subject: Re: [digiKam-users] Database failure >>> >>> Message-ID: >>> <CAHFG6sGdDtF_- > [hidden email]> >>> >>> 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 <[hidden email]> 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 >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >>> >>> >>> ------------------------------ >>> >>> End of Digikam-users Digest, Vol 179, Issue 27 >>> ********************************************** > > > > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > > > ------------------------------ > > End of Digikam-users Digest, Vol 179, Issue 28 > ********************************************** |
|
|
On Sun, 26 Apr 2020 16:58:17 +1000
Ray Liggett <[hidden email]> wrote: > I’ve given digiKam read and write privileges for my entire disc and > still get the same message. Um, I thought that you can only assign permissions to users and groups on MacOS and not programs... -- sknahT vyS |
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |