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

[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 encounter a Windows bug in my pure Linux installation. 

Joerg

On Mon, 16 Oct 2017 22:43:28 +0200
Joerg Diederich <joerg_diederich at freenet.de> wrote:

> 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 20:46:14 +0100
> "Maf. King" <maf at chilwell.net> wrote:
> 
> > 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 bell with me...
> > 
> > Maybe a grep of the xml file for something like the problem timestamp and fixing 
> > the data manually?  A postdate won't be visible in the registers anywhere 
> > AFAIK.
> > 
> >  Back up the data file first.... then back it up again...
> > 
> > 0.02
> > Maf.
> > 
> > 
> > 
> > _______________________________________________
> > 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.
>