[Kmymoney-devel] [kmymoney4] [Bug 349425] New: data problem with kmmcurrencies table.

[John McKown]

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 at kde.org
          Reporter: john.archie.mckown at 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.