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-de...@kde.org
Reporter: art2cr...@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 watching all bug changes.
