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

Joerg Diederich joerg_diederich at freenet.de
Mon Oct 16 16:43:28 EDT 2017


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


More information about the gnucash-user mailing list