Question

ecshop商城 数据恢复报错

MySQL server error report:Array ( [0] => Array ( [message] => MySQL
Query Error ) [1] => Array ( [sql] => INSERT INTO `ecs_keywords` ( `date`,
`searchengine`, `keyword`, `count` ) VALUES ('2015-05-01', 'SOGOU', NULL, '1') )
[2] => Array ( [error] => Column 'keyword' cannot be null ) [3] =>
Array ( [errno] => 1048 ) ) 这是报错代码求帮助

Answer 1

Column 'keyword' cannot be null
keyword不能为空！
INSERT INTO `ecs_keywords` ( `date`,
`searchengine`, `keyword`, `count` ) VALUES ('2015-05-01', 'SOGOU', NULL, '1')你这里提交了一个空值
你修改下 要么在提交的数据加个值 要么把keyword改为可为空！