Error Connecting to MySQL DB 4.8.1.1

[Tony Bloomfield]

The problem with the keyword 'order' is that, although it has been
escaped, the character used is a double-quote. By default, Mysql doesn't
recognize this; it expects a backtick as the escape character.
 If you have access to the Mysql configuration, this can be fixed by the
addition of the line

sql_mode = 'ANSI_QUOTES'

to the [mysqld] section of the configuration file (in ubuntu, at
/etc/mysql/mysql.conf.d/mysql.cnf), and restarting the mysql server.
With this fix, I was able to load my 4.6 anonymized file under 4.8.0 in
about 3-4 minutes.

However, I decided to build 4.8.1.1 from source and try that. I got the
following error loading my 4.6 file:
-----------------------------------------------------------------------------------------------------
Error in function bool MyMoneyStorageSql::alterTable(const
MyMoneyDbTable&, int) : Error inserting into new table kmmFileInfo
Driver = QMYSQL, Host = localhost, User = tonyb, Database = Anonkmm
Driver Error:
Database Error No -1:
Text: 
Error type 0
Executed: INSERT INTO kmmFileInfo
 (version, created, lastModified, baseCurrency, institutions, accounts,
payees, tags, transactions, splits, securities, prices, currencies,
schedules, reports, kvps, dateRangeStart, dateRangeEnd, hiInstitutionId,
hiPayeeId, hiTagId, hiAccountId, hiTransactionId, hiScheduleId,
hiSecurityId, hiReportId, encryptData, updateInProgress, budgets,
hiBudgetId, '', '', logonUser, logonAt, fixLevel)
 SELECT version, created, lastModified, baseCurrency, institutions,
accounts, payees, '', transactions, splits, securities, prices,
currencies, schedules, reports, kvps, dateRangeStart, dateRangeEnd,
hiInstitutionId, hiPayeeId, '', hiAccountId, hiTransactionId,
hiScheduleId, hiSecurityId, hiReportId, encryptData, updateInProgress,
budgets, hiBudgetId, '', '', logonUser, logonAt, fixLevel
FROM kmmtmpFileInfo;

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 ''', '', logonUser, logonAt, fixLevel) SELECT
version, created, lastModified, bas' at line 1 QMYSQL: Unable to execute
query
Error type 2

--------------------------------------------------------------------------------------------

This looks pretty bad!  I downloaded the source from one of the mirrors
on this page:

https://download.kde.org/stable/kmymoney/4.8.1.1/src/kmymoney-4.8.1.1.tar.xz.mirrorlist

If someone can confirm that is the latest, I'll look into the problem if
you wish.

-- 

Cheers
TonyB