Package: kmymoney Version: 4.8.0-2 Severity: normal Tags: patch upstream Hello,
The MySQL backend of KMyMoney doesn't work currently, because one of the database fields is called "order" and the name is quoted in a MySQL-unsafe manner. This was tracked in the upstream bug #365615 [1] and was patched for 4.8 in 20191b3d1b662cd8e0d5775799ff51a39cd68e47 [2]. Please consider applying the patch in Debian. [1] https://bugs.kde.org/show_bug.cgi?id=365615 [2] https://cgit.kde.org/kmymoney.git/commit/?id=20191b3d1b662cd8e0d5775799ff51a39cd68e47 Note: it is possible to work-around this issue on the MySQL server side by issuing SET GLOBAL sql_mode = 'ANSI_QUOTES';. This affects all users, databases and session thought, see [3]. [3] https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html#sqlmode_ansi_quotes -- System Information: Debian Release: stretch/sid APT prefers testing APT policy: (990, 'testing'), (990, 'stable'), (500, 'unstable'), (100, 'experimental') Architecture: i386 (x86_64) Foreign Architectures: amd64 Kernel: Linux 4.8.0-1-amd64 (SMP w/4 CPU cores) Locale: LANG=pl_PL, LC_CTYPE=pl_PL (charmap=ISO-8859-2) (ignored: LC_ALL set to pl_PL) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages kmymoney depends on: ii kde-runtime 4:16.08.3-1 ii kdepim-runtime 4:16.04.2-2 ii kmymoney-common 4.8.0-2 ii libakonadi-kde4 4:4.14.10-7 ii libalkimia5 5.0.0-3 ii libaqbanking35 5.6.12-1 ii libaqbanking35-plugins 5.6.12-1 ii libc6 2.24-8 ii libgcc1 1:6.2.1-5 ii libgmp10 2:6.1.2+dfsg-1 ii libgpgme++2v5 4:4.14.10-7 ii libgwengui-cpp0 4.15.3-5 ii libgwengui-qt4-0 4.15.3-5 ii libgwenhywfar60 4.15.3-5 ii libical2 2.0.0-0.5+b1 ii libkabc4 4:4.14.10-7 ii libkcmutils4 4:4.14.26-1 ii libkdecore5 4:4.14.26-1 ii libkdeui5 4:4.14.26-1 ii libkfile4 4:4.14.26-1 ii libkholidays4 4:4.14.10-7 ii libkhtml5 4:4.14.26-1 ii libkio5 4:4.14.26-1 ii libkpimidentities4 4:4.14.10-7 ii libkrosscore4 4:4.14.26-1 ii libofx6 1:0.9.10-1+b1 ii libqt4-dbus 4:4.8.7+dfsg-11 ii libqt4-declarative 4:4.8.7+dfsg-11 ii libqt4-network 4:4.8.7+dfsg-11 ii libqt4-sql 4:4.8.7+dfsg-11 ii libqt4-svg 4:4.8.7+dfsg-11 ii libqt4-xml 4:4.8.7+dfsg-11 ii libqtcore4 4:4.8.7+dfsg-11 ii libqtgui4 4:4.8.7+dfsg-11 ii libstdc++6 6.2.1-5 Versions of packages kmymoney recommends: ii gnupg-agent 2.1.16-3 pn pinentry-qt4 <none> kmymoney suggests no packages. -- no debconf information
