SUMMARY *** NOTE: If you are reporting a crash, please try to attach a backtrace with debug symbols. See https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports *** STEPS TO REPRODUCE 1. Download appimage: digiKam-8.1.0-x86-64.appimage 2. Create "digikam" user with all rights to "digikam/#" database in external database server running MariaDB in Ubuntu 22.04 computer 3. Give settings to digikam MySQL screen and press Finish OBSERVED RESULT 1. Error message with text "Failed to create tables" is given 2. On database server, 20 tables are created: MariaDB [digikam]> show tables; +--------------------+ | Tables_in_digikam | +--------------------+ | AlbumRoots | | Albums | | DownloadHistory | | ImageComments | | ImageCopyright | | ImageHistory | | ImageInformation | | ImageMetadata | | ImagePositions | | ImageProperties | | ImageRelations | | ImageTagProperties | | ImageTags | | Images | | Searches | | Settings | | TagProperties | | Tags | | TagsTree | | VideoMetadata | +--------------------+ EXPECTED RESULT Digikam should initialize database and start working properly. SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: Client computer: Debian 12 (available in About System) KDE Plasma Version: KDE Frameworks Version: Qt Version: Database computer: Ubuntu 22.04 MariaDB version: 10.6.12-MariaDB-0ubuntu0.22.04.1-log ADDITIONAL INFORMATION Database server works fine with other clients using MySQL interface.
See this recent Bug 472734 report for solutions. We definitely need the debug log from the terminal. Maik
Check if you also have the rights to create triggers. For triggers, see this Bug 447416 or Bug 435065 as an example. Maik
I added following on database server: MariaDB [digikam]> set global log_bin_trust_function_creators=1; Query OK, 0 rows affected (0.000 sec) This solved the problem and now Digikam works fine. Could this be added to Digikam's startup documentation?
Git commit 9ed1deb785ce30f316f89fc7c38daee126d5ec60 by Maik Qualmann. Committed on 01/08/2023 at 08:21. Pushed by mqualmann into branch 'master'. add note for MySQL server on Ubuntu Related: bug 472734 FIXED-IN: 8.2.0 M +1 -1 NEWS M +3 -0 core/libs/database/utils/widgets/dbsettingswidget.cpp https://invent.kde.org/graphics/digikam/-/commit/9ed1deb785ce30f316f89fc7c38daee126d5ec60
Git commit 1108d12b65fec2d7320acac8f32290b85a7660b7 by Gilles Caulier. Committed on 01/08/2023 at 10:53. Pushed by cgilles into branch 'master'. digiKam online doc: add note about Mysql under Ubuntu which need additional sql code to create triggers. M +8 -0 setup_application/database_settings.rst https://invent.kde.org/documentation/digikam-doc/-/commit/1108d12b65fec2d7320acac8f32290b85a7660b7