[Pkg-kde-extras] Bug#850085: kmymoney: MySQL backend not working

[Jarek Kamiński]

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