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

Eric H. Bowen eric at ehbowen.net
Sat Mar 9 12:08:43 EST 2024 

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
> *********************************************

More information about the gnucash-user mailing list