Timestamps in Gnucash Mysql

2009-08-12 Thread marcus.wolschon
I just found out that gnucash stores DatePosted and DateEntered as Strings instead of the proper DateTime or Timestamp sql data-types. Why is that? In XML it already uses a proper date-format. This makes is very hard to sort by date in SQL-queries and to select a range as you need a complex full

unable to find a common currency in txn X, and that is strange

2009-08-12 Thread Graham Menhennitt
I'm attempting to diagnose a corruption I have in my GC data file (XML). I started GC 2.3.3 with --debug and am looking through the trace file. I seem to have lots of entries of the form: * 19:59:40 WARN [xaccTransFindOldCommonCurrency()] unable to find a common currency in txn 13db240e2d97ba424

Re: Timestamps in Gnucash Mysql

2009-08-12 Thread Phil Longstaff
On August 12, 2009 03:06:40 am marcus.wolsc...@googlemail.com wrote: > I just found out that gnucash stores > DatePosted and DateEntered as Strings > instead of the proper DateTime or Timestamp > sql data-types. > > Why is that? In XML it already uses a proper > date-format. > > This makes is very

Re: GnuCash Crash when viewing an account with posted transaction

2009-08-12 Thread Derek Atkins
Hi, Mark Sluser writes: > I am using GnuCash 2.3.3 and postgresql backend. > I had to manually import some invoices/entries and > transactions/splits/ slots and now when I view an account with > invoices posted, GnuCash crashes. What do you mean by "manually import some invoices/entries"? How

Re: Reg Run Balance for Subaccount view

2009-08-12 Thread Derek Atkins
Hi Tim, Tim M writes: > Hi guys, > > I wrote a (beta) patch to display the running register balance in "View > Subaccounts" register view, which I submitted to the mailing list on July > 10th. The original thread is here: > > https://lists.gnucash.org/pipermail/gnucash-devel/2009-July/025807.ht

Re: Patch for Cash Flow Report

2009-08-12 Thread Derek Atkins
David, David Eisner writes: > Hi. I've been looking into the Cash Flow report (cash-flow.scm) to > isolate some potential bugs. This entailed learning Scheme (I > programmed a little Common Lisp in a previous life). So far I've > filed one bug report and submitted a patch (against 2.2.9): > >

Re: Timestamps in Gnucash Mysql

2009-08-12 Thread Phil Longstaff
On August 12, 2009 08:25:31 am Phil Longstaff wrote: > On August 12, 2009 03:06:40 am marcus.wolsc...@googlemail.com wrote: > > I just found out that gnucash stores > > DatePosted and DateEntered as Strings > > instead of the proper DateTime or Timestamp > > sql data-types. > > > > Why is that? In

Re: unable to find a common currency in txn X, and that is strange

2009-08-12 Thread Derek Atkins
Can you try going to backup .xac files and seeing when it might have changed? -derek Graham Menhennitt writes: > I'm attempting to diagnose a corruption I have in my GC data file (XML). > I started GC 2.3.3 with --debug and am looking through the trace file. I > seem to have lots of entries of

Re: Timestamps in Gnucash Mysql

2009-08-12 Thread Derek Atkins
Phil Longstaff writes: > Also, sqlite does not have a datetime or timestamp but needs to use strings, > and I've been coding mainly for sqlite, with mysql and pgsql taking 2nd place. > > Gnucash has both dates, and date-times. For dates, I can use CHAR(8) for > sqlite, DATE for mysql and pgsql

Re: unable to find a common currency in txn X, and that is strange

2009-08-12 Thread Graham Menhennitt
Thanks for replying Derek. Yeah, I'll be doing that. I just wondered whether those messages were expected, or something to worry about. Graham Derek Atkins wrote: > Can you try going to backup .xac files and seeing when it might have > changed? > > -derek > > Graham Menhennitt writes: > > >>

Re: Timestamps in Gnucash Mysql

2009-08-12 Thread Phil Longstaff
Derek, yes, I was planning to store w/o time zone, in UTC, but just wanted other people's input, because I know this has been a can of worms. Phil From: Derek Atkins To: Phil Longstaff Cc: gnucash-devel@gnucash.org Sent: Wednesday, August 12, 2009 9:22:24 A

MySQL sync

2009-08-12 Thread Vladimir Bashkirtsev
Hello, I was testing latest development version with MySQL backend and in general I was satisfied with the results. Great piece of software! Now here the scenario I want to happen: I have PHP scripts which deal with GnuCash data in MySQL DB. It is not a problem to read and show account recor

Re: MySQL sync

2009-08-12 Thread Phil Longstaff
There is currently no support for simultaneous access to the db by more than just gnucash. There are no plans to add it unless someone wants to step up and work on it. Phil From: Vladimir Bashkirtsev To: gnucash-devel@gnucash.org Sent: Wednesday, August 12,

2.3.3 saving to postgresql causes zombie scheduled transactions

2009-08-12 Thread Graham Menhennitt
I found (one of) the corruptions that I mentioned in my email of yesterday! I have an existing GC XML file that contains a scheduled transaction that had "repeats until" selected with a date of 28/02/08 (I'm using dd/mm/yy format). After saving to postgresql and restarting GC, the same transaction

Re: 2.3.3 saving to postgresql causes zombie scheduled transactions

2009-08-12 Thread Phil Longstaff
On August 12, 2009 04:53:29 pm Graham Menhennitt wrote: > I found (one of) the corruptions that I mentioned in my email of yesterday! > > I have an existing GC XML file that contains a scheduled transaction > that had "repeats until" selected with a date of 28/02/08 (I'm using > dd/mm/yy format). A