Hi No I do not need to use MySQL at all, the xml option works fine.
I was thinking that if I get the data into an MySQL database I might be able to access the data more easily (read\only) to look at producing some form of checking account forecasting tool, either with XL or Access. I am really keen to switch from MS-Money UK to GnuCash but I rely heavily on being able to forecast how much will be in (or not be in) my checking account as we run towards payday - so far I've not had any response with any good tips on how to do this so was considering building something myself using tools I've more chance of making progress with, MySQL, XL or Access. Thank you for your help Perhaps I am misguided :-) Regards I have now reported the crash as bug https://bugzilla.gnome.org/show_bug.cgi?id=635911 assuming that either way it shouldn't just crash. -----Original Message----- From: Geert Janssens [mailto:janssens-ge...@telenet.be] Sent: 27 November 2010 10:27 To: Ian X Waddington Cc: gnucash-u...@gnucash.org; 'Gnucash Devel' Subject: Re: Save As MySQL is crashing gnucash On Saturday 27 November 2010, Ian X Waddington wrote: > HI, whilst this is a fascinating discussion and I am sure useful for > future development could I ask we get back on topic and help me find > out why my installation of GnuCash simply crashes out when trying to save-as MySQL. > > Either no one has 2.3.17 working with MySQL 5.1.53 on a Windows 7 > 32bit machine because there is a bug, or there is something wrong with > my install or how I am going about it. > The major problem in solving this issue is that none of the developers has a copy of Windows 7 available for debugging. So they have to go hunting based on the little information they get from the bug reports. With the reports I have seen so far, it looks as if libdbi is not compatible with Windows 7. libdbi is the external code library GnuCash uses to connect to mysql. But as I said, this is based only on the reports, I nor any other dev has had the opportunity to debug it on Windows 7 directly. > Either way it shouldn't crash so I will report it as a bug. > Please do. Can you add a link in your report to this bug: https://bugzilla.gnome.org/show_bug.cgi?id=624465 It seems to be the same problem, but on a 64bit version of Windows 7. > Any pointers appreciated, just a small clue would help :-) > I'm afraid I don't have any right now to get you up and running with mysql. Sorry. Do you really *have* to use mysql ? The xml backend should be quite stable. If mysql is not a must for your setup, I would recommend to use xml. I haven't seen any reports so far of connecting to postgresql (an alternative open source database) on Windows 7, neither success reports or failure reports. If you need a database, you may try if the postgresql integration works any better. Geert _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel