WenRou's Blog
安装WHMCS时数据导入错误 doesn’t have a default value
2015-12-30 温柔哥


错误细节:




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

发表评论:
昵称

邮件地址 (选填)

个人主页 (选填)

内容