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

joerg_diederich at freenet.de joerg_diederich at freenet.de
Mon Oct 16 05:50:59 EDT 2017


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:

<--- cut here --->
mysql error: Incorrect datetime value: '18981201105900' for column 'post_date' at row 1
<--- cut here --->

In another thread I found the recommendation to adjust the sql_mode using

sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Unfortunately, this doesn't change the behaviour for me.


Here are some version information:

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


Any hint how to get rid off this error is really appreciated.
 
Regards,
Joerg

Mit TravelXtra profitieren Sie von 5% Rückvergütung auf den Reisepreis  – bekannte dt. Reiseanbieter und ein umfangreiches Reiseangebot wie im Reisebüro!
https://email.freenetde/reisen/index.html


More information about the gnucash-user mailing list