[kmymoney] [Bug 509104] New: Database-Error when deleting unused Payees

[Fabiano Caruana]

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

            Bug ID: 509104
           Summary: Database-Error when deleting unused Payees
    Classification: Applications
           Product: kmymoney
      Version First 5.2.1
       Reported In:
          Platform: openSUSE
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: database
          Assignee: kmymoney-devel at kde.org
          Reporter: bugzilla at lubich.com
  Target Milestone: ---

Created attachment 184708
  --> https://bugs.kde.org/attachment.cgi?id=184708&action=edit
Screenshot Error

SOFTWARE/OS VERSIONS

KMyMoney 5.2.1 and 5.1.3
Linux OpenSuse 16.0 and 15.6

Hello KMyMoney Team,

Serious error when using an SQLite database (possibly also MySQL).
If I try to delete payees with the status "unused," the stored account numbers
are deleted for all payees.
I can also save the database (without an error message).
That's not enough. From now on, I can no longer save anything to the database.
Error message: payeeIdentifier with id 'IDENT00005' not found ... (see
screenshot)
All records in the "kmmPayeeIdentifier" table have been deleted.
All records are still present in the "kmmPayeesPayeeIdentifier" table.
This problem also occurs with KMyMoney 5.1.3.
But this wasn't always the case, and I can't determine when the problem
started.

The problem only affects the database. When used with the .kmy file, everything
works normally, and the account numbers are not deleted.

FYI: I work with SQLCipher with encryption, but I've also written my own
database analyses in SQL, so I want to continue working with databases.
Workaround for me:
- Save in .kmy file
- Delete payees with "unused" status
- Save changed data in a new database.

Regards
Udo

It looks like Bug 413535 https://bugs.kde.org/show_bug.cgi?id=413535 ?

-- 
You are receiving this mail because:
You are the assignee for the bug.