Re: [GNC] switched to mariadb
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 wrote: > On 9 April 2018 at 19:52, Paul Neuwirth 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: '1970010100' for column > >> 'timespec_val' at row 1 mysql error: Incorrect datetime value: > >> '1970010100' 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.
Re: [GNC] switched to mariadb
On 9 April 2018 at 19:52, Paul Neuwirth 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: '1970010100' for column >> 'timespec_val' at row 1 mysql error: Incorrect datetime value: >> '1970010100' 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.
Re: [GNC] switched to mariadb
> 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: '1970010100' for column > 'timespec_val' at row 1 mysql error: Incorrect datetime value: > '1970010100' 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. ___ 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.
[GNC] switched to mariadb
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: '1970010100' for column 'timespec_val' at row 1 mysql error: Incorrect datetime value: '1970010100' for column 'reconcile_date' at row 1 I think the function STR_TO_DATE in the query is missing. Thank you ___ 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.