Invalid default value for 'updated_at'

[zrz4066]

If I use ”.col(ColumnDef::new(User::Created_at).date_time().not_null()) ”，It will work。it failed when Change to ".col(ColumnDef::new(User::Created_at).timestamp_with_time_zone().not_null())", error is "Exec("error returned from database: 1067 (42000): Invalid default value for 'updated_at'")"

[billy1624]

Hey @zrz4066, my wild guess is that you're using MySQL as the database?

Similar issue has been discussed at #854.

My suggestion for you. Try adding a .extra("DEFAULT CURRENT_TIMESTAMP()") on both timestamp column. It's a workaround before this, SeaQL/sea-query#428, lands.

[tyt2y3]

Close as duplicate

[dreamerlzl]

Could we make this obvious somewhere in the tutorial or docs?
Also, it shall be .extra("default CURRENT_TIMESTAMP".to_string())

[billy1624]

Hey @dreamerlzl, the workaround isn't need anymore after next SeaORM & SeaQuery release.
https://github.com/SeaQL/sea-query/blob/a7f2defac169c93f9b6a059264d9ba52aebb9b43/src/table/column.rs#L154-L161