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
    Aug 08, 2018 @ 04:15
    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
    Aug 08, 2018 @ 08:38
    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
    Aug 09, 2018 @ 01:26
    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 25 posts 133 karma points
    Aug 09, 2018 @ 02:29
    Greg Hluska
    0

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

  • Venkatesh K 14 posts 84 karma points
    Aug 09, 2018 @ 08:59
    Venkatesh K
    0

    MySQL 5.7

  • Greg Hluska 25 posts 133 karma points
    Aug 10, 2018 @ 00:02
    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
    Aug 10, 2018 @ 01:33
    Venkatesh K
    0

    Thank you Greg. Awaiting your reply :)

  • Greg Hluska 25 posts 133 karma points
    Aug 10, 2018 @ 04:55
    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
    Aug 17, 2018 @ 00:32
    Venkatesh K
    0

    No worries Greg. Thank you for your help.

  • T. Thompson 1 post 71 karma points
    1 week ago
    T. Thompson
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft