I upgraded from Kubuntu 16.04 to 17.10. When I installed the 4.8.0 version that came with 17.10 and tried to connect to the DB where kmm 4.6.6 was storing my information I got the following error.
*Query error no 1064: you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near '"order" smallint unsigned not null, identifier varchar(32) not null, primary k' at line 1 qmysql: unable to execute query.* I noticed that there was a 4.8.1 version so I added the repo for that version and uninstalled 4.8.0 and installed 4.8.1. I then got a cannot open shared library libkmm_settings.so file missing error. I uninstalled 4.8.1 and proceed to to download the source code and I fired off the build for tag 4.8.1.1 using the provided instructions in README.cmake and it all compiled correctly but when I ran it I got the following error. *Cannot open file as requested. Error was: Error in function void MyMoneyStorageSql::writeFileInfo() : writing FileInfo* *Driver = QMYSQL, Host = X.X.X.X, User = kmymoney, Database = kmymoney* *Driver Error: * *Database Error No -1: * *Text: * *Error type 0* *Executed: UPDATE kmmFileInfo SET version = ?, fixLevel = ?, created = ?, lastModified = ?, baseCurrency = ?, dateRangeStart = ?, dateRangeEnd = ?, hiInstitutionId = ?, hiPayeeId = ?, hiTagId = ?, hiAccountId = ?, hiTransactionId = ?, hiScheduleId = ?, hiSecurityId = ?, hiReportId = ?, hiBudgetId = ?, hiOnlineJobId = ?, hiPayeeIdentifierId = ?, encryptData = ?, updateInProgress = ?, logonUser = ?, logonAt = ?, institutions = ?, accounts = ?, payees = ?, tags = ?, transactions = ?, splits = ?, securities = ?, prices = ?, currencies = ?, schedules = ?, reports = ?, kvps = ?, budgets = ?; * *Query error No -1: * *Error type 0* Is there something I can do to (besides reverting back to Kubuntu 16.04/KMM 4.6.6) to resolve this issue?