网站从2.6升级到2.71后出现Array ( [errno] => 1062

2016-07-07 15:27 来源:www.chinab4c.com 作者:ecshop专家


  1. MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `sq_1818set`.`ecs_users`(`user_id`, `email`, `user_name`, `password`, `reg_time`, `last_login`, `last_ip`) VALUES ('20', 'jay5p@qq.com', 'haojay4', '969d852c57041f583786b9bfad70297f', '1262233681', '1262233681', '222.93.229.2') ) [2] => Array ( [error] => Duplicate entry '20' for key 1 ) [3] => Array ( [errno] => 1062 ) )
复制代码
请求帮助!
并且已经按照http://bbs.ecshop.com/viewthread.php?tid=64693
对uc_mebers and ecs_users两表的auto_increment的值进行了统一
可还是无效

能够注册成功,在uc中也能显示
就是注册提交后不能跳转到正常的页面
也不能正常登陆,输入密码后同样出现
  1. MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `sq_1818set`.`ecs_users`(`user_id`, `email`, `user_name`, `password`, `reg_time`, `last_login`, `last_ip`) VALUES ('18', 'soyou@163.com', 'haojay2', '969d852c57041f583786b9bfad70297f', '1262234239', '1262234239', '222.93.229.2') ) [2] => Array ( [error] => Duplicate entry '18' for key 1 ) [3] => Array ( [errno] => 1062 ) )
复制代码
大家可以去测试一下
http://www.18set.com/shop

回答:
查看
user_id
20
里面是否值已经存在

没有呀哥哥............

怎么没人解决呢?