ecshop中Duplicate entry '2381482' for key 1的问题解决
今天碰见群里的问这个ecshop 的问题,帮他解决以后,想到碰到这个问题的肯定不少,总结一下:
- MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `jssurfing3`.`ecs_stats` ( ip_address, visit_times, browser, system, language, area, referer_domain, referer_path, access_url, access_time) VALUES ('221.226.186.222', '40', 'Internet Explorer 8.0', 'Windows XP', 'zh-cn', ' ʡ Ͼ ', '', '', '/index.php', '1369761907') ) [2] => Array ( [error] => Duplicate entry '2381482' for key 1 ) [3] => Array ( [errno] => 1062 ) )
现在总结出来我自己解决这个的问题,这个问题首先从两个方面去找:
数据表ecs_stats是否设置了主键(key),主键是设置了自增长.
