[GNC] MySQL

[mark at mgillis.uk]

Thanks Geert. I tried upgrading to 3.7 and I'm sure that will add some new
features but, unfortunately, the MySQL error persists so it looks like I
can't store data in this format any more

Cheers
Mark 

: 07786 624704 |: mark at mgillis.uk | 




-----Original Message-----
From: Geert Janssens <geert.gnucash at kobaltwit.be> 
Sent: 29 November 2019 19:55
To: gnucash-user at gnucash.org
Cc: mark at mgillis.uk
Subject: Re: [GNC] MySQL

Hi,

There was a change in the format for storing dates in MySQL. I don't know
the exact details but it may well be the source of your problem.

I'm pretty sure gnucash 2.6.19 doesn't have (all of) the patches required to
work with this new format. You could try to upgrade to gnucash 2.6.21, the
last release in the 2.6 series, or if that fails, go with gnucash 3.7, the
current stable release.

Regards,

Geert

Op vrijdag 29 november 2019 19:48:57 CET schreef mark at mgillis.uk:
> Hi
> 
> 
> 
> I used to be able to save my Gnucash file as MySQL but recently got a 
> new laptop and I now get a message "the server at URL nysql://etc/etc 
> experienced an error or encountered bad or corrupt data". The data can 
> be stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and 
> I've reinstalled MySQL so that is now 8.0. Anyone else experienced this?
> 
> 
> 
> Cheers
> 
> Mark
> 
>   _____
> 
> : 07786 624704 |:  <mailto:mark at mgillis.uk> mark at mgillis.uk |
> 
> <http://www.linkedin.com/profile/view?id=11290745&locale=en_US>