Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Venkatesh K 14 posts 84 karma points
    1 week ago
    Venkatesh K
    0

    I am using MySql(Cloud SQL on GCP) to install Umbraco. Below is the error, I am getting. enter image description here Can anyone help?

  • Louis Ferreira 53 posts 248 karma points
    1 week ago
    Louis Ferreira
    0

    Hi Venkatesh,

    Can you post the contents of that log file? It might help us diagnose the problem better

  • Venkatesh K 14 posts 84 karma points
    1 week ago
    Venkatesh K
    0

    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.

  • Greg Hluska 21 posts 115 karma points
    1 week ago
    Greg Hluska
    0

    Do you happen to know what version of MySQL you're using on GCP?

  • Venkatesh K 14 posts 84 karma points
    1 week ago
    Venkatesh K
    0

    MySQL 5.7

  • Greg Hluska 21 posts 115 karma points
    1 week ago
    Greg Hluska
    0

    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.

  • Venkatesh K 14 posts 84 karma points
    1 week ago
    Venkatesh K
    0

    Thank you Greg. Awaiting your reply :)

  • Greg Hluska 21 posts 115 karma points
    1 week ago
    Greg Hluska
    0

    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.

  • Venkatesh K 14 posts 84 karma points
    2 days ago
    Venkatesh K
    0

    No worries Greg. Thank you for your help.

Please Sign in or register to post replies

Write your reply to:

Draft