Re: [GNC] how to remove sqlite lock
On 2023-02-11 12:23, Mark Hedges via gnucash-user wrote: > I seem to have a stuck lock in my SQLite GnuCash book. Every time I open > the file, it says: > > GnuCash could not obtain the lock for /Users/hedges/[...]/myfile.gnucash. > That database may be in use by another user, in which case you should not > open the database. What would you like to do? > Open Read-only | Create New File | Open Anyway | Open Folder | Quit > > I tried "Open Anyway" but it apparently does not remove the lock. "Open anyway" doesn't remove the lock, that's true. But it lets you open GnuCash, and when you subsequently close GC -- either right away or after entering some data -- GC removes the lock file at that point. Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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] how to remove sqlite lock
Ooh snap... the warning came back even on the new file that I generated by saving out to XML first. I was using 4.10. I upgraded to 4.13 and tried saving out to XML and back to SQLite3 again. It seems to work now. Mark On Sat, Feb 11, 2023 at 12:23 PM Mark Hedges wrote: > I seem to have a stuck lock in my SQLite GnuCash book. Every time I open > the file, it says: > > GnuCash could not obtain the lock for /Users/hedges/[...]/myfile.gnucash. > That database may be in use by another user, in which case you should not > open the database. What would you like to do? > Open Read-only | Create New File | Open Anyway | Open Folder | Quit > > I tried "Open Anyway" but it apparently does not remove the lock. > > Is there a way to remove locks on SQLite books? > > Saving as a new SQLite file did not work. I had to save as XML, open that > book, and save again as SQLite to get a new file that I could open without > a lock warning. > > Thanks. > Mark > ___ 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] how to remove sqlite lock
I seem to have a stuck lock in my SQLite GnuCash book. Every time I open the file, it says: GnuCash could not obtain the lock for /Users/hedges/[...]/myfile.gnucash. That database may be in use by another user, in which case you should not open the database. What would you like to do? Open Read-only | Create New File | Open Anyway | Open Folder | Quit I tried "Open Anyway" but it apparently does not remove the lock. Is there a way to remove locks on SQLite books? Saving as a new SQLite file did not work. I had to save as XML, open that book, and save again as SQLite to get a new file that I could open without a lock warning. Thanks. Mark ___ 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] Saved Report Configurations
On Sat, 11 Feb 2023 at 11:28, Mahon Finbar wrote: [...] > My issue is to establish which report is which, if possible, by > re-creating the title with the dates of the periods covered. Then I can > eliminate any dupes, etc. > Try this: 1. Open Reports -> Saved Report Configurations and select the first report. 2. If this report has the correct settings, go back to Reports -> Saved Report Configurations and click on the middle icon on the right (see attached image). You can then edit the report name to make it clear which report it is, e.g. by adding the year or time period to the report name 3. If the report doesn't have the correct settings, e.g. dates, choose the correct settings, then click on Save Config on the menu bar (not Save Config As). Then go back to Reports -> Saved Report Configurations, and click on the middle icon on right (see attached) to edit the report name 4. Then repeat the process with the next report, and so on until you have named all of the reports. 5. Then review the reports and see which ones need to be deleted David ___ 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] Saved Report Configurations
Not really; as a result of following the 'help' I now have a set of reports numbered 1 to 14, in random order, but none (except one, partially) have been retitled as the advice the help advise suggested I could. I haven't been able to identify the individual reports, except if I try to select them and see what the dates on them are. However, the first three I tried are all for the same period 2023, which I have not yet competed, obviously. My issue is to establish which report is which, if possible, by re-creating the title with the dates of the periods covered. Then I can eliminate any dupes, etc. Seems to me the process suggested is faulty, or the procedure is bugged. As I said, it isn't critical for the older reports but I would like to sort out the newer (post 2020 perhaps) ones. I was just hoping for advice, from anyone who has experience of saving reports. Barry On 10/02/2023 20:04, ed...@billiau.net wrote: On Fri, 10 Feb 2023 17:28:04 +0100 Mahon Finbar wrote: However, it doesn't seem to work, I now have a list of 'saved report configurations' from those terminating with no number at all to 21, all called profit & loss, in a sort of random order. You can delete reports that you don't want any more, is that what you want? Liz ___ 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.