[kmymoney4] [Bug 366132] New: Unable to open db (mysql)

[art via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=366132

            Bug ID: 366132
           Summary: Unable to open db (mysql)
           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: art2crazy at gmail.com

Following error pops up on startup and application won't load data. Error
indicates syntax issue.

Cannot open file as requested. Error was: Error in function void
MyMoneyStorageSql::createTable(const MyMoneyDbTable&, int) : creating
table/index kmmAccountsPayeeIdentifier
Driver = QMYSQL, Host = localhost, User = ########## 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

Steps to Reproduce:
1. Open application
2.
3.

Actual Results:  
Error message pops up

Expected Results:  
Application should load the data

-- 
You are receiving this mail because:
You are the assignee for the bug.