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

2017-10-17 Thread Maf. King
On Tuesday, 17 October 2017 14:24:58 BST Joerg Diederich wrote: > Hi Maf, > > just to inform you. Your assumption was totally correct. After fixing the > date in the xml file I succeeded in importing the data into my mysql > database. Many thanks to you and all others who friendly shared their >

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

2017-10-17 Thread Joerg Diederich
Hi Maf, just to inform you. Your assumption was totally correct. After fixing the date in the xml file I succeeded in importing the data into my mysql database. Many thanks to you and all others who friendly shared their thoughts concerning my issue. I'm still wondering a little how I could

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

2017-10-16 Thread Joerg Diederich
Hi Maf, thank you very much for this hint. I guess it points into the right direction. I've just checked my xml file and indeed, there is an entry with such a strange date. I will try to fix it as suggested and look, if I can save the data into my mysql database. Joerg On Mon, 16 Oct 2017

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

2017-10-16 Thread Maf. King
On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote: > > A date in 1898 (as reported) looks more like a data error. I know the OP mentioned Linux - but isn't that date something to with a (fixed/ resolved) windows bug creating transactions from "before time existed" Just rings a distant

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

2017-10-16 Thread 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 wrote: > On 16 October 2017 at 10:50,

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

2017-10-16 Thread John Ralls
> On Oct 16, 2017, at 2:50 AM, joerg_dieder...@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: > > <---

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

2017-10-16 Thread Colin Law
On 16 October 2017 at 10:50, 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