后台订单列表出错

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

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT o.order_id, o.order_sn, o.add_time, o.order_status, o.shipping_status, o.order_amount, o.money_paid,o.pay_status, o.consignee, o.address, o.email, o.tel, o.extension_code, o.extension_id, ( o.goods_amount + o.tax + o.shipping_fee + o.insure_fee + o.pay_fee + o.pack_fee + o.card_fee ) AS total_fee, IFNULL(u.user_name, '匿名用户') AS buyer FROM `shopsql`.`ecs_order_info` AS o LEFT JOIN `shopsql`.`ecs_users` AS u ON u.user_id=o.user_id WHERE 1 ORDER BY add_time DESC LIMIT 0,15 ) [2] => Array ( [error] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'ifnull' ) [3] => Array ( [errno] => 1267 ) )

点击订单列表,后台右边就这样
怎么解决?

回答:
你不是全新安装吧?

这个问题如何解决?

我的也出现了同样的问题,请问楼主解决问题了吗?管理员请PM我,教我如何解决撒

真着急啊
我的也出现这种情况了啊
求助啊

7# caryboy
请问您提示什么错误,还有您前面的操作