Colin, Maybe your Internet went south briefly. The Bugzilla link works for me.
David C On Mon, Apr 9, 2018, 3:50 PM Colin Law <clan...@gmail.com> wrote: > 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. > _______________________________________________ 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.