SUMMARY *** I have migrated to MySQL on a MyCloud Ex2 Ultra NAS approx. 1 week ago. Digikam was running stable for about 1 week on version 8.3.0 (if I remember right). Problem is, that I get - even before upcoming loading image - a fault message "You do not have the necessary rights for the database. You do not have the following rights: CREATE TABLE Check your rights for the database and restart digiKam." (Translated from German) I cannot even enter the setup dialogue in digikam, because it does not start. Actually a window opened from digiKam, that it is trying to open the database automatically.... *** SOFTWARE/OS VERSIONS Windows: Windows 11 NAS: MyCloud Ex2 Ultra, Version Update recently 5.27.161 (might be the root cause) ADDITIONAL INFORMATION
This is a basic test at the start, an attempt is made to create a test table. If this is not possible, digiKam has no authorization. In fact, there is nothing we can do at this point, you have to use appropriate tools to find out why the database is no longer writable. Please create a DebugView Log from the start of digiKam, as described here for Windows: https://www.digikam.org/contribute/ Maik
Another note, there is no problem logging into the database, it was successful. But your database user may no longer have permission for your digiKam database. You have to check this manually, e.g. with HeidiSQL Maik
Git commit 2e7d2ce9e838eacbd89252ee623956735cf9520f by Maik Qualmann. Committed on 28/01/2024 at 11:03. Pushed by mqualmann into branch 'master'. show database settings page even in case of initialization error FIXED-IN: 8.3.0 M +1 -1 NEWS M +10 -11 core/libs/album/manager/albummanager_database.cpp https://invent.kde.org/graphics/digikam/-/commit/2e7d2ce9e838eacbd89252ee623956735cf9520f
Git commit c73ded2e8e5553950074aa137434d8a99ec82c1a by Maik Qualmann. Committed on 28/01/2024 at 12:10. Pushed by mqualmann into branch 'master'. show error message directly in database settings page M +12 -8 core/libs/album/manager/albummanager_database.cpp https://invent.kde.org/graphics/digikam/-/commit/c73ded2e8e5553950074aa137434d8a99ec82c1a