Too many Field 'xxx' doesn't have a default value

[upliu]

I use mysql version 5.7.18.
when i run ./yii cms/install , these two error occurd:

• created_at out of range , because created_at is int in db table column, new Expression('NOW()') isn't a valid value
• intro_content deesn't have a defautl value

after i fix errors above.

I try to add a menu in admin, i got an exception, Field 'route' doesn't have a default value.

[upliu]

The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION.

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_strict_trans_tables

disable STRICT_TRANS_TABLES option may be help

[upliu]

Add 3 line of code in common/config/db.php could resolve this problem

'on afterOpen' => function($event){
    $event->sender->pdo->exec('set sql_mode=""');
}