[kmymoney4] [Bug 365615] New: SQL syntax error reported opening MySQL database

[Alan Prescott via KDE Bugzilla]

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 at kde.org
          Reporter: ajp at 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.