I restored my 7/7/12 image with GnuCash v2.4.10 and was able to save the default file GnuCash tomysql://root@127.0.0.1/test25.
I did a File -> Quit and noticed it should "Unsaved ..." in the panel title as GnuCash exited. I restarted GnuCash and it had test25 as the default. The splash screen icon shows "GnuCash (Not Responding)". 5-10 minutes later, Windows brings up the "not responding" Debug/Close pop-up and I close it. I restart GnuCash and cancel test25. The panel says "Unsaved GnuCash". I do File -> Open -> "GnuCash" and do saveas test25a and it says error or bad or corrupted data. I try test25b and get the same error. I reload the file GnuCash and try to saveas mysql://root@localhost/test25c which also fails with the same error message. I see the lock file, GnuCash.LCK and it goes away when I exit GnuCash. I also noticed MySQL had crashed or the service had stopped running because the MySQL commandline console would close when I tried to login to check status. The Windows services panel says, "Service status: Started", so I do "Stop", then 10 seconds later, "Start". But I can't login. I exit GnuCash, now I can login (as root). The status is, -------------- F:\usr\MySQL\MySQL Server 5.5\bin\mysql.exe Ver 14.14 Distrib 5.5.24, for Win64 (x86) Connection id: 1 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.5.24 MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3306 Uptime: 1 min 52 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 33 Flush tables: 1 Open tabl es: 26 Queries per second avg: 0.035 -------------- Now I get "Error", "Unspecified fatal error encountered, aborting." When I dismiss that pop-up, I get the "Microft Visual C++ Runtime Library", "This application has requested the Runtime to terminate in an unusual way." This time I don't believe it's my fault per se. I probably do need to reboot, but my Windows 7 is up-to-date with all it's updates, except I may have needed to do one more reboot since that last updates were applied. I had taken extensive notes on this issue,but wanted to provide fresh information right now. Thank you, Art ________________________________ From: Derek Atkins <de...@ihtfp.com> To: vArt <pina...@yahoo.com> Cc: Colin Law <clan...@googlemail.com>; "gnucash-devel@gnucash.org" <gnucash-devel@gnucash.org> Sent: Friday, August 24, 2012 2:18 PM Subject: Re: Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"? hi, On Fri, August 24, 2012 4:08 pm, Art wrote: > Correct. It hangs when I try to open the same db it saved. > Any subsequent re-starts of GnuCash do the same for that database. How did you exit GnuCash after your File -> Save As? What happens if you click "open anyways"? > - Art -derek > > > > ________________________________ > From: Colin Law <clan...@googlemail.com> > To: Art <pina...@yahoo.com> > Cc: "gnucash-devel@gnucash.org" <gnucash-devel@gnucash.org> > Sent: Friday, August 24, 2012 12:57 PM > Subject: Re: Is there a step-by-step, "How to setup a MySQL database for > use with GnuCash"? > > On 24 August 2012 20:53, Art <pina...@yahoo.com> wrote: >> Hi! >> >> I don't know if I should ask this in a different forum, but I've >> experimented with GnuCash for several years, but recently wanted to just >> use the MySQL database for my finances and GnuCash can never read them. >> It can create a database which I can read from the MySQL commandline >> interface, but GnuCash simply hangs when I try doing it from it. > > Do you mean that if you do Save As and select the mysql option that it > creates the db ok, but then if you close and re-open gnucash that it > does not re-open the mysql db? > > Colin > > [deleted my text below for brevity - Art] > _______________________________________________ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel