On 2/3/22 10:07 AM, Alan A Holmes wrote:
Hi Jeff,
Did you take a copy of the database before you upgraded to version 4.9. If so
you could take a copy of this backup and open that in version 4.9, which might
tell you if the corruption existed before upgrading to version 4.9.
Do you have anyway of finding out which version you had before version 4.9? Was
it another flatpack version, or was it the version as part of Ubuntu 20.04 LTS?
That version might still be available on your machine, or you could re-install
that version, which would allow you to look at any backup copy before upgrading
to version 4.9 in that version to see if the corruption existed.
You could also look at any/all backup copy taken automatically by version 4.9
to see if the corruption exists. This depends on how many days of backups/logs
you have specified should be kept in the settings. This might show when the
corruption first started.
If you can find a backup copy that isn't corrupted then you could start with
that copy and then either manually enter all transactions since then, or use
the log files created since then to re-apply a subset of transactions (I think
I remember a thread somewhere that said you can be selective in which
transactions to re-apply).
Alan A Holmes
-----Original Message-----
From: gnucash-user <gnucash-user-bounces+gnucash=alanaholmes.me...@gnucash.org>
On Behalf Of Jeff
Sent: 03 February 2022 07:43
To: Gnucash userlist <gnucash-user@gnucash.org>
Subject: [GNC] How to handle multiple entries of multiply reconciled entries
How I did this is beyond me, somehow I confused GNC to let it happen or had a
data corruption when the journal was improperly saved (power outage, GNC lost a
poker game, thought it was Quirken, etc). I use uncompressed XML on Ubuntu
20.04LTS.
I have discovered multiple (dozens) of transactions that are duplicates in
several registers but; reconciled to the wrong accounts. I am not sure of the
easiest and proper way to correct them.
Example of the simplest ones are: using Check 101, Cash, salary.
01/01/10 chk 101 -> Cash -> chk 101 reconciled
01/01/10 chk 101 -> salary -> salary reconciled
These are posted as 2 entirely separate transactions, in the same register, but
are supposed to be only one transaction:
01/01/10 chk 101 -> salary -> both reconciled
As a result my current balance is now off by off by over $4,000.
And the real kicker, is that these errors now go back 3 years in this journal.
I know these errors did not exist prior to FlatPak 4.9, not sure which version
I upgraded from to 4.9. Plus they would have shown up when I did reports for
taxes and income expense statements last year.
Suggestions, besides burning more midnight oil than this old man has left,
other than to delete all of them and enter all of them correctly as I find
them. I'm in tax time crunch here.
--
--JEffrey Black M.B.A.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
.
I always make a backup before doing an upgrade, unfortunately I deleted
it some time after upgrading as I believed that everything was working
as it should. I do not remember what version I used prior to FlatPak
4.9. I want to say 4.2 but I'd be lying if I said I knew that for sure.
As for the log copies I only keep 7 days worth and I have the bad habit
of running GNC multiple times on any given day. I could try loading the
oldest one and see if the problem is still there.
It may be that I got the backups mixed up while trying to build 4.9 from
source. I have yet to successfully create a version that runs.
--
--JEffrey Black M.B.A.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.