Database Crash (SqliteException: 787) When Archiving/Deleting Unused Accounts with Existing Transaction History
complete
U
Umesh Napit
I am reporting a database constraint bug encountered in the Account Details section of the latest early access build.
The Problem:
During the initial onboarding/SMS scanning setup, I opted to sync an older, currently unused bank account because I wanted to preserve its historical transaction records within the app. However, when attempting to remove or unlink this specific account from the 'Accounts' dashboard, the action fails and triggers a database exception.
Error Encountered:
Exception: SqliteException(787): while executing statement. FOREIGN KEY constraint failed. constraint failed (code...)
Feature/Fix Suggestions:
Implement an "Archive/Hide" Feature: Instead of a hard delete that forces the deletion of historical data, please provide an option to "Hide from Dashboard" or "Archive Account". This will keep the balance hidden from active views while preserving the underlying transaction history intact.
Graceful Exception Handling: Update the database layer to handle this constraint gracefully instead of exposing raw SQLite exceptions via toast/banners to the end-user.
Looking forward to this stability fix in the next beta release.
Best regards,
Photo Viewer
View photos in a modal
Chetan Reddy Piduru
updated the status to
complete
Fixed via update
Chetan Reddy Piduru
Hi Umesh, we pushed an update. Can you please check the delete/archive (now available in account details page - 3 dot menu) after updating app to latest version?
U
Umesh Napit
Hi Chetan,
Wow, I am absolutely blown away by your speed! Honestly, I’ve never seen any developer respond, fix a bug, and roll out a brand new feature this fast.
I just updated the app and tested the 'Archive Account' feature along with the 'Show Archived Accounts' toggle in the view settings. It works beautifully and completely resolves the database constraint issue while keeping the historical data intact.
Huge respect to you for listening to user feedback so seriously and implementing it so perfectly. Your dedication to MoneySplit is amazing. Keep up the phenomenal work! ⭐⭐⭐⭐⭐
Chetan Reddy Piduru
updated the status to
in progress
Chetan Reddy Piduru
updated the status to
under review
Chetan Reddy Piduru
This is a bug. Acknowledged and we will fix in next update. Thanks for reporting
U
Umesh Napit
Thank you for the update, Chetan. I appreciate your quick response and acknowledgment of the issue. I will look forward to the stable release of this feature. Keep up the great work