For 5.7, I don't know a plausible answer off the top of my head. After my kid goes to bed, I'll read some documentation and maybe try an installation that points to a 5.7 box somewhere.
I'll still try to get you sorted, but passing on some documents is the best I can do right now! Sorry you're going through this, and I'm more sorry I can't get on a computer.
Umbraco Installation
I am using MySql(Cloud SQL on GCP) to install Umbraco. Below is the error, I am getting.
Can anyone help?
Hi Venkatesh,
Can you post the contents of that log file? It might help us diagnose the problem better
Umbraco.Core.Persistence.UmbracoDatabase - Exception (dbf62162). MySql.Data.MySqlClient.MySqlException (0x80004005): Invalid default value for 'lastNotifiedDate'
as per logs thats the info for the error Louis.
Do you happen to know what version of MySQL you're using on GCP?
MySQL 5.7
For 5.7, I don't know a plausible answer off the top of my head. After my kid goes to bed, I'll read some documentation and maybe try an installation that points to a 5.7 box somewhere.
Thank you Greg. Awaiting your reply :)
Hi Venkatesh...
My kid is still awake. She's two, so I likely should have expected that she'd be running around saying 'weeeeeeee'....:)
I can't verify this, but maybe you can. What is the default value for that column? If it is 0000-00-00, this setting would explain what's going on:
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmodenozero_date
I'll still try to get you sorted, but passing on some documents is the best I can do right now! Sorry you're going through this, and I'm more sorry I can't get on a computer.
No worries Greg. Thank you for your help.
Have you found any solution to the problem?
I have the same error text but have no clue how to proceed.
Using mySQL 5.7 and running on windows 2016
Your T.
is working on a reply...