升级完成后进后台提示这个 MySQL server error report. ..

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

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

回答:
你升级前后编码不一致吧,是不是忘了执行数据库编码转换了?