Help with libdbi code
clanlaw at gmail.com
Sat May 7 09:00:41 EDT 2016
On 7 May 2016 at 12:23, Colin Law <clanlaw at gmail.com> wrote:
> On 7 May 2016 at 12:01, John Ralls <jralls at ceridwen.us> wrote:
>> Hmm, the trace files from the bug report seemed to show that the error was from saving a slot row with a 0-valued date rather than from creating a table with a default value of 0.
> No doubt you are right (again), it is probably not the actual creation
> but the writing that is the issue. Me jumping to conclusions again.
> I will investigate whether it is necessary to change the options for
> creating the db.
Actually, looking at the trace file again, it appears we were both
correct. The first error in the file is
CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1067: Invalid
default value for 'date'
where it is complaining about the default value being 0, and later
there are errors complaining about writing into the slots table with a
NULL value for a date.
More information about the gnucash-devel