前天几帮客户新搭了一个VPS,然后移了一个zencart站过去，传批量表的时候出现后台出现“An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer”。

其它正常的批量表拿过来传最后出现

“An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer”错误。

去查了日志提示MySQL error 1366: Incorrect integer value: ” for column ‘products_tax_class_id’ at row 1。

花了几个小时查找，最后得到完美解决。修改了MYSQL配置文件，原来sql-mode默认加了STRICT_TRANS_TABLES,导致默认字符段不允许为空。把这个选项删除掉后，重启mysql，完美解决。