https://bugs.kde.org/show_bug.cgi?id=517246

            Bug ID: 517246
           Summary: Failed to open database kmymoney version 5.1.3 to
                    5.2.2.
    Classification: Applications
           Product: kmymoney
      Version First 5.2.2
       Reported In:
          Platform: Microsoft Windows
                OS: Microsoft Windows
            Status: REPORTED
          Severity: critical
          Priority: NOR
         Component: database
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

SOFTWARE/OS VERSIONS
Windows: 11

I'm using kmymoney 5.1.3 and have a database that's several years old. After
installing version 5.2.2, I can't open my database; I get an error message and
kmymoney closes.

I tried to resolve the compatibility issue by converting my file from ".kmy" to
".gz" to ".xml".

Version 5.1.3 doesn't give any errors; the test returns : "Finished: data is
consistent." 
When I open it with version 5.2.2, nothing appears except this error message: 

"Corrupted data: transaction 'T000000000000000248', split 'S0002' references
unknown account id 'AStd::Equity'
C:\builds\office\kmymoney\src\kmymoney\plugins\xml\mymoneyxmlreader.cpp:775"

I understand that "AStd::Equity" is not a real account and that version 5.2.2
no longer uses it, which partly explains the crashes between versions 5.1.3 and
5.2.2: my database contains many accounts, both open and closed.

So I tried saving my database as SQLite from version 5.1.3 (where everything
works) to open it with version 5.2.2.

The file opens this time, but with different errors:

* Problems with transactions * Sum of splits in transaction
'T000000000000000248' posted on 16/07/2013 is not zero. Account: Asset: La
poste LEP JP, Amount: €7,700.00 

* Sum of splits in transaction 'T000000000000000249' posted on 16/07/2013 is
not zero. Account: Asset:La poste Livret A Aurore, Amount: €90.53 

* Sum of splits in transaction 'T000000000000000250' posted on 07/16/2013 is
not zero. Account: Asset:La poste Livret A JP, Amount: €9,119.18 

* Sum of splits in transaction 'T000000000000000251' posted on 07/16/2013 is
not zero. Account: Asset:La poste 1er PEL Aurore, Amount: €33,685.77 

* Sum of splits in transaction 'T000000000000000252' posted on 16/07/2013 is
not zero. Account: Asset: La Poste CCP Joint, Amount: €2,398.47 

Finished: 0 problems corrected. 5 problems still present.

I took the necessary steps to correct these 5 errors, ran a consistency check
which showed 0 errors, saved the file, and when I try to reopen it with either
version 5.2.2 or 5.1.3, I get: 

Unknown account
C:\builds\office\kmymoney\src\kmymoney\mymoney\mymoneyfile.cpp:1666

The file won't open at all.

I think I'll be stuck with version 5.1.3 for a long time unless a database
migration solution to 5.2.2 is provided and, more importantly, an effective
one.

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to