Re: gnucash crashing on DB error

2009-07-22 Thread Mark Johnson
Brian Amos wrote: Gnucash seems to be crashing whenever the database returns an error, such as incorrect password, or DB unavailable. I am able to log what gnucash is sending to the DBI, is there a way to log what's going on inside the DBI? Hopefully the DBI is returning error codes that gnuca

Re: SQL Backend can't parse URL

2009-02-02 Thread Mark Johnson
Phil Longstaff wrote: > The interesting line in your log is: > * 07:22:41 INFO [init_sql_backend] -1 DBD drivers > found > > which means that there was some problem initializing libdbi. > > Your listing above shows that the dbd file are in /usr/local/lib/dbd. My > packages (ubuntu) put

Re: SQL Backend can't parse URL

2009-02-01 Thread Mark Johnson
Phil Longstaff wrote: > On January 31, 2009 11:07:17 pm Mark Johnson wrote: > >> Phil Longstaff wrote: >> >>> Hmmm... 'configure' does allow any wrong options and does not seem to >>> flag it. What is *supposed* to happen (and what happen

SQL Backend can't parse URL

2009-01-31 Thread Mark Johnson
I have built trunk rev 17855 with the wrong configure options. I accidentally used the old --enable-gda instead of the correct --enable-dbi. The file menu has a Database Connection option and when I filled in its dialog's fields and clicked OK, I got a "can't parse URL error". If I haven't e

Re: DBI backend configure failure

2008-07-15 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> Configure fails as follows: >> >> checking for libgoffice-0.5 >= 0.5.1... no >> checking for libgoffice-0.4 >= 0.4.0... no >> checking for libgoffice-0.3 >= 0.3.0... no >> checking for libg

DBI backend configure failure

2008-07-14 Thread Mark Johnson
Configure fails as follows: checking for libgoffice-0.5 >= 0.5.1... no checking for libgoffice-0.4 >= 0.4.0... no checking for libgoffice-0.3 >= 0.3.0... no checking for libgoffice-1 >= 0.0.4... no configure: error: Cannot find libgoffice. I have libgoffice-0.6 installed. The configure.in in tr

Re: GDA missing records retest (long)

2008-04-19 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> While looking at the PostgreSQL error log, I also noted the following error: >> ERROR: relation "books" does not exist >> STATEMENT: INSERT INTO books (guid, root_account_guid, >> root_template_guid) V

Re: GDA missing records retest (long)

2008-03-11 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> Since I have one extra account showing in the XML file, I checked to see >> if the DBs have the ROOT account in them. They do not. >> QUESTION: Is this a problem? >> > > The ROOT account was added so

GDA missing records retest (long)

2008-02-29 Thread Mark Johnson
Now that I've managed to get the data saved to the DBs and the gnucash's exitted, it is time to check the data in the DBs. As a check on the DB data, I created an awk script to count the numbers of accounts, transactions, and splits in the xml data file. Here is the awk script: BEGIN { n

Re: GDA spurious save dialog

2008-02-29 Thread Mark Johnson
Mark Johnson wrote: > I see from the ChangeLogs and message traffic that the issues arising > from the missing SQL records have been dealt with. > > I have patched and compiled libgda 3.0.2 with the following two patches: > 1. Escaping of single quotes in strings is corrected. >

GDA spurious save dialog

2008-02-28 Thread Mark Johnson
I see from the ChangeLogs and message traffic that the issues arising from the missing SQL records have been dealt with. I have patched and compiled libgda 3.0.2 with the following two patches: 1. Escaping of single quotes in strings is corrected. 2. the patch for the PostgreSQL provider returnin

Re: GDA Missing records in SQLite

2008-02-24 Thread Mark Johnson
Graham Leggett wrote: > Phil Longstaff wrote: > >> There is a function to query the backend to see what features it >> supports, but prepared statements is not in that list. Also, if we >> require prepared statements, that might cut out the sqlite backend >> because a libgda modification to use

Re: GDA Missing records in SQLite

2008-02-24 Thread Mark Johnson
haviour of libgda: >> >> - Row inserts are failing, but the error is not communicated back to >> the caller. As a result, the database is corrupted in the process. >> > I'm not sure the error is not communicated back. In an e-mail from Mark > Johnson with ms

Re: GDA Missing records in SQLite

2008-02-21 Thread Mark Johnson
Michael Vrable wrote: > On Wed, Feb 20, 2008 at 09:34:34PM -0700, Mark Johnson wrote: > >> PostgreSQL gives a warning for '', but accepts it; it prefers \'. >> MySql takes the ''; I'm not sure about \'. Obviously SQLite won't >

Re: GDA Missing records in SQLite

2008-02-21 Thread Mark Johnson
Graham Menhennitt wrote: > Mark Johnson wrote: > >> PostgreSQL gives a warning for '', but accepts it; it prefers \'. MySql >> takes the ''; I'm not sure about \'. Obviously SQLite won't take the \'. >> >> However,

Re: GDA Missing records in SQLite

2008-02-20 Thread Mark Johnson
Michael Vrable wrote: > On Wed, Feb 20, 2008 at 03:09:50PM -0700, Mark Johnson wrote: > >> Found the error message. It is buried in gnucash.trace. This is >> really not sufficient notification that data has been dropped. >> >> Here is a sample entry fro

Re: GDA Missing records in SQLite

2008-02-20 Thread Mark Johnson
Mark Johnson wrote: > Graham Leggett wrote: > >> Mark Johnson wrote: >> >> >>> By examining which transactions, accounts, and splits were missing >>> from SQLite (as compared to MySQL), I was able to determine that >>> anything whic

Re: GDA Missing records in SQLite

2008-02-20 Thread Mark Johnson
Graham Leggett wrote: > Mark Johnson wrote: > >> By examining which transactions, accounts, and splits were missing >> from SQLite (as compared to MySQL), I was able to determine that >> anything which had a single quote in a string (description, name, & >>

GDA Missing records in SQLite

2008-02-19 Thread Mark Johnson
By examining which transactions, accounts, and splits were missing from SQLite (as compared to MySQL), I was able to determine that anything which had a single quote in a string (description, name, & memo fields) failed to be inserted into SQLite. This is a one-to-one correspondence. i.e. any

Re: GDA save missing records

2008-02-19 Thread Mark Johnson
Graham Leggett wrote: > Keith Bellairs wrote: > >> Speaking as a user and not someone busting his butt on this, I hate >> the idea of "unlimited" everything when we go to a DB. Most of our >> databases have a mechanism (BLOB/CLOB) to store really big things, >> usually at the cost of indexing or

Re: GDA save missing records

2008-02-17 Thread Mark Johnson
Phil Longstaff wrote: > Derek Atkins wrote: > >> Mark Johnson <[EMAIL PROTECTED]> writes: >> >> >> >>> Mark Johnson wrote: >>> >>> >>>> This appears to be separate from the SERIAL problem of libgda

Re: GDA save missing records

2008-02-15 Thread Mark Johnson
Mark Johnson wrote: > This appears to be separate from the SERIAL problem of libgda's > PostgreSQL provider as PostgreSQL has the highest number of splits. > (Most complete? Are there duplicates?) > > > Oops, no it doesn't have the highest number of splits.

GDA save missing records

2008-02-15 Thread Mark Johnson
Configuration: libgda 3.1.2 gnucash-gda SVN16943 PostgreSQL 8.2.6 MySql 5.0.51 Sqlite 3.3.7 Today, I deleted all the gnucash databases (Well, I just started a new file for SQLite:-). I made three copies of my current gnucash XML data, and loaded them into three instances of gnucash SVN (running

Re: GDA interim benchmarking synopsis

2008-02-15 Thread Mark Johnson
Derek Atkins wrote: > Mark Johnson <[EMAIL PROTECTED]> writes: > > >>> I'm really beginning to wonder if we need to write special SQL >>> based on the database we're using in order to tune the performance >>> because of issues like this? Yes,

Re: gda crash in load_owner() with PostgreSQL backend

2008-02-14 Thread Mark Johnson
Graham Menhennitt wrote: > Mark Johnson wrote: > >> Graham Menhennitt wrote: >> >>> Phil Longstaff wrote: >>> >>> >>>> Graham Menhennitt wrote: >>>> >>>> >>>>> saved. I t

Re: GDA: empty PostgreSQL table failed workaround

2008-02-14 Thread Mark Johnson
Graham Leggett wrote: > Derek Atkins wrote: > >> I think the question was more: Does every table have to HAVE >> a primary key? Yes, the primary key must be unique, but what >> if a table has no primary key? Is that still okay? > > It's perfectly ok, yes - but primary keys are used heavily for

Re: GDA interim benchmarking synopsis

2008-02-14 Thread Mark Johnson
Derek Atkins wrote: > Hi, > > Mark Johnson <[EMAIL PROTECTED]> writes: > > [snip] > >> SQLite and MySql are completely opposite as to which queries perform >> well and poorly. That's why I want to see if I can adjust the queries >> and indices

Re: gda crash in load_owner() with PostgreSQL backend

2008-02-14 Thread Mark Johnson
Graham Menhennitt wrote: > Phil Longstaff wrote: > >> Graham Menhennitt wrote: >> >> >>> saved. I then try to load from the DB using a command line parameter of >>> the DSN. It runs for a few seconds and then crashes with a segmentation >>> violation. >>> >>> >> I just commi

Re: GDA: empty PostgreSQL table failed workaround

2008-02-14 Thread Mark Johnson
Derek Atkins wrote: > Mark Johnson <[EMAIL PROTECTED]> writes: > > >> Phil Longstaff wrote: >> >>> The slot_id is used to provide a unique primary key. I don't know if it >>> would work to have the slots table have *no* key, but have

GDA interim benchmarking synopsis

2008-02-14 Thread Mark Johnson
I won't post specific numbers here yet. I still have to explore some adjustments to the queries, etc. On SQLite, I ran VACUUM and ANALYZE prior to testing. On MySql, I ran ANALYZE on each table. It doesn't have a VACUUM command. (VACUUM probably did nothing for SQLite anyway as a freshly sa

Re: GDA: empty PostgreSQL table failed workaround

2008-02-13 Thread Mark Johnson
Phil Longstaff wrote: > The slot_id is used to provide a unique primary key. I don't know if it > would work to have the slots table have *no* key, but have an index on > the obj_guid field. The obj_guid field can't be the primary key because > I believe a primary key needs to be unique. Mark

Re: GDA: empty PostgreSQL table failed workaround

2008-02-13 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> Previously, I had suggested a workaround for the empty PostgreSQL slots >> table problem. >> >> I have now tried the work-around for the empty slots table problem with >> PostgreSQL. The type SERIAL is

GDA: empty PostgreSQL table failed workaround

2008-02-13 Thread Mark Johnson
Previously, I had suggested a workaround for the empty PostgreSQL slots table problem. I have now tried the work-around for the empty slots table problem with PostgreSQL. The type SERIAL is simply a convenience, and not a real type. I had hoped the convenience extended to ALTER TABLE, but it

Re: GDA: PostgreSQL empty slots table

2008-02-11 Thread Mark Johnson
Phil Longstaff wrote: > > It seems to me as though I am going to need to take a step back and > think for a bit. Any comments are welcome. When I started this, I > chose the 3.x series for libgda because it was almost ready for > release. I was not experienced enough in the linux release worl

Re: GDA: PostgreSQL empty slots table

2008-02-09 Thread Mark Johnson
Phil Longstaff wrote: > > I just saw an e-mail on the libgda mailing list which said that > GdaQuery might be deprecated in the 4.0 series. I just saw that too. It is disappointing. You have put in a lot of work using the GdaQuery. I had compiled the V4 branch with the idea of testing it with

Re: GDA: PostgreSQL empty slots table

2008-02-09 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: >> The slots table includes an id field which is "auto_increment". >> PostgreSQL does not implement that keyword. Instead, it appears to >> accept it, but ignore it when creating the table. (This may actually >

GDA: PostgreSQL empty slots table

2008-02-07 Thread Mark Johnson
The slots table includes an id field which is "auto_increment". PostgreSQL does not implement that keyword. Instead, it appears to accept it, but ignore it when creating the table. (This may actually be libgda's PostgreSQL provider doing that.) Gnucash-gda relies upon that field auto-increm

GDA register open queries

2008-02-07 Thread Mark Johnson
Phil, From the svn change log: r16924 | plongstaff | 2008-02-03 14:16:06 -0700 (Sun, 03 Feb 2008) | 8 lines When opening a register, there are now 5 queries: 1) get tx guids for all splits in the register 2) get all tx'es f

GDA svn 16927 performance

2008-02-06 Thread Mark Johnson
Phil, I just did some timing tests with the latest svn (16927). VAST improvements in opening the Register! Comparing svn16921 to svn16927, using the MySql provider, the time to open one register went from 4:11 to 0:19. Using the PostgreSQL provider, it went from 18:15 to 0:21. (I believe th

GDA branch crash

2008-02-06 Thread Mark Johnson
Using svn 16927 of gda-dev2. The following command line: $ ./gnucash gda://gnucashpgsql82x results in the program quitting unexpectedly when the splash screen gets to "loading data". It displays a dialog to that effect, and offering to inform the developers, etc. Note that I forgot to put the

Re: GDA: trouble with MySql

2008-02-06 Thread Mark Johnson
Mark Johnson wrote: > Changing lines 114 & 115 of gnc-backend-gda.c to: > gchar* username = NULL; > gchar* password = NULL; > has helped. The error message is no longer displayed. And gnucash > appears to be saving my test data to MySql. I am not sure this is the > best

Re: GDA: trouble with MySql

2008-02-02 Thread Mark Johnson
Mark Johnson wrote: > Phil, > I wanted to try gnucash-gda with MySql. I suspect the postgresql > provider of poor performance and wanted to see how the performance of > MySql compared. > > I have created the db manually and tested the gda connection with > gnome-da

Re: GDA: trouble with MySql

2008-01-30 Thread Mark Johnson
Nigel Titley wrote: > Albert Lash wrote: >> On second thought I'm not sure if MySQL has ever been used with >> GnuCash, or if it supported > > Surely the whole point about using the gda library was that the > backend database doesn't matter. > > Nigel > That's the goal. Currently, the gda bac

GDA: possible problem

2008-01-30 Thread Mark Johnson
Phil, I decided to check my postgresql log file for insight into the poor performance. While doing so, I noticed the following: ERROR: null value in column "slot_id" violates not-null constraint STATEMENT: INSERT INTO slots (obj_guid, name, slot_type, int64_val,

GDA: trouble with MySql

2008-01-30 Thread Mark Johnson
Phil, I wanted to try gnucash-gda with MySql. I suspect the postgresql provider of poor performance and wanted to see how the performance of MySql compared. I have created the db manually and tested the gda connection with gnome-database-properties-3.0 successfully. I am using the latest svn

GDA Test: change account of split

2008-01-22 Thread Mark Johnson
I am using SVN16880 of gnucash-gda2 branch. One cannot change the account of a split in an existing transaction. I opened gnucash and it opened the last-used db. Then, I opened a register, and selected a transaction. I clicked one of its splits (Register is in auto-split mode) and moved it t

Re: PATCH: (gda-dev2): windows changes (sqlite only)

2008-01-20 Thread Mark Johnson
Nathan Buchanan wrote: > HI Phil, Andreas! > > I'm attaching a patch that gets gda setup for windows. This patch only deals > with sqlite. > > A few items of note: > -libgda used setenv instead of g_setenv. This has been patched and is > http://bugzilla.gnome.org/show_bug.cgi?id=510739 > -libgda us

Re: GDA referential integrity

2008-01-17 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> Having successfully loaded my xml file into gnucash-gda, I saved it to a >> new postgresql database. As Phil mentioned, the performance was poor. >> I have several years of data, and it took hours to save. The sav

GDA referential integrity

2008-01-17 Thread Mark Johnson
Having successfully loaded my xml file into gnucash-gda, I saved it to a new postgresql database. As Phil mentioned, the performance was poor. I have several years of data, and it took hours to save. The save completed sometime during the night, so I don't know exactly how long it took. I t

Re: GDA testing

2008-01-16 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> Here is an excerpt (including the qof_session_load_backend) from the >> resulting gnucash.trace: >> * 23:11:30 INFO [gnc_commodity_table_insert] insert >> 0x84856e0 XAG into nsp=0x84567c

Re: GDA testing

2008-01-15 Thread Mark Johnson
Phil Longstaff wrote: > Yes, this is the interesting part. Both the GDA and XML backends are > registered for the file:// url which is what you get when you don't > supply a URL or if you use the open file dialog. The GDA backend checks > to see whether it likes the file, and if not, rejects i

Re: GDA testing

2008-01-14 Thread Mark Johnson
Mark Johnson wrote: > In response to your latest e-mail, here is the excerpt from > /tmp/gnucash.trace: > * 22:17:29 INFO [gnc_commodity_table_insert] insert > 0x8452c70 VND into nsp=0x8260fa0 CURRENCY > * 22:17:29 INFO [gnc_commodity_table_insert] insert > 0x8452d88 YER

Re: GDA testing

2008-01-14 Thread Mark Johnson
Phil Longstaff wrote: > Mark Johnson wrote: > >> Using: SVN 16836 gda-dev2 branch. >> Postgresql 8.2.6 >> >> 1. start gnucash with --nofile option >> 2. open read-only copy of existing xml file. >> >> > I assume you mean this was wit

GDA testing

2008-01-14 Thread Mark Johnson
e. I had not select anything to cause it to use SQLite. I did not investigate the contents of this file. However, it was less than one tenth the size of the compressed xml file. I do not believe that this file should have been created. Mark Jo

Re: Looking for GDA backend testers

2008-01-13 Thread Mark Johnson
Phil Longstaff wrote: > A couple of people have e-mailed me asking if they can test the GDA > backend. I think I'm ready for this. > > Build requirements. I build with libgda 3.0.0 > Recently, I successfully built SVN 16836 with libgda 3.1.2. I'll do what I can to help test this. I'm just

Re: Small feature request: better tab behavior in Split transactions

2007-07-30 Thread Mark Johnson
Josh Sled wrote: > Christopher Blunck <[EMAIL PROTECTED]> writes: > >> seen in step #5. If you press tab on step #5 and you are brought to >> a new subtransaction line why doesn't that ALWAYS happen? >> > > Because there's a bug in the tab handling. I believe it's already been > filed,

Re: Undo

2007-02-28 Thread Mark Johnson
Wasn't there some suggestion that an audit trail would be useful in a distributed environment a while back? It sounds like it would have a great deal in common with the undo. Mark Peter Selinger wrote: >Here is how I think undo can be done in a distributed environment. I >think the undo hist

Re: A couple of questions

2007-02-07 Thread Mark Johnson
Phil Longstaff wrote: > Phil, > > the latest code in gda-dev branch is not compiling. Here is the error I > got: > > Yes, I know. For various reasons, I have been unable to fix that > until now. I will commit a fix later today. > > Phil New error: gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I..

Re: A couple of questions

2007-02-06 Thread Mark Johnson
Phil Longstaff wrote: > Phil, > > the latest code in gda-dev branch is not compiling. Here is the error I > got: > > Yes, I know. For various reasons, I have been unable to fix that > until now. I will commit a fix later today. Excellent, I'm doing a test build now. By the way, I have updat

Re: A couple of questions

2007-02-06 Thread Mark Johnson
Phil Longstaff wrote: > * GDA. Maybe Phil wants some help? > > > >I'd be happy for some help. The GDA project will replace the old postgresql >backend with a GDA (Gnome Data Access) backend. GDA provides a GObject-based >interface to any db provider. If you want to help, just e-mail me and

Re: No common currency warnings

2007-01-25 Thread Mark Johnson
Try "Check and Repair". It should be under the Actions menu. Probably select the accounts containing the affected transactions for "Check and Repair". This used to happen when replaying logs, but that was fixed. The transactions were created without a currency, resulting in the same error. The

Re: gda-dev does not compile.

2007-01-10 Thread Mark Johnson
An update this morning yielded the following: gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I../../.. -I../../.. -I../../.. -I.. -I../.. -DLOCALE_DIR=\"/mnt/raid/home/mj/gnucash-gda/gnucash.15335/share/locale\" -I../../../src/backend -I../../../src/engine -I../../../src/core-utils -I../../../lib/lib

Re: gda-dev does not compile.

2007-01-09 Thread Mark Johnson
Mark Johnson wrote: >gnc-backend-util.c and .h have been added. I am trying a build now. > >Mark > >___ >gnucash-devel mailing list >gnucash-devel@gnucash.org >https://lists.gnucash.org/mailman/listinfo/gnucash-devel >

Re: gda-dev does not compile.

2007-01-09 Thread Mark Johnson
Derek Atkins wrote: >Mark Johnson <[EMAIL PROTECTED]> writes: > > > >>Compiling the latest gda-dev failed as follows: >> >> >[snip] > > >>.deps/gnc-backend-gda.Tpo -c gnc-backend-gda.c -fPIC -DPIC -o >>.libs/gnc-backend-gda.o &

gda-dev does not compile.

2007-01-08 Thread Mark Johnson
Compiling the latest gda-dev failed as follows: gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I../../.. -I../../.. -I../../.. -I.. -I../.. -DLOCALE_DIR=\"/opt/gnucash-svn15330/share/locale\" -I../../../src/backend -I../../../src/engine -I../../../src/core-utils -I../../../lib/libc -I../../../lib/lib

Re: gda-dev; new libgda version

2006-12-29 Thread Mark Johnson
Daniel Espinosa wrote: >> (http://bugzilla.gnome.org/show_bug.cgi?id=389821) >> > > I'll try to fix it when possible or talk with Vivien, please inform > this in gnomedb-devel list. > Was it not enough to file the bug report? Someone did go to the trouble of adding version 2.99.x to the list of

Re: gda-dev; new libgda version

2006-12-29 Thread Mark Johnson
Daniel Espinosa wrote: > > Sorry I forget to add that you need to use #ifdef GDA (or any variable > you set using configure.in in gnucash) the the code you want to be > missed at compile time, please see at the code where you set the URI > handler (may exist other files I don't remember for the mo

Re: gda-dev; new libgda version

2006-12-28 Thread Mark Johnson
Derek Atkins wrote: Quoting Mark Johnson <[EMAIL PROTECTED]>: What I'm looking at is using AC_ARG_ENABLE to make a --disable-gda argument, so that for the gda-dev branch (at least for now) building the gda backend would be the default. Take a look at what we do for AC_ARG

Re: gda-dev; new libgda version

2006-12-28 Thread Mark Johnson
Derek Atkins wrote: >Mark Johnson <[EMAIL PROTECTED]> writes: > > > >>A new version of libgda has been released. It is 2.99.2. They have >>bumped the ABI version to 3.0. Consequently, libgda-2.0.pc is now >>libgda-3.0.pc. Therefore, after upgrading t

gda-dev; new libgda version

2006-12-27 Thread Mark Johnson
A new version of libgda has been released. It is 2.99.2. They have bumped the ABI version to 3.0. Consequently, libgda-2.0.pc is now libgda-3.0.pc. Therefore, after upgrading to libgda 2.99.2, the build in gda-dev branch fails. Further feedback on gda-dev: configure did not fail when libgd

Re: Save to URI [Was: Re: gda-dev does not compile]

2006-12-24 Thread Mark Johnson
Derek Atkins wrote: What's the point of the global, static fb_info? In general static storage is a Bad Idea (TM). Agreed. It's something I copied from 1.8.12, and didn't spend enough time thinking if the global was necessary. It is the storage space where the callback function (for when O

Re: Save to URI [Was: Re: gda-dev does not compile]

2006-12-23 Thread Mark Johnson
Phil Longstaff wrote: First, I thought I had found something when I found the function gtk_file_chooser_set_local_only, but the wretched dialog insists on trying to display the directory of the entered URI when one clicks Save. Naturally, such a directory does not exist. Entering gda://AnAc

Save to URI [Was: Re: gda-dev does not compile]

2006-12-23 Thread Mark Johnson
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.) > > > My understanding is that right now there's not a good way of doing

Re: gda-dev does not compile

2006-12-21 Thread Mark Johnson
Phil Longstaff wrote: >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

Re: gda-dev does not compile

2006-12-20 Thread Mark Johnson
Derek Atkins wrote: > Quoting Mark Johnson <[EMAIL PROTECTED]>: > >>> The PG backend still works, even in 2.0. You just can't use the >>> Save-As dialog to create a new one (because you cannot specify >>> a URI in the interface). So your understand is

Re: gda-dev does not compile

2006-12-20 Thread Mark Johnson
Derek Atkins wrote: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > >>> Maybe. The problem is that GnuCash has multiple backends.. Some of >>> them >>> require the save button, some do not. I think the answer here is that >>> the save button should always exist but only be active when the boo

Re: gda-dev does not compile

2006-12-18 Thread Mark Johnson
Daniel Espinosa wrote: > I strongly recomend to install libgnomedb also, becouse it install a > graphical tool called "gnome-database-properties" wich you can create > the data source (DSN), the username and password to connecto to any > data base server or SQLite, and you can test the connection,

Re: gda-dev does not compile

2006-12-12 Thread Mark Johnson
Mark Johnson wrote: >I've modified the config file as follows: > > > >value="URI=/home/phil/.libgda/sales_test.db"/> > > > > > > > > > > >

Re: gda-dev does not compile

2006-12-11 Thread Mark Johnson
Phil Longstaff wrote: >I've attached a config file which is in ~/.libgda/config. If you use >this, have a MySQL server running with a database named 'gnucash', then >starting gnucash with URI gda://gnucash will connect to and use that >database. > >I haven't tried with anything other than MySQL t

Re: gda-dev does not compile

2006-12-09 Thread Mark Johnson
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 leaving it out. > >Mark &g

Re: gda-dev does not compile

2006-12-09 Thread Mark Johnson
Phil Longstaff wrote: >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. >>> >>> >>Yeah

Re: gda-dev does not compile

2006-12-09 Thread Mark Johnson
Phil Longstaff wrote: >Yes. Fixed in r15194. > >Phil > > > Trying another build. Are you using--enable-compile-warnings? At the moment, I am leaving it out. Mark ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/ma

Re: gda-dev does not compile

2006-12-08 Thread Mark Johnson
Phil Longstaff wrote: >>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-uti

Re: gda-dev does not compile

2006-12-08 Thread Mark Johnson
Phil Longstaff wrote: >Fixed in r15192. > >I've attached a config file which is in ~/.libgda/config. If you use >this, have a MySQL server running with a database named 'gnucash', then >starting gnucash with URI gda://gnucash will connect to and use that >database. > >I haven't tried with anythin

gda-dev does not compile

2006-12-07 Thread Mark Johnson
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=\"/opt/gnucash-svn15190/share/locale\" -I../../../src/backend -I

Re: 2.0.2 and GConf

2006-12-06 Thread Mark Johnson
Derek Atkins wrote: Quoting Mark Johnson <[EMAIL PROTECTED]>: > > Umm, which SVN branch? There's no reference to g-wrap.m4 in trunk. > Indeed, the ONLY reference I see is in a ChangeLog entry: > > # find . -type f | xargs grep g-wrap.m4 > ./ChangeLog~: * macros

Re: 2.0.2 and GConf

2006-12-06 Thread Mark Johnson
Andreas Köhler wrote: >Hi, > >Am Mittwoch, den 06.12.2006, 08:21 -0700 schrieb Mark Johnson: > > >>Quite right. I tried SVN15135 and the error was gone. Thanks, Andreas. >> >> > >Great! One minor note: I did not say that you should compile tru

Re: 2.0.2 and GConf

2006-12-06 Thread Mark Johnson
Andreas Köhler wrote: >Hi, > > > >>>I could imagine that this has been fixed by r15135. Did you use more >>>than one main window and close some of them? >>> >>> >>> >>I had only one instance of gnucash running. Opening and closing a >>single register is my test sequence. It is on the cl

Re: 2.0.2 and GConf

2006-12-05 Thread Mark Johnson
Mark Johnson wrote: > Mark Johnson wrote: > >> Derek Atkins wrote: >> >> >> >>> Mark Johnson <[EMAIL PROTECTED]> writes: >>> >>> >>> >>> >>>> Mark Johnson wrote: >>>> >>>> >>

Re: 2.0.2 and GConf

2006-12-05 Thread Mark Johnson
Mark Johnson wrote: >Derek Atkins wrote: > > > >>Mark Johnson <[EMAIL PROTECTED]> writes: >> >> >> >> >> >>>Mark Johnson wrote: >>> >>> >>> >>> >>> >>>>This d

Re: 2.0.2 and GConf

2006-12-04 Thread Mark Johnson
Derek Atkins wrote: >Mark Johnson <[EMAIL PROTECTED]> writes: > > > >>Mark Johnson wrote: >> >> >> >>>This does not look like the sort of thing that occurs when debugging >>>optimized code, but I am going to try a build without o

Re: 2.0.2 and GConf

2006-12-01 Thread Mark Johnson
Mark Johnson wrote: >This does not look like the sort of thing that occurs when debugging >optimized code, but I am going to try a build without optimization anyway. > > > Obviously, the optimization was interfering with debugging. Here is the gnucash terminal output: [

Re: 2.0.2 and GConf

2006-11-30 Thread Mark Johnson
Andreas Köhler wrote: >Hi, > >Am Dienstag, den 28.11.2006, 20:50 -0700 schrieb Mark Johnson: > > >>In trying gnucash 2.0.2, I noticed that whenever I close a register, I >>get the following two errors: >>[EMAIL PROTECTED]:~$ gnucash >> >>(

Re: 2.0.2 and GConf

2006-11-29 Thread Mark Johnson
David Hampton wrote: >On Wed, 2006-11-29 at 14:23 -0700, Mark Johnson wrote: > > >>... >> >>#6 0xb7529807 in gnc_gconf_remove_notification (object=0x814d940, >>section=0x0, whoami=0x809aeb0 "\030Ý\t\b\017") >>at gnc-gconf-utils.c:867 &g

Re: 2.0.2 and GConf

2006-11-29 Thread Mark Johnson
Atkins wrote: >Can you run gnucash under gdb with --g-fatal-warnings and find >a stack trace for where the gconf message comes from in the >gnucash code? > >-derek > >Mark Johnson <[EMAIL PROTECTED]> writes: > > > >>In trying gnucash 2.0.2, I notice

2.0.2 and GConf

2006-11-28 Thread Mark Johnson
In trying gnucash 2.0.2, I noticed that whenever I close a register, I get the following two errors: [EMAIL PROTECTED]:~$ gnucash (gnucash:27727): GConf-CRITICAL **: file gconf-listeners.c: line 444 (ltable_remove): assertion `node != NULL' failed (gnucash:27727): GConf-CRITICAL **: file gconf-

Re: SQL backend for GnuCash 2

2006-10-26 Thread Mark Johnson
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 recent

Re: SQL backend for GnuCash 2

2006-10-25 Thread Mark Johnson
Derek Atkins wrote: >Quoting Phil Longstaff <[EMAIL PROTECTED]>: > > > >>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; a

Re: SQL backend for GnuCash 2

2006-10-22 Thread Mark Johnson
Derek Atkins wrote: >Phil, > >Quoting Phil Longstaff <[EMAIL PROTECTED]>: > > > > ... >>Is there any current vision for database use? Of the 3 databases I've >>listed, I've only used MySQL. SQLite would remove the need for an >>external db server, though embedded MySQL would also remove thi

Re: Newbie Thoughts

2006-08-19 Thread Mark Johnson
Tom Browder wrote: >After my first pass at starting a new gnucash data file importing from a >QIF file, I see a couple of things that would help me: > > -If I read the converted file correctly, commodities are carried to 5 >decimal places by default. Since several of my account sources are >

  1   2   >