gnucash and mysql: Incorrect datetime value for column 'post_date'

[Colin Law]

On 16 October 2017 at 10:50,  <joerg_diederich at freenet.de> wrote:
> Hello,
>
> I'm trying to convert my existing gnucash account from xml to mysql. I created a new mysql database, but when I try to save my data into this database with gnucash I get the following error message:

Don't manually create the database first. Just use File > Save As and
give it a database name. You can overwrite an existing gnucash
database in this way but don't try to overwrite an existing db unless
it was created by gnucash. I am not guaranteeing that this is the
problem, but try that first.

>
> Operating System: Linux opensuse LEAP 42.2
> gnucash:               gnucash-2.6.16-3.3.1.x86_64
> mysql:                  mariadb-10.0.31-20.7.1.x86_64

I don't know whether anyone has tried it with mariadb, but it should
be ok as maria is supposed to be a dropin replacement for mysql.

Colin