> On Nov 14, 2017, at 4:00 AM, Mubasher Usman <mian.mubasherus...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org 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.
