Re: [GNC] gnucash-user Digest, Vol 252, Issue 21
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@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 againEric. > > On 3/9/2024 9:25 AM, gnucash-user-requ...@gnucash.org wrote: > > 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 > > To: "Eric H. Bowen" > > 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.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 assistanceEric. > >> > >> > >> ___ > >> 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 > > To: David H > > Cc: "Eric H. Bowen" , gnucash-user@gnucash.org > > Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books > > (Bug 645216) > > Message-ID: > > Content-Type: text/plain; charset=us-ascii > > > > Are you using the SQLite3 backend? If so and it's really corrupted see >
Re: [GNC] gnucash-user Digest, Vol 252, Issue 21
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 againEric. On 3/9/2024 9:25 AM, gnucash-user-requ...@gnucash.org wrote: 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 To: "Eric H. Bowen" Cc: gnucash-user@gnucash.org Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216) Message-ID: 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.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 assistanceEric. ___ 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 To: David H Cc: "Eric H. Bowen" , gnucash-user@gnucash.org Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216) Message-ID: 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 wrote: Eric, Are you sure you haven't got a more recent backup? I have multiple backups (currently 77 - e.g. .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
