Migration of KMM 4.8 DB to 5 DB
El Cas
eaglexboy at gmail.com
Fri Aug 24 22:25:03 BST 2018
I just installed KMM from source (pull from *master* branch on *8/24/2018 @
11:06 MDT*) and when I tried to log on to my DB I am get
*Executed: SELECT ISOcode, name, type, typeString, symbol1, symbol2,
symbol3, symbolString, smallestCashFraction, smallestAccountFraction,
pricePrecision FROM kmmCurrencies ORDER BY ISOcode; Query error No 1054:
Unknown column 'pricePrecision' in 'field list' QMYSQL: Unable to execute
query*
In a previous email thread, Tony Bloomfield had mentioned that when KMM
opened a Database the Database Manager should detect the change in version
and create/delete/alter any table/columns as required, but as you can see
from the error above it's not doing it. Is there an update SQL script I can
run to update the schema for my 4.8 DB to work with 5.0?
According to the the kmmfileinfo table it says I am using DB version *12* if
that helps determine what script(s) I need to run.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20180824/ccf5e9a5/attachment.html>
More information about the KMyMoney-devel
mailing list