Error Connecting to MySQL DB 4.8.1.1

[El Cas]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20180224/54d29b92/attachment.html>