[GNC] switched to mariadb

[Colin Law]

On 9 April 2018 at 19:52, Paul Neuwirth <mail at 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 at 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.