Install fails on mysql:5.7 about scalar

[craigdietrich]

Thanks for the report, Paul!

Did you recently upgrade to 5.7, and noticed the problem? There's four places where 'datetime' turns up in the SQL file:

3 are like this:
created datetime NOT NULL
The other is like this:
datetime timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP

I'm guessing it's the NOT NULL in the 3 like statements, since there isn't a default set. Curious if you could try, NOT NULL DEFAULT NOW(), and see if that works?

[paulshannon]

I was setting up a new install. It's the NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP that is throwing the error.

I'll try and nail down a fix on monday.

[craigdietrich]

Great, thanks for taking a look!

If changes are needed, happy to administer a pull request, or we can add you to the project.

[paulshannon]

I think there is some additional compatibility problems with some newer versions of Mysql (couldn't create an account on 5.6). I've reinstalled on 5.5 and it seems to be fine. Probably worth investigating at some point.

[craigdietrich]

I've created a ticket in our internal issue tracker, will take a look. Thanks!