I can't find working libdbi version

John Ralls jralls at ceridwen.us
Wed Jan 26 22:58:17 EST 2011


On Jan 26, 2011, at 7:36 PM, Christoph Holtermann wrote:

> Hello !
>>  
>> If make debug didn't work, what failed? Did you edit configure to remove -ffast-math from the CFLAGS for Linux before running it?
>> 
>> 
> I edited configure and removed -ffast-math and ran "make". The result was the same as with "make debug".
> I get stuck at the error message :
> 
> "The library "libdbi" installed on your system doesn't correctly store large numbers.  This means GnuCash cannot use SQL databases correctly.  Gnucash will not open or save to SQL databases until this is fixed by installing a different version of "libdbi".  Please see https://bugzilla.gnome.org/show_bug.cgi?id=611936 for more information."
> 
> The logfile says :
> * 04:19:18  INFO <qof.session> [qof_session_load_backend]  selected GnuCash Libdbi (MYSQL) Backend
> * 04:19:18  INFO <gnc.backend.dbi> [mysql_error_fn] DBI error: 1367: Illegal double '797692e+307' value found during parsing
> * 04:19:18  INFO <gnc.backend.dbi> [mysql_error_fn] Note: GbcDbiSqlConnection not yet initialized. Skipping further error processing.
> * 04:19:18  WARN <gnc.backend.dbi> [conn_test_dbi_library()] Test_DBI_Library: Failed to insert test row into table
> * 04:19:18  INFO <qof.session> [qof_session_begin] Done running session_begin on backend
> * 04:19:28  CRIT <gnc.backend.dbi> gnc_dbi_unlock: assertion `dbi_conn_error( dcon, NULL ) == 0' failed
> 
> I tried that for both (libdbi&libdbi-drivers CVS) and (libdbi-0.8.4, drivers 0.8.3-1).
> 

OK, that's not what I thought you meant.

In libdbi-drivers is a test program with essentially the same code as the test in Gnucash  (because that's where I lifted it from). So in your new libdbi-drivers run make check. The test doesn't fail (though it should) when the values aren't saved correctly,
so you have to look at the output: If it isn't working, the longlong, ulonglong, double, and date values will return 0.

If that checks out OK, then very likely Gnucash isn't picking up the new library. Ldd can be helpful.

Regards,
John Ralls




More information about the gnucash-devel mailing list