Re: Save As MySQL is crashing gnucash

On Friday 26 November 2010, Robert Heller wrote: > At Fri, 26 Nov 2010 11:51:18 -0800 (PST) Phil Longstaff 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

Re: Save As MySQL is crashing gnucash

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

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 schreef:

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 on

Re: Save As MySQL is crashing gnucash

On 27 November 2010 10:58, Ian X Waddington 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 > checking ac

Eguile reports and css

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 Keyserver:

Re: queries on mysql

On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren 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 help mak

Re: Save As MySQL is crashing gnucash

On Sat, Nov 27, 2010 at 6:27 AM, Colin Law wrote: > On 27 November 2010 10:58, Ian X Waddington 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

Re: Save As MySQL is crashing gnucash

On Sat, Nov 27, 2010 at 8:20 AM, Donald Allen wrote: > On Sat, Nov 27, 2010 at 6:27 AM, Colin Law 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 Windows, the installer will squash your

Re: Save As MySQL is crashing gnucash

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 Ub

Re: Save As MySQL is crashing gnucash

On Sat, 27 Nov 2010 11:27:39 + Colin Law wrote: > On 27 November 2010 10:58, Ian X Waddington 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 mor

Re: queries on mysql

On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: > On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren 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

On Sat, Nov 27, 2010 at 11:23 AM, John Ralls wrote: > > On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: > >> On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren 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

Re: Save As MySQL is crashing gnucash

At Fri, 26 Nov 2010 11:51:18 -0800 (PST) Phil Longstaff 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 package schema upgrad

RE: Save As MySQL is crashing gnucash

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 mac

RE: Save As MySQL is crashing gnucash

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 k

RE: Save As MySQL is crashing gnucash

HI Thank you, there is some good advice here. I do actually have a laptop with Ubuntu 10.10 on but have never considered using it as my 'proper' machine, we just use it occasionally as a spare machine and for the odd job that just seems too hard on Windows. My PC is currently dual booting XP &

Budget report with a different format

I have been playing around with the budget report to provide the info I want in the format I want. For now, I've just called it "PSL Budget" (my initials). I don't know what bugs there might be. The format. There are 3 sets of columns. Each set of columns can have budget/actual/diff values. T