我遇到了类似的问题，通过在数据库连接设置中禁用 mysql 严格模式来解决.

I had a similar Problem and solved it by disabling mysql strict mode in the database connection setting.

'connections' => [
    'mysql' => [
        // Behave like MySQL 5.6
        'strict' => false,

        // Behave like MySQL 5.7
        'strict' => true,
    ]
]

您可以在 Matt Stauffer 的这篇博文