Error Connecting with MySql

[John Ralls]

> On Nov 14, 2017, at 4:00 AM, Mubasher Usman <mian.mubasherusman at gmail.com> wrote:
> 
> John Ralls-2 wrote
>>> Close. See https://bugzilla.gnome.org/show_bug.cgi?id=784623
>>> <https://bugzilla.gnome.org/show_bug.cgi?id=784623>.
>> 
>>> Executive summary: MySQL later than 5.5 doesn’t work with GnuCash.
>> 
>>> Regards,
>>> John Ralls
>> 
>>> _______________________________________________
>>> gnucash-user mailing list
>>> 
> 
>> gnucash-user@
> 
>>> 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.
> 
> I have read your link and the root cause is 19700101000000 value. In my
> gnucash database there is a table slots. so GnuCash tried to save
> 19790101000000 value in the timespec_val column.
> 
> I search all in my xml file and did not found that value in xml backend. I
> dont know where does this value come from and how to set this some
> acceptable value.
> 
> For Your info I am now using MySQL 5.5.58 with GnuCash 2.6.18 on windows.
> 
> I really appreciate Your help to point me the direction in which I can use
> mysql as I need this because I want to show the reports on web. I am a
> software engineer in java and trying to build a front end for gnucash to
> show the reports.

Rats,

Did you unset STRICT_TRANS_TABLES as suggested in https://bugzilla.gnome.org/show_bug.cgi?id=784623#c13? <https://bugzilla.gnome.org/show_bug.cgi?id=784623#c13?>

If that doesn’t help you can try GnuCash 2.6.15.

Regards,
John Ralls