https://bugs.kde.org/show_bug.cgi?id=365615
Bug ID: 365615
Summary: SQL syntax error reported opening MySQL database
Product: kmymoney4
Version: 4.8.0
Platform: openSUSE RPMs
OS: Linux
Status: UNCONFIRMED
Severity: grave
Priority: NOR
Component: database
Assignee: kmymoney-devel@kde.org
Reporter: a...@fudokai.org.uk
I'm running KMyMoney using a MySQL database on another server on launching I
get a reported error ...
Cannot open file as requested. Error was: Error in function void
MyMoneyStorageSql::createTable(const MyMoneyDbTable&, int) : creating
table/index kmmAccountsPayeeIdentifier
Driver = QMYSQL, Host = zanshin.fudokai.lan, User = alan, Database = KMyMoney
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed:
Query error No 1064: You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use
near '"order" smallint unsigned NOT NULL, identifierId varchar(32) NOT NULL,
PRIMARY K' at line 1 QMYSQL: Unable to execute query
Error type 2
Reproducible: Always
--
You are receiving this mail because:
You are the assignee for the bug.
