Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Geert Janssens
On Friday 26 November 2010, Robert Heller wrote: At Fri, 26 Nov 2010 11:51:18 -0800 (PST) Phil Longstaff plongst...@rogers.com wrote: That's not quite OK. If a new version of gnucash is released which requires a changed db schema, gnucash will try to automatically add new columns and

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Geert Janssens
On Friday 26 November 2010, Keith Bellairs wrote: Just did a save as into mysql with 2.3.17 on f14. that worked fine until I closed gnc and then tried to open it again. it now crashes every time with a seg fault i try to start gnc . It did tell me it could not get the lock and i told it to

Re: queries on mysql

2010-11-27 Thread Fred Verschueren
Don, thanks for your advice and explanation. I've done it the way you described and it took me 50 sec per year for one account, so in total 25 minutes. Nevertheless I think having the layout of the database can help making own reports easy. Fred. Op 26-11-10 15:21, Donald Allen

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Geert Janssens
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

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Colin Law
On 27 November 2010 10:58, Ian X Waddington iwad...@gmail.com wrote: 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

Eguile reports and css

2010-11-27 Thread Mike Evans
I've followed the http://wiki.gnucash.org/wiki/Custom_Reports_Using_Eguile page and made various changes to both the taxinvoice.css and taxinvoice.eguile.scm files. Nothing changes in the report output. Any advise. Fedora12 with GnuCash from SVN. Mike -- GPG Key: 1024D/050895C2

Re: queries on mysql

2010-11-27 Thread Donald Allen
On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren f...@fremar.be wrote: Don, thanks for your advice and explanation. I've done it the way you described and it took me 50 sec per year for one account, so in total 25 minutes. Good. Nevertheless I think having the layout of the database can

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Donald Allen
On Sat, Nov 27, 2010 at 6:27 AM, Colin Law clan...@googlemail.com wrote: On 27 November 2010 10:58, Ian X Waddington iwad...@gmail.com wrote: 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

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Donald Allen
On Sat, Nov 27, 2010 at 8:20 AM, Donald Allen donaldcal...@gmail.com wrote: On Sat, Nov 27, 2010 at 6:27 AM, Colin Law clan...@googlemail.com wrote: [snip] If you install either Ubuntu or Mint, early in the installation process you will deal with partitioning. If you install side-by-side with

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Anthony Dardis
FWIW GnuCash on Mac OS X is what let me finally turn off the lights on Windows for good: Quicken was the only thing I was using any more. (If my employer didn't provide me with the Mac I'd be exclusively using my Ubuntu-on-6-year-old-pc system. [And yes, it's remarkable what a difference

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Manfred Usselmann
On Sat, 27 Nov 2010 11:27:39 + Colin Law clan...@googlemail.com wrote: On 27 November 2010 10:58, Ian X Waddington iwad...@gmail.com wrote: 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

Re: queries on mysql

2010-11-27 Thread John Ralls
On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren f...@fremar.be wrote: Don, thanks for your advice and explanation. I've done it the way you described and it took me 50 sec per year for one account, so in total 25 minutes. Good.

Re: queries on mysql

2010-11-27 Thread Donald Allen
On Sat, Nov 27, 2010 at 11:23 AM, John Ralls jra...@ceridwen.us wrote: On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren f...@fremar.be wrote: Don, thanks for your advice and explanation. I've done it the way you described and it took me 50

Re: Save As MySQL is crashing gnucash

2010-11-27 Thread Robert Heller
At Fri, 26 Nov 2010 11:51:18 -0800 (PST) Phil Longstaff plongst...@rogers.com wrote: That's not quite OK. If a new version of gnucash is released which requires a changed db schema, gnucash will try to automatically add new columns and constraints. This might mean we will need to

RE: Save As MySQL is crashing gnucash

2010-11-27 Thread Ian X Waddington
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

RE: Save As MySQL is crashing gnucash

2010-11-27 Thread 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