后台无法登陆呢?登陆出现错误MySQL server error report:Array

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

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT DISTINCT session_id FROM `ecshop`.`ecs_cart` AS c, `ecshop`.`ecs_sessions` AS s WHERE c.session_id = s.sesskey ) [2] => Array ( [error] => Illegal mix of collations (gbk_bin,IMPLICIT) and (gb2312_bin,IMPLICIT) for operation '=' ) [3] => Array ( [errno] => 1267 ) )

是什么问题啊

回答:
把这个表清空

数据库的编码不一致,有的表是gb2312有的是gbk。