On 16 October 2017 at 7:27, John Ralls said: > > > > 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: > > > > <--- 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_DIVISIO > > N_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. > > We need to change the schema for MySQL/MariaDB to use DATETIME instead of > TIMESTAMP; the latter’s date range is only 1 Jan 1970-15 Jun 2038. > It’s on my to-do list for 2.8. > > For 2.6 you’ll need to use Postgresql instead if you need your books to > run before 1970.
A date in 1898 (as reported) looks more like a data error. _______________________________________________ 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.