Bug 366132

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

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 ***