SUMMARY I went from the last Digikam stable to the 7.2.0.2beta and received an error about the database. I uninstalled MariaDB and did a clean install of Digikam. Now i get this error: "You have insufficient privileges on the database. Following privileges are not assigned to you: ALTER TABLE Check your privileges on the database and restart digiKam." How can I go about solving this or somehow just deleting everything any starting fresh? SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: (available in About System) KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION
We need more information, which operating system? Linux, MacOS, Windows? Do you use the internal or external MySQL server? Post the digiKam start log as described here: https://www.digikam.org/contribute/ Maik
(In reply to Maik Qualmann from comment #1) > We need more information, which operating system? Linux, MacOS, Windows? Do > you use the internal or external MySQL server? Post the digiKam start log as > described here: > > https://www.digikam.org/contribute/ > > Maik I have Windows 10, and I searched "Windows System Info" and nothing came up. Also I deleted the database folder and it opened up a fresh copy of Digikam. The it asked to download some new face library. I restarted my digikam afterwards now it says "Failed to create tables in database."
What do you mean, you deleted the database folder? Why do you do that? Which database type have you set in digiKam Setup under Database? SQLite, internal MySQL, or external MySQL? With an external MySQL server, you have to set all rights correctly yourself and create the database. Otherwise we need the DebugView log. Since you have already deleted everything and probably want to start over, you should also delete the digikamrc file in Appdata. Maik
(In reply to Maik Qualmann from comment #3) > What do you mean, you deleted the database folder? Why do you do that? > Which database type have you set in digiKam Setup under Database? SQLite, > internal MySQL, or external MySQL? > With an external MySQL server, you have to set all rights correctly yourself > and create the database. Otherwise we need the DebugView log. > > Since you have already deleted everything and probably want to start over, > you should also delete the digikamrc file in Appdata. > > Maik I deleted that and it started from scratch. Thank you! The reason I had wanted to delete everything was because I have about 110 million photos and Digikam kept freezing/crashing whenever I tried opening so I just wanted to start fresh with one of my smaller albums instead of my entire catalog.
110 millions of photo ? really ? Gilles Caulier
@Samuel digiKam 8.0.0 is out. This entry still valid with this release ? Best regards Gilles Caulier
@Samuel, This problem still reproducible with the new digiKam 8.2.0 pre-release Windows installer available at usual place: https://files.kde.org/digikam/ This new bundle is based on last Qt framework 5.15.11 and KDE framework 5.110. Thanks in advance Gilles Caulier
Fixed with Bug 475874 Maik