Re: MySQL Server connection timeout or keep-alive

On 2 April 2018 at 22:28, John Ralls wrote: > > >> On Apr 2, 2018, at 8:39 AM, Paul Neuwirth wrote: >> >> Hello, >> is it possible to change somewhere the connection timeout to a MySQL >> server on the client side? >> Or could it be possible to implement a keep-alive? >> Everytime the connection

ver 3.0 reports running faster

Thanks to those who worked so hard! The program seems to run faster now, especially when making reports. OS Windows 10 Dave E. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: h

RE: Gnucash 3.0 release crashes during loading

I have the same issue when I upgraded it to 3.0 from 2.6.19. After I opened 3.0, the initial screen opened, then nothing happened. Now I downgraded it to 2.6.20. OS: Windows 10 Pro (up to date) Thanks, thomas -Original Message- From: gnucash-user On Behalf Of randix Sent: Tuesday, A

Re: ver 3.0 reports running faster

I want to endorse Dave E.  I have been watching people's comments with great interest.  On my W10 machine, Windows Defender merely commented that the setup package did not come from a trusted source. I trust the GNU people but just to be sure used 'MD5 and SHA Checksum Utility' and compared it

Re: Finance::Quote Yahoo_JSON Alpha Vantage

Sorry, Chris.  I should have mentioned the OS, etc.  I am running Linux Mint 18.2 and GC 2.6.17. If I understand, all I have to to do is reinstall F::Q? Thanks, Les On 04/02/2018 07:00 PM, Chris Good wrote: Message: 5 Date: Mon, 2 Apr 2018 17:59:28 -0500 From: Les To: gnucash-user@gnucash.org

RE: Gnucash 3.0 release crashes during loading

2.6.20??? I thought 2.6.19 was the last stable before 3.0 (which I've uninstalled). Where did you find it to download? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.or

RE: Gnucash 3.0 release crashes during loading

>From the directory of gnucash (stable). It is there. -Original Message- From: gnucash-user On Behalf Of randix Sent: Tuesday, April 3, 2018 4:16 PM To: gnucash-user@gnucash.org Subject: RE: Gnucash 3.0 release crashes during loading 2.6.20??? I thought 2.6.19 was the last stable befo

RE: Gnucash 3.0 release crashes during loading

Got it, thanks. Wonder what the issue is with 3.0, at least for you and me. Oh well, I'll wait a while before trying again... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnuc

Re: GnuCash 3.0 Released

Congratulations on that big milestone! And thank you for all the time and effort that went into this application. > Sent: Monday, April 02, 2018 at 10:17 PM > From: "John Ralls" > To: Gnucash-User > Cc: gnucash-devel , gnucash-annou...@gnucash.org > Subject: GnuCash 3.0 Released > > GnuCash 3.0

RE: Finance::Quote Yahoo_JSON Alpha Vantage

> -Original Message- >From Chris Good: ... > > Hi Les, > > > > Sorry you had problems following my instructions. > > > > The quickest way to reinstall the standard files over the modified files is: > > From a command prompt (Windows) or Terminal (Linux): > > cpan > > install Finance::Quote

RE: Gnucash 3.0 release crashes during loading

Guys, you might be affected by this https://bugzilla.gnome.org/show_bug.cgi?id=792105 So, just see if you have the same symptoms and, if so, follow the progress on the issue of slow loading and contribute some new facts. This issue currently affects sqlite (in some cases?) and that may or may not

Re: Importing Quicken

I have just copied the instructions from the FAQ page into a separate page on the GnuCash wiki, dedicated to Quicken migration: https://wiki.gnucash.org/wiki/Quicken_Migration This is a general hint to anyone considering or performing an actual migration from Quicken to GnuCash, to consult the kn

Re: Transferring data from Quicken Home and Business 2007

Hi, Paul, While this may not directly and completely answer your question, there is now a wiki page dedicated to this topic: https://wiki.gnucash.org/wiki/Quicken_Migration I am in the same boat as you and I have (so far) converted only the current financial year to GnuCash so that I can run the

Re: No suitable back-end

I just experienced this message so I'll share the scenario. Not sure if this should be reported as a bug (it could). Windows, GC 3.0, XML backend. - Using Save As option - select an existing file (book.sql.gnucash) - leave backend on xml (accidentally) - click Save As The reported message pops up

gnucash 3.0 crashes opening accounts file

Hi, I just downloaded and installed gnucash 3.0 on my Windows 7 machine. When I start it the app window comes up, but after I select the accounts file in the file open dialog I get this error dialog. Any ideas? Cheers - P

Re: Finance::Quote Yahoo_JSON Alpha Vantage

Thanks Chris!  All good now (except for currencies not completing), but can live with it. Les On 04/03/2018 03:59 AM, Chris Good wrote: -Original Message- From Chris Good: ... Hi Les, Sorry you had problems following my instructions. The quickest way to reinstall the standard files

Re: Importing Quicken

cicko, A very nice start. I would add that those with large data files extending back several years should consider: 1. not importing all of it. 2. if you want to import it all, break down your export QIF process to one asset or liability account at a time and for limited time intervals such as

Re: gnucash 3.0 crashes opening accounts file

P, it seems that a few windows users are having similar crashes or slow starts. There is an earlier thread abut this that refers to GnuCash bug 792105. The developers are currently gathering input to figure out what is happening. David C On Tue, Apr 3, 2018 at 5:26 AM, pjlbyrne wrote: > Hi,

Re: 2.7.8 fails to find environment file

John Ralls wrote: By the way, why does 3.0 start up with: "This is a development version. It may or may not work." Did you build 3.0 from a git checkout or from a tarball? It’s only supposed to print that message when you build from git... Built from tarball downloaded from Sourceforge.

Re: gnucash 3.0 crashes opening accounts file

OK - thanks David! Patrick -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailma

Re: gnucash 3.0 crashes opening accounts file

I am not convinced that the issues reported in that bug are the same as what I reported. Also: they apply to older versions of gnucash, and I have only seen this issue with version 3.0. I have been using gnucash for years on both windows and (debian) linux with no problems. Cheers Patrick -- S

Re: gnucash 3.0 crashes opening accounts file

Actually, whatever references there may be to earlier 2.6.whatever releases would just be for historical completeness at this point. The version that needs to be fixed is 3.0 and the cause may have different symptoms with different data files or on different computers with different histories of p

Re: gnucash 3.0 crashes opening accounts file

Okay - I might just build a debug version myself and run it up in Visual Studio - I don't know how much effort that is from cold, though I see from a quick shufti that the build requires 'mingw support scripts' - which doesn't inspire me with much confidence :-( P -- Sent from: http://gnucash.

Re: gnucash 3.0 crashes opening accounts file

Also, an 'ESIG.log' file is written to in C:\ at the time that gnucash crashes. It is in binary format. I can't find any info about it on the interwebs. Anyone know what kind of beast it is? CP -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: GnuCash 3.0 Released

Please use the list. Do not email developers directly. Regards, John Ralls > On Apr 3, 2018, at 1:58 AM, Peter Jackson wrote: > > Gnucash 3.0 will not load on Windows 10 version 1709. I have reverted to > 2.6.19 > > Peter > > > Nurton Court > Middleton-on-the-Hill > Ludlow SY8 4BD > Tel: 01

RE: GnuCash 3.0 Released QFX Import problem

I tried to import two QFX files into Gnucash 3, I know that some transactions were not entered into Gnucash 3 so they should have been listed but in both imports I got a blank screen. Joe St. Denis gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

Re: Record Auto Insurance expense

On 04/02/2018 09:03 PM, David Carlson wrote: Vendors is a business feature, and it is not recommended for non-business users. It is usually easiest to open up your checking, credit card or cash account register to enter all the transactions for each of those accounts.  Then enter a transactio

GNUCash 3.0 crashes on load

Gnucash crashes on opening an XML file (backup of my normally used mysql file). Mysql file eventually loads after 10-15 minutes. It takes only 50 seconds with version 2.6.19 I have the following error in my gnucash log after 10+ minute loading of mysql data file... : WARN Could not spawn pe

Re: GnuCash 3.0 Released QFX Import problem

> On Apr 3, 2018, at 6:46 AM, stdenis0--- via gnucash-user > wrote: > > I tried to import two QFX files into Gnucash 3, I know that some > transactions were not entered into Gnucash 3 so they should have been > listed but in both imports I got a blank screen. > Sounds like https://bugzilla

Texhad an issue compiling for PCLinuxos....

Offline Tex Administrator Super Villain ** Posts: 18933 Space City, Tx View Profile Personal Message (Offline) Re: GnuCash « Reply #2 on: Today at 01:28:20 AM » Quote I've spent hours on this and this is what it gives me even though the library is inst

Re: gnucash 3.0 crashes opening accounts file

Huh, the VB script to install gnucash devenv on windows fails silently, and the wiki web registration has a broken captcha link - problems problems problems! -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user

Re: gnucash 3.0 crashes opening accounts file

It would be useful if debug builds were available on the automated build server. Then I could download it, run it get the crash and boot up visual studio to get stacktrace etc. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _

Re: Transferring data from Quicken Home and Business 2007

On 04/03/2018 06:14 AM, cicko wrote: Hi, Paul, While this may not directly and completely answer your question, there is now a wiki page dedicated to this topic: https://wiki.gnucash.org/wiki/Quicken_Migration The only change I would suggest is to export just your category list (you can lim

Re: No Suitable Backend Found - sqlite3 on High Sierra

For posterity, this is solved by following John’s instructions from comment 1 in bug 794933: https://bugzilla.gnome.org/show_bug.cgi?id=794933 Regards, Adrien > On Apr 2, 2018, at 11:45 PM, Adrien Monteleone > wrote: > > I was previously using 2.6.19 with sqlite3 backend. > > I downloaded 3.

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

Mine is polite. It shows the same thing it showed in 2.6.19. This is on MacOS High Sierra. Regards, Adrien > On Apr 2, 2018, at 9:52 PM, Dave H wrote: > > Hi lj, on Windows 10 mine says "$, Grand Total: > Net Assets: $999,999.99 > Profits: $99,999.99". > > I'll have to compare with my Mac

Re: Billing credit card charges to customers

If you mean by automatically, no there is not a way. You’ll have to manually add those charges as line items to your invoices. Check Bugzilla and if you don’t see it in the list, file an enhancement request (abbreviated RFE) for this. Ideally, this should also be possible with any split so that

Re: GnuCash 3.0 Released

I want to add my thanks here to the devs for their hard work and patience with the rest of us as we stumble through the hiccups and quirks of a new version. I see a new feature has creeped in and I like it. Now, on startup, you not only get a Bills Due Reminder window, but also an Invoices Due

Re: gnucash 3.0 crashes opening accounts file

> On Apr 3, 2018, at 7:24 AM, pjlbyrne wrote: > > It would be useful if debug builds were available on the automated build > server. Then I could download it, run it get the crash and boot up visual > studio to get stacktrace etc. No you couldn't. GnuCash is built with gcc in a Mingw-w64 e

Re: gnucash 3.0 crashes opening accounts file

> On Apr 3, 2018, at 7:20 AM, pjlbyrne wrote: > > Huh, the VB script to install gnucash devenv on windows fails silently, and > the wiki web registration has a broken captcha link - problems problems > problems! The VB script isn't very good at error messages and can be frustrating to get rig

Re: Fast reactions to 2.7.8

Now that I’ve got 3.0 properly up and running, I see the Save and Close buttons have labels on the right side, but no others do. Regards, Adrien > On Mar 31, 2018, at 10:25 AM, Adrien Monteleone > wrote: > > That’s certainly a thorough run-down on changing themes. > > But is there a way to e

Re: GNUCash 3.0 crashes on load

> On Apr 3, 2018, at 7:05 AM, Joseph Vernice wrote: > > Gnucash crashes on opening an XML file (backup of my normally used mysql > file). Mysql file eventually loads after 10-15 minutes. It takes only 50 > seconds with version 2.6.19 > > I have the following error in my gnucash log after 10+

Re: Price Editor/Database lag

I started vmstat -tw 11 in a wide xterm and I do see a lot of swap out for some but not all delays. The not-first delays seem to be smaller now. The first delay did 3K+ so, later ones did 2K+, 300+ or almost no so. Almost no so may indicate the container is not dealing well with the volume and r

Re: Importing Quicken

cicko, I also like what you’ve done. I will add some edits there. Personally, I think the “Benefits” section is pointless; this page is about the migration from Quicken—not why someone should use GnuCash. I would recommend deleting it altogether, but I defer to you, since you created it. You

Re: virus download version 3.0

It's Microsoft's fault, not yours. Thanks for reporting it. For those interested I've submitted gnucash-3.0.setup.exe to Microsoft's false-positive reporting facility and gotten case number 82655139-6978-4eeb-80c2-7e1e72f820a6. Regards, John Ralls > On Apr 2, 2018, at 8:56 PM, Dave via gnuca

Re: 2.6.19 crash: one account recovered, one not yet recovered [RESOLVED]

On Tue, 3 Apr 2018, Rich Shepard wrote: How can I use the binary business.gnucash file to recover the account? If so, I can bring all registers up to date manually using bank and credit card statements. Tried opening the business.gnucash file and it worked! while the non-log files in the per

2.6.19 crash: one account recovered, one not yet recovered

Running GC-2.6.19 on Slackware-14.2 here. I have two accounts, personal and business. This morning I entered three transactions in the personal checking account, saved each, then tried to open the business file. Gnucash said it could not find that file, then shut down. Reading the gnucash-

Re: gnucash 3.0 crashes opening accounts file

Thanks again again. I had not only to run powershell with administrator priviliges, but also type 'Set-ExecutionPolicy Unrestricted' before running the script. Perhaps script execution policy is restricted by default at my workplace for security reasons. -- Sent from: http://gnucash.1415818.n4.n

Re: gnucash 3.0 crashes opening accounts file

Hmm lots of errors running setup-mingw64.ps1 (see below). Perhaps the script needs modifying so it uses my work web proxy? I will have a look tomorrow. CP powershell output -- PS C:\users\pbyrne\Download

Re: GnuCash 3.0 Released QFX Import problem

So what John is saying is that is a known bug that has a very high priority to get fixed but it may take a while before the fix is implemented so you may want to revert to 2.6.20 if you need that function now. David C On Tue, Apr 3, 2018 at 9:06 AM, John Ralls wrote: > > > > On Apr 3, 2018, at

Re: GNUCash 3.0 crashes on load

Thank you, John.  The perl install (Windows 10) solved the issue when opening XML format gnucash files, but mysql files still take 10 minutes to load AND now gnucash crashes after opening the SQL file. I just re-installed 2.6.19 and will wait for a fix as there seems to be quite a few experienci

Re: MySQL Server connection timeout or keep-alive

> > Hello, > > is it possible to change somewhere the connection timeout to a MySQL > > server on the client side? > > Or could it be possible to implement a keep-alive? > > Everytime the connection is lost, I need to restart gnucash. > > I don't think that it's possible from the client. IIUC (a

Re: MySQL Server connection timeout or keep-alive

> >> Hello, > >> is it possible to change somewhere the connection timeout to a > >> MySQL server on the client side? > >> Or could it be possible to implement a keep-alive? > >> Everytime the connection is lost, I need to restart gnucash. > > > > I don't think that it's possible from the client.

To those experiencing crashes of release 3.0 in windows

One possible work-around to this problem that may or may not work is to create a new user on your windows machine just to run GnuCash. It is fairly easy to delete that new user later when done with it. While I make that suggestion, I do not personally recommend it, so use at your own risk. David

Re: To those experiencing crashes of release 3.0 in windows

Windows 10 pc. I have not updated and based on what I’m seeing, I better wait? > On Apr 3, 2018, at 1:44 PM, David Carlson wrote: > > One possible work-around to this problem that may or may not work is to > create a new user on your windows machine just to run GnuCash. It is > fairly easy to d

RE: GnuCash 3.0 Released QFX Import problem

David C. Thanks for the suggestion to revert back to 2.6.20 I just finished the install and it seems to be working. I know it is always hard to get every thing to function correctly but I appreciate all the work that all the developers have put into getting GnuCash 3.0 working. Joe St. D

Re: MySQL Server connection timeout or keep-alive

On 3 April 2018 at 19:40, Paul Neuwirth wrote: > > ... > I am wondering, if no keep-alive is going to be implemented, if a > connection loss could be catched and connect again.. > the error message is: > "Unable to save to database." > That is not unreasonable on connection loss. What happens af

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

Yes checked last night and mine are the same on Windows 7/10 and Mac High Sierra as they were in 2.6.19. Cheers Dave H. On 4 April 2018 at 01:59, Adrien Monteleone wrote: > Mine is polite. It shows the same thing it showed in 2.6.19. This is on > MacOS High Sierra. > > Regards, > Adrien > > > O

Re: Fast reactions to 2.7.8

Split also has a label :-) Cheers Dave H. On 4 April 2018 at 02:33, Adrien Monteleone wrote: > Now that I’ve got 3.0 properly up and running, I see the Save and Close > buttons have labels on the right side, but no others do. > > Regards, > Adrien > > > On Mar 31, 2018, at 10:25 AM, Adrien Mont

Re: MySQL Server connection timeout or keep-alive

On Tuesday 2018-04-03 22:06, Colin Law wrote: Date: Tue, 3 Apr 2018 22:06:08 From: Colin Law To: Paul Neuwirth Cc: John Ralls , gnucash-user Subject: Re: MySQL Server connection timeout or keep-alive On 3 April 2018 at 19:40, Paul Neuwirth wrote: ... I am wondering, if no keep-alive is g

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

Thanks everyone for the replies. Unless I missed something, nobody else is seeing it, but everyone else who reported is running Windows or Mac. No other Linux users reported seeing or not seeing the issue. I did a little digging (dangerous when you don't really know what you are doing) and I s

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

I am using Ubuntu 16.04.4 LTS and see something similar in the Grand Total Summary Bar. I not sure what the Summary Bar is reporting. On Tue, Apr 3, 2018 at 7:59 PM, lj wrote: > Thanks everyone for the replies. Unless I missed something, nobody else is > seeing it, but everyone else who reporte

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

I am not getting any truncation in the summary bar on Arch. - Phil On 04/03/2018 04:59 PM, lj wrote: > Thanks everyone for the replies. Unless I missed something, nobody > else is seeing it, but everyone else who reported is running Windows > or Mac. No other Linux users reported seeing or not s

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

I don't see such abbreviation, but I understand how it could be problematic. It's like a piece is good most of the time but the whole thing might not be desired. To look at all day. It just depends. Sent from ProtonMail mobile Original Message On Apr 3, 2018, 9:36 PM, Phil wro

Re: 2.6.19 crash: one account recovered, one not yet recovered [RESOLVED]

> On Apr 3, 2018, at 10:32 AM, Rich Shepard wrote: > > On Tue, 3 Apr 2018, Rich Shepard wrote: > >> How can I use the binary business.gnucash file to recover the account? If >> so, I can bring all registers up to date manually using bank and credit >> card statements. > > Tried opening the b

Re: gnucash 3.0 crashes opening accounts file

> On Apr 3, 2018, at 10:37 AM, pjlbyrne wrote: > > Thanks again again. I had not only to run powershell with administrator > priviliges, but also type 'Set-ExecutionPolicy Unrestricted' before running > the script. Perhaps script execution policy is restricted by default at my > workplace for s

Re: gnucash 3.0 crashes opening accounts file

> On Apr 3, 2018, at 10:45 AM, pjlbyrne wrote: > > Hmm lots of errors running setup-mingw64.ps1 (see below). > > Perhaps the script needs modifying so it uses my work web proxy? > > I will have a look tomorrow. Quite likely, I don’t have any proxies in place and didn’t take that possibility

Re: MySQL Server connection timeout or keep-alive

> On Apr 3, 2018, at 1:06 PM, Colin Law wrote: > > On 3 April 2018 at 19:40, Paul Neuwirth > wrote: > > ... > I am wondering, if no keep-alive is going to be implemented, if a > connection loss could be catched and connect again.. > the error message is: > "Unable