Restoring deleted transactions

[nmiletic]

Hello,

I've restored accidentaly deleted transfers using following procedure:

UPDATE transaction_journals
SET deleted_at = NULL
WHERE deleted_at IS NOT NULL
AND description LIKE '%XXX%';

UPDATE transaction_groups
SET deleted_at = NULL
WHERE id IN (
    SELECT transaction_group_id
    FROM transaction_journals
    WHERE deleted_at IS NOT NULL
    AND description LIKE '%XXX%'
);

UPDATE transactions
SET deleted_at = NULL
WHERE transaction_journal_id IN (
    SELECT id
    FROM transaction_journals
    WHERE deleted_at IS NOT NULL
    AND description LIKE '%XXX%'
);

I can see the transfers again in the UI but 'Current balance' in Accounts > Asset Accounts is not updated. If I click on the account 'Chart for all transactions for account' has correct value for both accounts. I searched the database for the wrong values but could not find them so I assume that Current balance is calculated. Can not figure out why value is wrong.

Thanks!
Nemanja

[nmiletic]

went to /flush and it is fixed