I don't recall the exact steps I took, so I'm repeating it. I clicked on the GnuCash menu entry which points to, F:\usr\gnucash\bin\gnucash.exe (v2.4.11 built from svn r22268 on 2012-07-15)
and get, GnuCash could not obtain the lock for mysql://[email protected]/gc120816f. So, I clicked the "Open Anyway" button as I have done before and it goes back to the splash screen, acting like it's going to open the database, but Windows 7 just displays the blue "busy" circle until the pop-up, gnucash.exe has stopped working comes up and I do "Close program". I invoke it again, but this time, I say "Cancel" and open my 18 MB GnuCash_XML file from 2009. Now, I do "Save as..." to mysql on localhost with Database "gc120825", Username "root" and it fails with, The server at URL mysql://root@localhost/gc120825 experienced an error or encountered bad or corrupt data. (The MySQL commandline interface shows, F:\usr\MySQL\MySQL Server 5.5\bin\mysql.exe Ver 14.14 Distrib 5.5.24, for Win64 (x86) ) So I hit the "Close" button and do it again, but this time I set Host to 127.0.0.1 and get the same error. I give up on that one open 2009_converted_120816.gnucash. I can't save that one either so I do a File -> Quit from GnuCash. I created an empty file, Test1.gnucash. It has the default 5 accounts with zero balances on each. I did a save as mysql://root@localhost/test1a, successfully. I did File -> close. I reinvoked GnuCash from the Start menu and got a pop-up, "Error", Unspecified fatal error encountered, aborting. I did Ok to close it. I then got another pop-up, "Microsoft Visual C++ Runtime Library", This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. Ok - this one could be my fault! I recently discovered some Windows Updates were not being applied, so I did some gross clean-ups two days ago! This involved zapping all Microsoft Visual Studio applications and C++ (2005 - 2010, including runtime and Redistribute packages). Since I wasn't getting this specific error before - I apologize for wasting your time - I will reimage my system and start from a pristine state before I test GnuCash again. (Doh! I just hate going back 6 months... to my previous known good system.) Thank you, Art ________________________________ From: Derek Atkins <[email protected]> To: vArt <[email protected]> Cc: Colin Law <[email protected]>; "[email protected]" <[email protected]> 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 <[email protected]> > To: Art <[email protected]> > Cc: "[email protected]" <[email protected]> > 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 <[email protected]> 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 > [email protected] > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > -- Derek Atkins 617-623-3745 [email protected] www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
