Bug 366132 - Unable to open db (mysql)
Summary: Unable to open db (mysql)
Status: RESOLVED DUPLICATE of bug 365615
Alias: None
Product: kmymoney
Classification: Applications
Component: database (show other bugs)
Version: 4.8.0
Platform: openSUSE Linux
: NOR grave
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-26 13:52 UTC by art
Modified: 2016-07-27 14:48 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***