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

[Joerg Diederich]

Hi Colin,

thank you very much for the quick response to my post. I dropped the database and let gnucash create it. But I get the same error message again.

Joerg


On Mon, 16 Oct 2017 14:46:31 +0100
Colin Law <clanlaw at gmail.com> wrote:

> 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
>