On 9 April 2018 at 19:52, Paul Neuwirth <m...@paul-neuwirth.nl> wrote: >> Hi, >> I think this is a bug. where to report? anyone knows a >> workaround/config for that? Or shall I create and suggest a patch on >> my own? >> >> I made a transfer and saving to database failed: >> mysql error: Incorrect datetime value: '19700101000000' for column >> 'timespec_val' at row 1 mysql error: Incorrect datetime value: >> '19700101000000' for column 'reconcile_date' at row 1 >> >> I think the function STR_TO_DATE in the query is missing. >> >> >> Thank you > > two few questions I could answer myself (problem not related to > mariadb): > > it is definetly a bug, according to mysql documentation > https://dev.mysql.com/doc/refman/5.6/en/date-and-time-literals.html it > is not an allowed format. > workaround: unset global sql mode "STRICT_TRANS_TABLES", which got > default starting from MySQL 5.6 > > fix should be, to correct these strings, or to set SQL Mode on > client side not to use STRICT_TRANS_TABLES.
I think this may be the known bug https://bugzilla.gnome.org/show_bug.cgi?id=784623 but unfortunately that doesn't seem to be there any more. Have the bugs moved while I wasn't paying attention? In mysql the solution is to add to /etc/mysql.cnf [mysqld] sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION I believe it was to be fixed in version 3.0. There was not an easy fix which would keep it working with earlier versions of mysql if I remember correctly. Colin > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
