Unable to convert gnucash to mysql after upgrading to 16.04

[John Ralls]

> On May 1, 2016, at 9:48 AM, Colin Law <clanlaw at gmail.com> wrote:
> 
> On 1 May 2016 at 14:21, Lewis Balentine <lewis at keywild.com> wrote:
>> see this ....
>> http://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field
> 
> You are right, that is the problem, thanks.  Ensuring that the server
> is configured with NO_ZERO_DATE not set fixes the problem.  I wrongly
> discounted this initially as the problem only started with mysql 5.7,
> and the original question was four years ago.
> 


Which reinforces yet again the fundamental rule of using GnuCash with a server-based database: The user is expected to be an expert DBA for the server of choice or to hire one. It's harder than it seems and novices risk data loss. 

Yes, I know that many Linux distros use MySQL/Maria for administrative databases. I think it's stupid, both because it requires an otherwise unnecessary resource-hungry process and because it requires expertise of the user, most of whom are casual (especially in the case of Ubuntu which aspires to be a desktop OS competing with Microsoft and Apple for the technically unsophisticated user). SQLite3 works as well or better for all of those administrative tasks without the overhead.

Regards,
John Ralls