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:passw...@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 _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
