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 _______________________________________________ gnucash-user mailing list gnucash-user@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.
