[GNC] gnucash-user Digest, Vol 252, Issue 21

Sat Mar 9 15:37:26 EST 2024

Cool, glad you got it sorted.

Cheers David H.

On Sun, 10 Mar 2024 at 03:09, Eric H. Bowen via gnucash-user <
gnucash-user at gnucash.org> wrote:

> David/john:
>
> Thanks for the helpful replies. After you mentioned it, I remembered the
> auto-history version save of my NAS-based cloud drive. Upon checking in
> there, I found two versions which had saved within two seconds of each
> other at the time I attempted to switch books. The second one, which
> Windows saw, was the corrupted file but the two-seconds-earlier version
> was uncorrupted and loaded properly. I flushed the corrupted version and
> now I'm back in business. Thanks again----Eric.
>
> On 3/9/2024 9:25 AM, gnucash-user-request at gnucash.org wrote:
> > Send gnucash-user mailing list submissions to
> >       gnucash-user at gnucash.org
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Sat, 9 Mar 2024 07:43:24 +1000
> > From: David H <hellvee at gmail.com>
> > To: "Eric H. Bowen" <eric at ehbowen.net>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
> >       (Bug 645216)
> > Message-ID:
> >       <
> CA+5xQdq5tyik_Yhk-b3qpgdRXZk-WOcLQ9mvJ-s9p5qgYvKcng at mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Eric,
> >
> > Are you sure you haven't got a more recent backup?  I have multiple
> backups
> > (currently 77 - e.g. <gnucash file name>.gnucash.20240208183810.gnucash)
> in
> > the folder where my usual gnucash data file lives from the last time I
> > opened it - you should be able to open the one with the most recent date
> > and time stamp in the name and then save as you LLC file proper. .  It
> > seems you are opening this file directly in the cloud - I've never been a
> > fan of that ? I always copy my file to my local pc (1 of about 5 running
> > Win10/11, Ubuntu, MacOS) using FreeFileSync before I open it and then
> copy
> > it back when I'm done which works well for me.  Hope you can get it
> sorted.
> >
> > Cheers David H.
> >
> >
> > On Fri, 8 Mar 2024 at 23:59, Eric H. Bowen via gnucash-user <
> > gnucash-user at gnucash.org> wrote:
> >
> >> I use two separate GnuCash books, one for my personal funds and another
> >> for my LLC. These files are saved on a cloud drive and I access them
> >> from a few different computers. Some of the computers run Windows 10,
> >> while some run Ubuntu Studio 22.04 LTS. The computer on which this first
> >> happened was running Windows 10 and GnuCash 5.4+ with sqlite backend,
> >> but all computers are now responding the same way.
> >>
> >> The day before yesterday I was updating and making some entries in the
> >> book for my LLC; GnuCash was working normally. Then, with the work
> >> completed, I attempted to switch from the LLC book to my personal book.
> >> However, apparently the file was still open on a remote computer because
> >> I received the error message that the .lock file could not be received.
> >> I elected to close the file and exit GnuCash. Well and good. When I got
> >> home that evening I closed the open instance of GnuCash running the
> >> personal book. Well and good.
> >>
> >> This morning I reopened the personal book and it opened and operated
> >> normally. Okay so far. Then, I closed it and attempted to open the book
> >> for the LLC. It would not open; I got a pop-up error message reading,
> >> "GnuCash could not complete a critical test for the presence of a bug in
> >> the "libdi" library. This may be caused by a permissions
> >> misconfiguration of your SQL database. Please see
> >> https://bugs.gnucash.org/show_bug.cgi?id=645216 for more information."
> >>
> >> I went to the bug tracker website, found the entry, and attempted to
> >> follow the procedure which others said worked for them, of making a copy
> >> of the GnuCash file and opening/closing it. However, the copied file(s)
> >> were also corrupt and would not open. I do have a backup, but it's a few
> >> weeks old and I'd have to reconstruct the invoices and bills since then.
> >> Not a major undertaking, but if possible I'd like to recover this file.
> >> The personal book, by the way, continues to work perfectly. Thanks for
> >> any assistance----Eric.
> >>
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> > ------------------------------
> >
> > Message: 9
> > Date: Sat, 9 Mar 2024 16:17:45 +0100
> > From: john <jralls at ceridwen.us>
> > To: David H <hellvee at gmail.com>
> > Cc: "Eric H. Bowen" <eric at ehbowen.net>, gnucash-user at gnucash.org
> > Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
> >       (Bug 645216)
> > Message-ID: <B3540E18-38B3-4851-BA26-ADF9D83A14B7 at ceridwen.us>
> > Content-Type: text/plain;     charset=us-ascii
> >
> > Are you using the SQLite3 backend? If so and it's really corrupted see
> https://www.sqlite.org/recovery.html. Good luck.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> >> On Mar 8, 2024, at 22:43, David H <hellvee at gmail.com> wrote:
> >>
> >> Eric,
> >>
> >> Are you sure you haven't got a more recent backup?  I have multiple
> backups
> >> (currently 77 - e.g. <gnucash file
> name>.gnucash.20240208183810.gnucash) in
> >> the folder where my usual gnucash data file lives from the last time I
> >> opened it - you should be able to open the one with the most recent date
> >> and time stamp in the name and then save as you LLC file proper. .  It
> >> seems you are opening this file directly in the cloud - I've never been
> a
> >> fan of that ? I always copy my file to my local pc (1 of about 5 running
> >> Win10/11, Ubuntu, MacOS) using FreeFileSync before I open it and then
> copy
> >> it back when I'm done which works well for me.  Hope you can get it
> sorted.
> >>
> >> Cheers David H.
> >>
> >>
> >> On Fri, 8 Mar 2024 at 23:59, Eric H. Bowen via gnucash-user <
> >> gnucash-user at gnucash.org> wrote:
> >>
> >>> I use two separate GnuCash books, one for my personal funds and another
> >>> for my LLC. These files are saved on a cloud drive and I access them
> >>> from a few different computers. Some of the computers run Windows 10,
> >>> while some run Ubuntu Studio 22.04 LTS. The computer on which this
> first
> >>> happened was running Windows 10 and GnuCash 5.4+ with sqlite backend,
> >>> but all computers are now responding the same way.
> >>>
> >>> The day before yesterday I was updating and making some entries in the
> >>> book for my LLC; GnuCash was working normally. Then, with the work
> >>> completed, I attempted to switch from the LLC book to my personal book.
> >>> However, apparently the file was still open on a remote computer
> because
> >>> I received the error message that the .lock file could not be received.
> >>> I elected to close the file and exit GnuCash. Well and good. When I got
> >>> home that evening I closed the open instance of GnuCash running the
> >>> personal book. Well and good.
> >>>
> >>> This morning I reopened the personal book and it opened and operated
> >>> normally. Okay so far. Then, I closed it and attempted to open the book
> >>> for the LLC. It would not open; I got a pop-up error message reading,
> >>> "GnuCash could not complete a critical test for the presence of a bug
> in
> >>> the "libdi" library. This may be caused by a permissions
> >>> misconfiguration of your SQL database. Please see
> >>> https://bugs.gnucash.org/show_bug.cgi?id=645216 for more information."
> >>>
> >>> I went to the bug tracker website, found the entry, and attempted to
> >>> follow the procedure which others said worked for them, of making a
> copy
> >>> of the GnuCash file and opening/closing it. However, the copied file(s)
> >>> were also corrupt and would not open. I do have a backup, but it's a
> few
> >>> weeks old and I'd have to reconstruct the invoices and bills since
> then.
> >>> Not a major undertaking, but if possible I'd like to recover this file.
> >>> The personal book, by the way, continues to work perfectly. Thanks for
> >>> any assistance----Eric.
> >>>
> >>>
> >>> _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> >
> > ------------------------------
> >
> > Message: 10
> > Date: Sat, 9 Mar 2024 16:25:37 +0100
> > From: john <jralls at ceridwen.us>
> > To: Jack Slater <theilliniguy at gmail.com>
> > Cc: David H <hellvee at gmail.com>, Gnucash Users
> >       <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] Maddening!!!!!!!!
> > Message-ID: <3126FE1B-2EF7-4C4B-B5B0-F1F871DB7967 at ceridwen.us>
> > Content-Type: text/plain;     charset=utf-8
> >
> > No, that's a re-bundling of GnuCash 5.5 for Windows with a rebuilt
> WebKitGtk so that it doesn't crash when you try to run a business or chart
> report. There are no changes to GnuCash itself.
> >
> > The fix for the left-over splits from editing an auto-completed
> transaction will be in GnuCash 5.6. Flatpak and Windows users can get it
> from a nightly build, otherwise you have to wait a few weeks.
> >
> > But we now know that it's caused by a dangling pointer in the account's
> split list from a second run of autocomplete. You can safely ignore
> it--meaning don't check it when reconciling--and it will go away when you
> end the session.
> >
> > Regards,
> > John Ralls
> >
> >> On Mar 9, 2024, at 02:00, Jack Slater <theilliniguy at gmail.com> wrote:
> >>
> >> Oh ok. Happy to. I guess I was expecting a 5.51 or something to
> >> differentiate the releases.
> >>
> >> On Fri, Mar 8, 2024 at 4:09?PM David H <hellvee at gmail.com> wrote:
> >>
> >>> Jack,
> >>>
> >>> John Ralls released an updated version of 5.5 on 21 Feb -
> >>>
> https://lists.gnucash.org/pipermail/gnucash-user/2024-February/110886.html
> >>> - I assume if you re-download the Windows version at Gncash.org you
> will
> >>> pick it up ?
> >>>
> >>> Cheers David H.
> >>>
> >>> On Sat, 9 Mar 2024 at 04:57, Jack Slater <theilliniguy at gmail.com>
> wrote:
> >>>
> >>>> Revisiting the bug log (after another rogue transaction and crash
> today)
> >>>> and I see John's notes about fixing but I'm guessing it's not in 5.5?
> >>>> That's what I'm running and all I see on the web site.
> >>>>
> >>>> On Thu, Feb 8, 2024 at 11:12?AM Patrick James <
> patrickjames14 at comcast.net
> >>>> wrote:
> >>>>
> >>>>> Save, Exit, and Reload will clear the rouge transactions.
> >>>>>
> >>>>>
> >>>>>> On 02/08/2024 8:54 AM PST Jack Slater <theilliniguy at gmail.com>
> wrote:
> >>>>>>
> >>>>>>
> >>>>>> Anything coming soon to fix this?
> >>>>>>
> >>>>>> On Thu, Jan 25, 2024 at 12:26?PM Patrick James <
> >>>>> patrickjames14 at comcast.net mailto:patrickjames14 at comcast.net> wrote:
> >>>>>>> This is bug 799093, and John Ralls has not asked additional
> >>>> questions
> >>>>> after I was able to reliably reproduce (part of) the issue, so,
> >>>> hopefully,
> >>>>> there is sufficient information to find the bug.
> >>>>>>> https://bugs.gnucash.org/show_bug.cgi?id=799093
> >>>>>>>
> >>>>>>> s by using Reply-To-List or Reply-All.
> >>>>>>>
> >>>>> _______________________________________________
> >>>>> gnucash-user mailing list
> >>>>> gnucash-user at gnucash.org
> >>>>> To update your subscription preferences or to unsubscribe:
> >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>>> -----
> >>>>> Please remember to CC this list on all your replies.
> >>>>> You can do this by using Reply-To-List or Reply-All.
> >>>>>
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> -----
> >>>> Please remember to CC this list on all your replies.
> >>>> You can do this by using Reply-To-List or Reply-All.
> >>>>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> >
> > ------------------------------
> >
> > Subject: Digest Footer
> >
> > _______________________________________________
> >
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
> > ------------------------------
> >
> > End of gnucash-user Digest, Vol 252, Issue 21
> > *********************************************
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>