From kde-bugs-dist Sun Jul 31 19:39:51 2016 From: Christian David via KDE Bugzilla Date: Sun, 31 Jul 2016 19:39:51 +0000 To: kde-bugs-dist Subject: [kmymoney4] [Bug 365615] SQL syntax error reported opening MySQL database Message-Id: X-MARC-Message: https://marc.info/?l=kde-bugs-dist&m=146999399628855 https://bugs.kde.org/show_bug.cgi?id=3D365615 Christian David changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Latest Commit| |http://commits.kde.org/kmym | |oney/c0f003134059354e2bc2b1 | |9ffa1b3ca7a98cbb19 Version Fixed In| |5.0 Status|CONFIRMED |RESOLVED --- Comment #4 from Christian David --- Git commit c0f003134059354e2bc2b19ffa1b3ca7a98cbb19 by Christian D=C3=A1vid. Committed on 31/07/2016 at 19:31. Pushed by christiand into branch 'master'. Renamed SQL column "order" to "userOrder" in some tables The name "order" is a reserved keyword. It can be used as identifier but only if it is escaped. Unfortunately the escape sequence is database dependent. This patch is untested as another bug prevents me from opening a database. Scince this fix is kind of urgent, I publish it anyway. The port to 4.8 should be straight forward. FIXED-IN: 5.0 M +3 -3 kmymoney/mymoney/storage/mymoneydbdef.cpp M +3 -3 kmymoney/mymoney/storage/mymoneystoragesql.cpp http://commits.kde.org/kmymoney/c0f003134059354e2bc2b19ffa1b3ca7a98cbb19 --=20 You are receiving this mail because: You are watching all bug changes.=