错误细节：

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade330.sql

Line 15 – Field ‘fromname’ doesn’t have a default value

Line 16 – Field ‘fromname’ doesn’t have a default value

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade340.sql

Line 16 – Field ‘fromname’ doesn’t have a default value

Line 17 – Field ‘fromname’ doesn’t have a default value

Line 18 – Field ‘fromname’ doesn’t have a default value

Line 30 – Field ‘value’ doesn’t have a default value

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade341.sql

Line 6 – Field ‘fromname’ doesn’t have a default value

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade380.sql

Line 24 – Incorrect integer value: ” for column ‘id’ at row 1

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade450.sql

Line 4 – Incorrect integer value: ” for column ‘id’ at row 1

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade500.sql

Line 6 – Field ‘attachments’ doesn’t have a default value

Line 12 – Field ‘attachments’ doesn’t have a default value

Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade520.sql

Line 12 – Field ‘attachments’ doesn’t have a default value

Line 20 – Field ‘attachments’ doesn’t have a default value

解决办法

关闭Mysql 的Strict Mode

修改my.cnf

将sql-mode中的STRICT_TRANS_TABLES去掉

保存，然后重启Mysql，再次安装

注意：若安装WHMCS后未设置域名，并且连续三次登录失败，再打开后台则会跳转到1and1.com

---

转载请注明本文标题和链接：《安装WHMCS时数据导入错误 doesn’t have a default value》