u have any problems.
Phil
On April 1, 2009 01:09:39 pm charles dandridge wrote:
> I'm mainly looking to use gnucash with the mysql backend.
>
> On Tue, Mar 31, 2009 at 4:32 PM, Phil Longstaff wrote:
> > It depends what you want to do. Doing what you are doing, downloading
&g
o clue.
Phil
From: David Reiser
To: Derek Atkins
Cc: Phil Longstaff ; Gnucash list
Sent: Thursday, April 2, 2009 11:54:38 AM
Subject: Re: Trouble compiling
No. I have upgraded a couple dependencies since I first mentioned this, but
the attached crash log is from gnucash built last nig
I got my win32 build environment running so I'll look at this as soon as I can.
Phil
From: Sebastian Held
To: Phil Longstaff
Cc: David Reiser ; Derek Atkins ;
Gnucash list
Sent: Thursday, April 2, 2009 3:19:10 PM
Subject: Re: Trouble compiling
It's not crashing for me on win32. Sebastian, you showed the results when it
hit the breakpoint in gdb, but does it crash for you? I don't see that from
your e-mail.
Phil
____
From: Phil Longstaff
To: Gnucash list
Sent: Friday, April 3, 2009 9:18:57
I can't run on linux with valgrind. I run into a startup problem in the
goffice stuff which aborts and kills gnucash. I haven't tracked it down yet.
From: Sebastian Held
To: Phil Longstaff
Cc: Gnucash list
Sent: Friday, April 3, 2009 4:33:08 PM
S
ckend, and the libdbi backend doesn't
register a backend if the dbd file isn't present).
____
From: David Reiser
To: Phil Longstaff
Cc: Sebastian Held ; Gnucash list
Sent: Saturday, April 4, 2009 4:18:49 PM
Subject: Re: Crash in dialog_file_access.c (was
sn't asked for the registered backends yet? If so, why would
> Sebastian's example show a non-null list with a breakpoint at the same
> location?
>
> Dave
>
> On Apr 4, 2009, at 4:38 PM, Phil Longstaff wrote:
> > List being null isn't the problem.
> >
&
5. April 2009 10:46:33 schrieb Sebastian Held:
> > > Finally I got my suse box to compile trunk, and voila:
> > > trunk (rev18013) crashes even on linux, but not the first time you
> > > open save as...
> > > Here is how to reproduce the crash:
> > > - trigger sav
01:45 schrieb Phil Longstaff:
> Author: plongstaff
> Date: 2009-04-04 19:45:29 -0400 (Sat, 04 Apr 2009)
> New Revision: 18015
> Trac: http://svn.gnucash.org/trac/changeset/18015
>
> Added:
>gnucash/branches/2.4/
> Log:
> Create 2.4 branch
Err... this 2.4 branch is copi
--- Neil Williams <[EMAIL PROTECTED]> wrote:
> Not for the current file backend, it is also slated
> for replacement. XML
> is not an ideal choice of long term storage of
> important data.
The Massachusetts state government might not agree
with you.
Phil
__
This G2 patch makes the following UI changes:
1) Adds GTK_SHADOW_IN to the commodities dialog scroll box
2) Adds GTK_SHADOW_IN to the account dialog parent scroll box
3) Makes the 'edit', 'remove' and 'remove-old' buttons on the price db dialog
box insensitive until a price is chosen. Note: this
I'm currently running SuSE 9.3 and have g2 built from source. I have a very
reproducible crash which I'm trying to find the cause of (there are a number
of Bugzilla bugs which this is a duplicate of - 108347
http://bugzilla.gnome.org/show_bug.cgi?id=108347, 141287 (dup of 108347)).
The crash
Small update:
On February 11, 2006 01:05 pm, Phil Longstaff wrote:
> I'm currently running SuSE 9.3 and have g2 built from source. I have a
> very reproducible crash which I'm trying to find the cause of (there are a
> number of Bugzilla bugs which this is a duplicate
On February 19, 2006 06:09 pm, Josh Sled wrote:
> On Sun, 2006-02-19 at 17:57 -0500, Derek Atkins wrote:
> > > 2) After g2 is up, I open an account, switch to ledger view, put my
> > > cursor into a split and start pressing delete-tab-delete-tab... I then
> > > get the listing shown in attachment
On February 19, 2006 06:43 pm, Derek Atkins wrote:
> Phil Longstaff <[EMAIL PROTECTED]> writes:
> > The attached patch replaces the const 16 with GUID_DATA_SIZE, only
> > compares the guid data, not the other field in the struct, and removes
> > the use of the dirent s
On February 19, 2006 08:41 pm, Derek Atkins wrote:
> I still can't believe that there's no way to tell valgrind
> "this memory object is initialized, even if it may be 'tained'
> by uninitialized memory".. That would seem to be a core
> suppression method, the "I know this data object is clean".
On February 21, 2006 03:16 pm, Josh Sled wrote:
> On Sun, 2006-02-19 at 12:21 -0500, Phil Longstaff wrote:
> > 2) After g2 is up, I open an account, switch to ledger view, put my
> > cursor into a split and start pressing delete-tab-delete-tab... I then
> > get the listin
The attached patch fixes a memory leak.
Index: src/gnome-utils/gnc-menu-extensions.c
===
--- src/gnome-utils/gnc-menu-extensions.c (revision 13465)
+++ src/gnome-utils/gnc-menu-extensions.c (working copy)
@@ -127,6 +127,7 @@
SCM pat
make[7]: Entering directory
`/home/phil/gnucash2/svn/gnucash/lib/libqof/backend/file'
if /bin/sh ../../../../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I.
-I. -I../../../.. -I../../../.. -I../../../.. -I../../../..-I.. -I../..
-DLOCALE_DIR=\""/opt/gnucash2/share/locale"\" -I../../.
I have some time available for development (was laid off about a week
ago :-( ) and thought that a good project to spend some time on would be
an SQL backend for GC2/QOF. I know that a while ago, someone named
Matthew V (?) was working on something in the GC 1.X series, but I
haven't seen his
On Mon, 2006-23-10 at 17:14 -0500, Daniel Espinosa wrote:
> Attached you'll find a DataBase Schema for GnuCash.
>
> This is in order to bigin the development to support DB backend (and
> replase the actual file one).
>
> I added a Inventory Table (or Class) in wich you can have the
> merchandise
On Mon, 2006-23-10 at 22:38 -0400, Josh Sled wrote:
> It'll probably be the case that the SQL DDL statements will be easier to
> work with than these pictures. Just plain text like...
>
> CREATE TABLE accounts
> (
> id int NOT NULL,
> name String,
> parent int NOT NULL,
On Wed, 2006-25-10 at 14:12 +0100, Tony Bloomfield wrote:
> As designer of the SQL backend for a rival package (KMyMoney), I'd be happy
> to
> swap ideas, etc. There's not a great deal of difference between the two
> products, except that KMM does not really support small business.
>
> Anyhow,
On Wed, 2006-25-10 at 11:29 -0400, Derek Atkins wrote:
> Phil,
>
> Nice work so far. I've got a few comments.
>
> IDs:
>
> The ID should be the GUID. I don't think you can make that
> an int per-se; although it IS a 128-bit number. I don't think the
> databases have 128-bit integer data types
On Thu, 2006-26-10 at 09:53 -0400, Derek Atkins wrote:
> Mark Johnson <[EMAIL PROTECTED]> writes:
>
> > I may be getting a bit ahead of the play here, since you are talking
> > about design still, and I am thinking about implementation of it in a
> > MySql backend.
> >
> > I was recently doing s
I've attached an updated DDL for the proposed SQL backend. I used MySQL
to test, and it creates the tables correctly.
Some notes:
1) This only covers the core objects i.e. the DDL is based on
src/backend/file/*-v2.c.
2) The namespace for the commodities table is just a string. I'm unsure
about
I'm starting to take a look at the data abstraction layer to be used.
The two candidates are libdbi and libgda. Here's what I have found so
far:
SQLite: latest stable version is 3.3.8 (Oct 9/06)
MySQL: latest stable version is 5.0.24a
PostgreSQL: latest stable version is 8.1.5
DB abstraction lay
On Fri, 2006-27-10 at 12:01 -0400, Derek Atkins wrote:
> Phil Longstaff <[EMAIL PROTECTED]> writes:
>
> >> I suppose we could use varchar; the guid has a fixed size so we know
> >> exactly how much space it requires. It's just an MD5 hash, so it's
> >
On Fri, 2006-27-10 at 11:58 -0400, Derek Atkins wrote:
> I'm not sure what you mean by "cascade of DELETE operations".
> I think we CAN depend on the DB supporting transactions, but it
> might depend on what level of TXN support we want/need.
With foreign keys, you can specify what should happen
On Fri, 2006-27-10 at 12:37 -0400, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> > On Fri, 2006-27-10 at 11:58 -0400, Derek Atkins wrote:
> >
> >> I'm not sure what you mean by "cascade of DELETE operations".
> >>
On Fri, 2006-27-10 at 12:33 -0400, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> >> I still don't understand why you want to do this. What does it buy
> >> us? It seems to add a LOT of complexity on the GnuCash side when
> >&g
On Fri, 2006-27-10 at 18:48 -0500, Daniel Espinosa wrote:
> 2006/10/26, Phil Longstaff <[EMAIL PROTECTED]>:
> > I've attached an updated DDL for the proposed SQL backend. I used MySQL
> > to test, and it creates the tables correctly.
>
> I have tested your DDL i
On Sat, 2006-28-10 at 11:46 -0400, Derek Atkins wrote:
> Phil Longstaff <[EMAIL PROTECTED]> writes:
>
> >> > Since the connection string will be db-specific, we may want a db core
> >> > built around libgda (see libgda vs libdbi e-mail) with a small add-on to
On Sat, 2006-28-10 at 11:43 -0400, Derek Atkins wrote:
> Phil Longstaff <[EMAIL PROTECTED]> writes:
>
> > Hi Daniel,
> >
> > thanks. I made some modifications to fix most of the problems. I have
> > both PostgreSQL and MySQL set up on my machine so I can
On Sat, 2006-28-10 at 12:55 -0400, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> > Re slot table: even if lists aren't used, there is still the hierarchy
> > based on sub-frames. A row in the slot table may still need a link to
> > its
I've started to look at what is needed to put a new backend into GC. My
first questions is if this is documented anywhere. I've needed to
update a few different files, and wonder if it couldn't be improved so
that each backend only needs to be known about in one place. For
example, gnc_engine_in
I have started working on a gda backend and am starting with a QofQuery
-> SQL translator. I assume no one else has such a beast (there is a
SQL -> QofQuery translator as part of QOF. When we get an SQL backend,
it won't make sense to translate SQL -> QofQuery -> SQL). I have also
looked at the
On Thu, 2006-02-11 at 08:40 -0600, Daniel Espinosa wrote:
> 2006/11/1, Derek Atkins <[EMAIL PROTECTED]>:
> > Quoting Daniel Espinosa <[EMAIL PROTECTED]>:
> >
> > >> Also, we'll need to make changes to handle the fact that file://
> > >> should get redirected to sqlite:// -- but the code will need t
On Thu, 2006-02-11 at 16:14 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> > I have started working on a gda backend and am starting with a QofQuery
> > -> SQL translator. I assume no one else has such a beast (there is a
> > SQL
On Thu, 2006-02-11 at 16:53 -0500, Chris Shoemaker wrote:
> On Thu, Nov 02, 2006 at 08:47:30AM -0500, Phil Longstaff wrote:
> > I have started working on a gda backend and am starting with a QofQuery
> > -> SQL translator.
>
> Have you looked at just directly using th
On Thu, 2006-02-11 at 22:04 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> > On Thu, 2006-02-11 at 16:53 -0500, Chris Shoemaker wrote:
> >> On Thu, Nov 02, 2006 at 08:47:30AM -0500, Phil Longstaff wrote:
> >> > I have started w
On Fri, 2006-03-11 at 13:58 -0500, Derek Atkins wrote:
> But as you can see from other email, I'm open to listen. Chris convinced me
> that we should look forward to GDA-2 (through 1.99) instead of keeping
> with 1.9
I have seen Chris's e-mail proposing we use GDA-2 (1.99) instead of 1.2,
but ha
On Fri, 2006-03-11 at 14:40 -0600, Daniel Espinosa wrote:
> I know some about GObject architecture, I plan to use this to
> understand QOF, that's the easy part, and plan to implement most of
> the Interface to create the backend privider independient as far as I
> could, focus on SQLite for the fi
On Fri, 2006-03-11 at 17:00 -0500, Derek Atkins wrote:
> I think, Phil, that you should use Daniel as a resource to better
> understand GDA. Daniel, I think you should provide your GDA knowledge
> to Phil who seems to better understand the issue at hand. I leave it
> to you two to figure out how
Some questions about how commodities are handled.
1) I create a new account with a currency as its commodity. There is a
commit for the commodity (actually, there are 2 - once because of
gnc_commodity_set_quote_flag and once because of
gnc_commodity_set_quote_source - both called from
xaccAccoun
On Tue, 2006-07-11 at 14:01 -0500, Derek Atkins wrote:
> Phil,
>
> First, thanks for this work so far. It's looking like we're making
> progress, which is good. But I've got a few comments about this work.
> Comments are inline..
>
> Phil Longstaff <[EMAI
On Wed, 2006-08-11 at 13:54 -0500, Derek Atkins wrote:
> Phil Longstaff <[EMAIL PROTECTED]> writes:
>
> >> The business ddl should live unser src/business/business-core/gda
> >> (along with any other business-specific GDA code).
> >
> > I agree. I create
I just want to verify what needs to be done.
When I open an account, the backend gets a QofQuery which translates
into SQL as:
SELECT * FROM splits WHERE book.guid = "..." AND account.guid = "..."
I assume that what is really needed is:
SELECT * FROM transactions
On Sun, 2006-12-11 at 15:18 -0500, Derek Atkins wrote:
> Not only that -- you need to check whether the transaction content in the
> DB is "newer" than the cache in the engine. E.g. in a multi-user situation
> one user may have modified the contents of a transaction, so when another
> user perfor
On Wed, 2006-15-11 at 13:33 -0500, Derek Atkins wrote:
> Yes. Keep in mind that once you get to the point of getting told
> "object is locked", it's already too late.. There's no error code
> returned from begin_edit() that could get displayed to the user. In
> this case I think it's "last write
I have the basic split query working. I receive the query:
(1) SELECT * FROM splits WHERE account_guid = 'XXX'
and convert it to:
(2) SELECT * FROM transactions WHERE guid IN
(SELECT DISTINCT tx_guid FROM splits WHERE account_guid = 'XXX')
Then, for each transaction, I load its
I am working on saving and restoring lots. I know they are used in the
business backend to match an invoice with a payment and in stock/mutual
fund accounts to match purchases and sales. Any other places?
Internally, a split has a pointer to the lot it is a member of, and a
lot has a glist of sp
On Fri, 2006-24-11 at 15:53 -0500, Derek Atkins wrote:
> Phil,
>
> Phil Longstaff <[EMAIL PROTECTED]> writes:
>
> > +static col_cvt_t col_table[] =
> > +{
> > + { "guid", CT_GUID, 0, COL_NNUL|COL_PK
If I open a register, modify a split and then try to record the modified
transaction, the back end receives a commit call for the transaction,
not for any splits. However, the transaction is not dirty. I don't
really want to special case this (though queries for splits are already
special cased).
I put in some special case code for now so that if a clean transaction
is committed, each split is then committed so that dirty splits in a
clean transaction will be written to the db. However, if a split is
deleted from a transaction, the deletion is never committed so the db
now has an out-of-ba
On Thu, 2006-07-12 at 10:39 -0500, Derek Atkins wrote:
> Phil Longstaff <[EMAIL PROTECTED]> writes:
>
> > If I open a register, modify a split and then try to record the modified
> > transaction, the back end receives a commit call for the transaction,
> > not
On Thu, 2006-07-12 at 09:38 -0500, Derek Atkins wrote:
> It's too late to backport for 2.0.3 because it adds new strings.
> After the 2.0.3 release we could backport it for a potential 2.0.4,
> but I'm hoping we could start to consider a 2.1.x test release
> sometime soon, if only to push out the
On Thu, 2006-07-12 at 20:52 -0700, Mark Johnson wrote:
> I thought I'd see what the gda back end looks like so far. After
> checking out the branches/gda-dev (svn 15190), the compile failed:
> gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I../../.. -I../../.. -I../../..
> -I.. -I../.. -DLOCALE_DIR=\"
I'm working on saving/restoring scheduled transactions, and have some
questions:
1) Accounts - The only difference I can see between regular accounts and
the accounts created for scheduled transactions is in the currency - the
currency for scheduled transactions is in the "template" namespace.
Any
On Fri, 2006-08-12 at 18:20 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> > I'm working on saving/restoring scheduled transactions, and have some
> > questions:
> >
> > 1) Accounts - The only difference I can see between regu
> Thanks, Phil. My next attempt at building ended with this:
> gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I../../.. -I../../.. -I../../..
> -I.. -I../.. -DLOCALE_DIR=\"/opt/gnucash-svn15192/share/locale\"
> -I../../../src/backend -I../../../src/engine -I../../../src/core-utils
> -I../../../lib/li
> I am using gcc 3.3.6. It may also be that I am passing
> --enable-compile-warnings to configure. I see that -Wall is part of the
> options being passed to gcc. I expect that the
> --enable-compile-warnings caused the -Wall. I would recommend its use
> for development.
I've got 4.0.2, and
On Fri, 2006-08-12 at 23:10 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> >> The main difference is the root.. SXes all live in their own AccountGroup,
> >> separate from the CoA. Why do you need anything special? Why can't yo
I've included a portion of the GDA_STATUS file which brings up some
questions:
- To avoid having the backend commit everything twice (because of the
Qof two phase commit protocol), saved objects are marked clean when
committed. To do this, I need to reach right into the QofInstance
structure and
On Sat, 2006-09-12 at 13:19 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> > - To avoid having the backend commit everything twice (because of the
> > Qof two phase commit protocol), saved objects are marked clean when
> > committed
On Sat, 2006-09-12 at 15:13 -0700, Mark Johnson wrote:
> Phil Longstaff wrote:
>
> >Yes. Fixed in r15194.
> >
> >Phil
> >
> >
> >
> Trying another build.
>
> Are you using--enable-compile-warnings? At the moment, I am leav
On Sat, 2006-09-12 at 17:14 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
> > My question about "should the concept of clean/dirty disappear" is to
> > raise it as an architectural change. Should these be put into bugzilla?
On Sat, 2006-09-12 at 17:40 -0500, Derek Atkins wrote:
> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>
> >> Are you using--enable-compile-warnings? At the moment, I am leaving it
> >> out.
> >
> > I'm not. Maybe I'll turn it on.
>
>
The subject of multiple books has come up, especially with a GDA
backend. qofsession.c has the comment:
/* XXX why are we creating a book here? I think the books
* need to be handled by the backend ... especially since
* the backend may need to load multiple books ... XXX. FIXME.
On Mon, 2006-18-12 at 14:37 -0700, Mark Johnson wrote:
> 1. It should use the username and password from the connection rather
> than requiring them on the command line.
It should allow them on the command line to override what is in the
connection but not require them. If that is not the case,
On Sat, 2006-23-12 at 12:58 -0700, Mark Johnson wrote:
> Derek Atkins wrote:
>
> >> I would like to test the gda backend by saving (a copy of) my real
> >> data to it. How would I do that? (I am testing gnucash-gda on a
> >> separate machine from where I run gnucash with my real data.)
> >
> >
Some questions about books and how they are/will be used:
One idea I've heard is that separate books could be used for separate
years with the same chart of accounts. This would mean that there is no
link from an account to a book, but there would be for a transaction
i.e. a transaction would be
On a new installation, after I ran gnc-fq-update, I still got a "system error"
when trying to retrieve quotes. gnc-fq-dump worked fine. However, when I ran
gnc-fq-helper, it told me that Date::Manip was not found. I have modified
gnc-fq-update and gnc-fq-check to check for Date::Manip (there
801 - 873 of 873 matches
Mail list logo
