Bug 611936 and the 2.4.0 release

[Geert Janssens]

Mike and John,

Thank you both for your feedback (here and on the bug report).

I think it's safe to conclude that sqlite3 doesn't fly on Fedora 12 (3 
independent reports so far), it doesn't work on Mandriva 2010.0 either.

It does work on OS X though, which also uses libdbi-0.8.3.
Debian is still using 0.8.2 currently.
It'd be useful to hear from other platforms as well, like openSuSE (at least 
10.2 ships libdbi 0.8.3).

Is sqlite3 support on Fedora imporant enough to consider this bug blocking for 
2.4 ? I would think so as the db support is a major feature for 2.4 and 
sqlite3 is the candidate to become the future default backend.

Do you agree on this ?

Geert

On Monday 9 August 2010, Mike Evans wrote:
> On Monday August 9 2010 11:01:32 Geert Janssens wrote:
> > On Monday 9 August 2010, Mike Evans wrote:
> > > What configure option do I need to include sqlite3?  Running configure
> > >
> > >  --help doesn't help.
> >
> > That would be --enable-dbi. This will build gnucash with dbi support. To
> > actually use sqlite3 with dbi, you will need to install the dbi-sqlite3
> > driver (it's called libdbi-dbd-sqlite on Fedora 13).
> >
> > Geert
> 
> Thanks Geert.
> 
> On saving I get a dialog with "The server at URL
> sqlite3:///home/mikee/Projects/gnucash-mfe/test.sqlite.gnucash experienced
>  an error or encountered bad or corrupt data."
> 
> Then on reloading  all transactions  are zero.
> 
> Error output is lots of:
>  12:44:03  CRIT <gnc.engine>     xaccSplitSetValue: assertion
> `gnc_numeric_check(amt) == GNC_ERROR_OK' failed
> * 12:44:03  CRIT <gnc.engine>     xaccSplitSetAmount: assertion
> `gnc_numeric_check(amt) == GNC_ERROR_OK' failed
> * 12:44:03  CRIT <gnc.engine>     xaccSplitSetValue: assertion
> `gnc_numeric_check(amt) == GNC_ERROR_OK' failed
> * 12:44:03  CRIT <gnc.engine>     xaccSplitSetAmount: assertion
> `gnc_numeric_check(amt) == GNC_ERROR_OK' failed
> 
> and several:
> 
> 12:44:03  WARN <gnc.backend.sql>     [load_taxtable_guid()] Taxtable ref
> '5357d7648a50bf2971ae7ebadd337c7e' not found
> * 12:44:03  WARN <gnc.backend.sql>     [load_taxtable_guid()] Taxtable ref
> '5357d7648a50bf2971ae7ebadd337c7e' not found
> * 12:44:03  WARN <gnc.backend.sql>     [load_taxtable_guid()] Taxtable ref
> '5357d7648a50bf2971ae7ebadd337c7e' not found
> 
> 
> Saving as mysql I also get a dialog with:
> 
>  The server at URL mysql://USER:PASSWORD@localhost/gnucash experienced an
> error or encountered bad or corrupt data.
> 
> However, the data loads back OK.
> I hadn't tested mysql for a while so I'm not sure when the problem was
> introduced but It used to work fine with no error dialog.  I should open a
>  new bug I guess.
> 
> 
> This is on Fedora 12 with libdbi-dbd-sqlite-0.8.3-5.fc12.i686 and
> libdbi-dbd-mysql-0.8.3-5.fc12.i686
>