Unable to convert gnucash to mysql after upgrading to 16.04

[Colin Law]

On 1 May 2016 at 14:21, Lewis Balentine <lewis at keywild.com> wrote:
> see this ....
> http://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field

You are right, that is the problem, thanks.  Ensuring that the server
is configured with NO_ZERO_DATE not set fixes the problem.  I wrongly
discounted this initially as the problem only started with mysql 5.7,
and the original question was four years ago.

Colin

>
>
>
> On 05/01/2016 08:07 AM, Lewis Balentine wrote:
>>
>> Well I am just a dumb old redneck but remember years ago trying to port
>> some data from Oracle to MS SQL. After an inordinate amount of time it was
>> discovered that the problem was MS SQL did not like null dates (Oracle ..
>> at the time .. could not have cared less). Just a thought ...
>>
>> On 05/01/2016 07:55 AM, Colin Law wrote:
>> Attache is the tracefile. It starts * 12:27:08 CRIT
>> <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1067:
>> Invalid default value for 'date' *
>>
>> ....
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.