订单列表问题,很严重的!!!

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

点击订单列表显示如下代码:请教一下大家,谁遇见过这个BUG,怎么处理这个问题呢?
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 `phink`.`ph168_order_info` AS o LEFT JOIN `phink`.`ph168_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 (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'ifnull' ) [3] => Array ( [errno] => 1267 ) )

回答:
顶顶,看看有没有人晓得。

你是什么编码?怎么说不能有中文在里面呢ifnull

这个不是BUG是你自己修改程序错误导致的

能查出是修改了哪里的程序导致的吗

该如何操作才能恢复呢。

我也有同样的问题
顶起来
求高人指点迷津