Help with libdbi code

Colin Law clanlaw at
Sat May 7 17:14:17 EDT 2016

On 7 May 2016 at 21:44, Colin Law <clanlaw at> wrote:
> ...
> I am running with
> type_name = "TIMESTAMP NULL";
> and have not found any problems so far.

On further investigation I am getting errors.  When I attempt to save
as mysql I get
CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1067: Invalid
default value for 'date_closed'
This is related to gnc-order-sql.c line 64.  I suspect the orders
table does not use BCT_DATETIME for its column definitions.

Will investigate further tomorrow.


More information about the gnucash-devel mailing list