Re: [GNC] Crash on account delete

[Bob Brush]

My best memory is to make sure the backend is installed and save as, I don’t 
think it’ll let you unless it’s working.

Sometimes a crash can be hard to pin down, the worst we ever had was pressing 
the caps lock, that’s not even a button we use,  but it occasionally is pressed 
accidentally.  Our solution was to disable the button, not sure why or how it 
would crash gnucash, or even if it was a Linux issue or a gnucash issue, but we 
thought it was so many things before we figured it out.  Using the database was 
a lifesaver, even with a short save interval too much data can get lost.

Bob

> On Jan 1, 2023, at 8:01 PM, Xe Roy  wrote:
> 
> Thanks.
> I'll go with MySQL.
> Is there anything I need to do to force GnuCash to use MySQL other than 
> simply do a SAVE AS to MySQL?
> 
> 
> Sent from Outlook
> 
> 
> From: gnucash-user  on 
> behalf of Adrien Monteleone 
> Sent: Sunday, January 1, 2023 3:50 PM
> To: gnucash-u...@lists.gnucash.org 
> Subject: Re: [GNC] Crash on account delete
> 
>> On 1/1/23 6:36 PM, Xe Roy wrote:
>> I have the latest version 4.13 downloaded yesterday running on Windows 11 on 
>> AMD Ryzen 9 5950x.
> 
> Thanks for the clarification, and good to know you are up to date.
> 
>> I can't remember if the account I was trying to delete was the placeholder 
>> or the subaccount.
> 
> That makes it harder to try to duplicate, and it might be important, but
> 'til then...
> 
>> There were no transactions in the account or the subaccount.
> Good to know. There otherwise shouldn't have been a loss of data, except...
> 
>> When I re-ran GnuCash I got the UNABLE TO OBTAIN LOCK error.
>> The only option that worked was to ignore the error.
> Usually the case after a crash, nothing out of the ordinary here,
> 
>> The lost transactions were in other accounts.
>> I assume that when the program crashed, I lost everything since the last 
>> automatic save.
> Highly likely.
> 
> Investigate your auto-save interval in the meantime. Maybe a shorter one
> will help, or else:
> 
> Make a copy of your file and do some tests.
> 
> Recreate the accounts you desired to delete.
> 
> Do a manual save.
> 
> Delete the desired account(s)
> 
> What happens?
> 
> If you reproduce the crash, that's technically a good thing, because
> you've not only identified a problem, you can reproduce it so the
> developers can too, and most likely fix it. (the hard to reproduce stuff
> is the most difficult to fix, because it can be nearly impossible to
> figure out what the cause)
> 
> If all goes as expected, then I'd chalk it up to something weird. Not
> necessarily 'not a bug' but not quite yet identifiable.
> 
> -
> Here's where one of the benefits of the various SQL backends kicks in,
> as David H. mentioned : instant auto-save.
> 
> If you get a crash using one of them, you *may* only loose data pending
> to be saved, not other transactions already committed. With the XML
> format, you'll lose anything within the time window of your auto-save
> preference.
> 
> Regards,
> Adrien
> 
> ___
> 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] Help: How to set the default report stylesheet

[Bob Brush]

A common workaround for default style sheet is to save a new one as the
name "Default", but it seems to behave differently than I would think
in this case:
On the top menubar select "Edit" >  "Style Sheets" bringing up a
"Select HTML Style Sheet" DialogClick the "New" button, and type
"Default" in the name field, select "CSS" from the template pick list,
and click "OK"Now you have two "Default" in the list, so delete the old
one.  When printing (Ctl+P or whatever) it will automatically pick up
the new style sheet.
The thing I noticed is this doesn't work, the new "Default" is based on
"Plain" not "CSS" (bug?)
Something that worked for me was to directly edit the "stylesheets-2.0" 
file with GnuCash closed, then open GnuCash.  This is probably not the
right way, and it seems that now my changes to the "Select HTML Style
Sheet" Dialog don't stick when closing and reopening my GnuCash, until
I can figure out why it might be best to avoid. But just in case..
I'm using Linux Mint, so the storage location may be different (
https://wiki.gnucash.org/wiki/Configuration_Locations) in a different
OS, but here the file in question is in my home directory
~/.local/share/gnucash/stylesheets-2.0"I closed GnuCash and then opened
it in a text editor and changed the words "CSS-based stylesheet
(experimental)" to "Default" and then changed the other instance of
"Default" to "Test".  After opening GnuCash it was my default
stylesheet.
Bob

On Sat, 2021-06-26 at 13:32 -0400, James Bicknell wrote:
> I've been wondering how to do this for some time, now:
> When I print a report, I much prefer the CSS Stylesheet
> (experimental)option for all the reports I use.
> I can't seem to find any way to make that the default so I don't have
> tochange every report I run.
> Exception: saved reports have that set before I save them, so I don't
> haveto "fix" them.
> Example: Pull up an invoice -> print invoice -> scowl in disgust at
> theformat -> options -> General -> Stylesheet -> select CSS-based
> stylesheet(experimental) -> Apply/OK -> much better.
> Any way to eliminate all that select-trauma?
> [image: image.png]Just in case the image above doesn't work:
> GnuCashVersion: 4.2Build ID: 4.2+(2020-09-26)Finance::Quote: -
> OS:NAME="Ubuntu"VERSION="20.04.2 LTS (Focal
> Fossa)"ID=ubuntuID_LIKE=debianFrank
> Bicknell___gnucash-user
> mailing listgnucash-u...@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.--
> ---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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Default terms

[Bob Brush]

Is there a way to make new customers or vendors automatically have terms set to 
a default?  And is there a way to set all existing customers to a default terms?

Thanks, Bob

Raleigh Tile of Beckley ** West Virginia
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.