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
I've downgraded to Version 4.7.2, there is no issue with this version - data loaded as expected.
*** This bug has been marked as a duplicate of bug 365615 ***