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@kde.org
Reporter: bugzi...@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.
