MySQL Workbench and ERROR 1067: Invalid default value for ” (timestamp column)

When I publish my database schema to server by command “Database/Forward engineering” in MySQL Workbench I have a error
ERROR: Error 1067: Invalid default value for 'updated'

“updated” is Timestamp column and there is solution how you can fix this problem.

[wp_ad_camp_1]

1. Open MySQL Workbench
2. Open Preferences “Edit / Preferences”
3. Go to “Modeling / MySQL”
4. Sets “SQL_MODE to be used in generated scripts:” to “STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
5. OK button

You can do “Database/Forward engineering” again, problem with timestamo should be fixed.

[wp_ad_camp_1]