最新消息:数据恢复成功,博主又回来啦,和你们同在!

解决安装WHMCS时数据导入错误

Mysql ZmmFly 1052浏览 2评论

错误细节:

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

转载请注明:SH自留地 » 解决安装WHMCS时数据导入错误

发表我的评论
取消评论

Protected by WP Anti Spam

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

网友最新评论 (2)

  1. 怎么你也卖空间了a 。。。
    大喇叭6年前 (2013-11-14)回复
    • 本来想卖的。。。但是没钱买WHMCS。。。破解版的又不敢用,怕VPS被投诉...
      惜颜6年前 (2013-11-14)回复