错误细节：
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时数据导入错误
