Bug 366132

Summary: Unable to open db (mysql)
Product: [Applications] kmymoney Reporter: art <art2crazy>
Component: databaseAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED DUPLICATE    
Severity: grave CC: christian-david
Priority: NOR    
Version: 4.8.0   
Target Milestone: ---   
Platform: openSUSE   
OS: Linux   
Latest Commit: Version Fixed In:

Description art 2016-07-26 13:52:38 UTC 
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
Comment 1 art 2016-07-26 14:04:52 UTC 
I've downgraded to Version 4.7.2, there is no issue with this version - data loaded as expected.
Comment 2 Thomas Baumgart 2016-07-27 14:48:14 UTC 

*** This bug has been marked as a duplicate of bug 365615 ***