How do stupid people recover from removed transactions?

[Gerben321]

Tonight I was a bit stupid and accidentally removed my mortgage from Firefly. I had it entered under liabilities, but the money left calculation was off, so I thought it was useless. I then decided to remove it, and clicked remove when I saw the warning too late.

I went in the database and removed the deleted date from all those journal_meta and transactions entries. However my bank account still showed a wrong (way too high) number. Couldn't find a way to solve that, but I got it working when I created and removed a fake transaction. My account is now good again.

However, those transactions are not showing again. I guess they're linked to something that's not right? How do I solve that?

Thanks for helping a fool.

Edit: I removed the deleted_at for the accounts entry, but no luck still.
Edit 2: Also removed the deleted_at in the transaction_journals table, still nothing in the frontend.
Edit 3: Removing the deleted_at in the transaction_groups did the trick it seems! This structure looks really complicated, but I'm happy I fixed it. Hopefully it is ever useful for other fools like me 😝