https://bugs.kde.org/show_bug.cgi?id=349425
Bug ID: 349425
Summary: data problem with kmmcurrencies table.
Product: kmymoney4
Version: 4.7.1
Platform: Fedora RPMs
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: database
Assignee: kmymoney-devel@kde.org
Reporter: john.archie.mck...@gmail.com
Using PostgreSQL 9.4.3 on Fedora 22, x86_64, I had a problem with the "Save as
database" function. There were two (or three?) different problems with the data
in KMyMoney as distributed in Fedora and the SQL definition of the
kmmcurrencies table. The first was that the isocode in that table is defined as
"char(3)", but there are two currencies whose codes are more than three
characters in length: Bitcoin (code is "bitcoin") and the "Dow Jones Industrial
Average (DJIA)" whose code is "DJIA". I "patcheded" this by changing the column
definition to "text". The other data problem is the "symbol1" fields in a
"smallint" and the data value for the "Iranian Rial" is 65020. I "patched" this
by making symbol1 an "int" instead. I also changed symbol2 and symbol3 in the
same way, just to be "safe". After making these changes to the DDL, I was able
to successfully use the "Save as database" function. I am also able to use this
database with no problems. At least for the last 3 minutes, that it <grin>. In
any case, I don't know if this is a problem with the SQL DDL or a problem with
the data.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
