> On Nov 11, 2017, at 5:45 AM, Maf. King <m...@chilwell.net> wrote: > > On Friday, 10 November 2017 10:26:10 GMT Mubasher Usman wrote: >> Hi, >> >> Gnucash ver 2.6.18 windows. >> MySQL 5.7.20 latest one just downloaded today. >> >> i am trying to save my accounts (by save as) into mysql database with root >> user having full permissions. But I always get the eror and upon searching >> the error in tace files I found the following. >> >> * 14:57:36 CRIT <GLib> g_utf8_to_utf16: assertion 'str != NULL' failed >> * 14:57:45 CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1292: >> Incorrect datetime value: '19700101000000' for column 'timespec_val' at row >> 1 > > Hi, > > somehow, one of your transactions has a bogus date in it of 1st Jan 1970. > Seems that MySQL doesn't like this date! > > guess you'll have to manually modify the XML data file by searching for that > date and changing the year to something more likely. > > Turn compression off (if it is enabled) save as a new XML data file. Shut GC > down. Take good backups of the new file, (then take another backup!) then > open > the file with some simple text editor and search for the string "1970010100" > > Modify all the found strings and save back out. Then test in GC and finally > try the save as SQL >
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@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.
