Bug 611936 and the 2.4.0 release

[Mike Evans]

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





-- 
GPG Key: 1024D/050895C2
Keyserver: http://pgp.mit.edu/          
Search String: 0x050895C2