你有同步手動更新?
詳情:https://www.tad0616.net/modules/tadnews/index.php?nsn=282
做完此動作即可
遇到要進行資料管理新增資料時,出現問題
請關閉Mysql的嚴格模式
我是ob2d server
請參考
Create a new .cnf file.
nano /etc/mysql/conf.d/strict_mode.cnf
Paste the following code into that file,
[mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Save and close the file. And then restart MySQL server.
systemctl restart mysql
Open your application and errors should have disappeared.
資料出處:https://vpsfix.com/5266/disable-strict-mode-mysql-5-7-ubuntu-16-04/