Save As MySQL is crashing gnucash

[Ian X Waddington]

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-geert at telenet.be] 
Sent: 27 November 2010 10:27
To: Ian X Waddington
Cc: gnucash-user at 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