Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)
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 > 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. >> > ___ > 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.
Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)
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. > ___ 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.
[GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)
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.
