Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org
----------------------------------------------------------------------
Message: 1
Date: Sat, 9 Mar 2024 07:43:24 +1000
From: David H <hell...@gmail.com>
To: "Eric H. Bowen" <e...@ehbowen.net>
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
(Bug 645216)
Message-ID:
<ca+5xqdq5tyik_yhk-b3qpgdrxzk-woclq9mvj-s9p5qgyvk...@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@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@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 <jra...@ceridwen.us>
To: David H <hell...@gmail.com>
Cc: "Eric H. Bowen" <e...@ehbowen.net>, gnucash-user@gnucash.org
Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
(Bug 645216)
Message-ID: <b3540e18-38b3-4851-ba26-adf9d83a1...@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 <hell...@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@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@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@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 <jra...@ceridwen.us>
To: Jack Slater <theillini...@gmail.com>
Cc: David H <hell...@gmail.com>, Gnucash Users
<gnucash-user@gnucash.org>
Subject: Re: [GNC] Maddening!!!!!!!!
Message-ID: <3126fe1b-2ef7-4c4b-b5b0-f1f871db7...@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 <theillini...@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 <hell...@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 <theillini...@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 <patrickjame...@comcast.net
wrote:
Save, Exit, and Reload will clear the rouge transactions.
On 02/08/2024 8:54 AM PST Jack Slater <theillini...@gmail.com> wrote:
Anything coming soon to fix this?
On Thu, Jan 25, 2024 at 12:26?PM Patrick James <
patrickjame...@comcast.net mailto:patrickjame...@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@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@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@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@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
*********************************************
