Question

ecshop后台订单是乱码

整个站其他都正常，就是下单后，进后台看订单内容，出现的是MySQL server error report:Array ( [0] => Array ( [message] => MySQL
Query Error ) [1] => Array ( [sql] => SELECT concat(IFNULL(c.region_name,
''), ' ', IFNULL(p.region_name, ''), ' ', IFNULL(t.region_name, ''), ' ',
IFNULL(d.region_name, '')) AS region FROM `phpMyAdmin`.`ecs_order_info` AS o
LEFT JOIN `phpMyAdmin`.`ecs_region` AS c ON o.country = c.region_id LEFT JOIN
`phpMyAdmin`.`ecs_region` AS p ON o.province = p.region_id LEFT JOIN
`phpMyAdmin`.`ecs_region` AS t ON o.city = t.region_id LEFT JOIN
`phpMyAdmin`.`ecs_region` AS d ON o.district = d.region_id WHERE o.order_id =
'6' ) [2] => Array ( [error] => Unknown column 'o.province' in 'on clause'
) [3] => Array ( [errno] => 1054 ) )
不知道是那出问题，请教各位高手啦。

Answer 1

应该是你的程序做过二次开发吧。
根据错误判断是order_info表缺少province字段

可以在phpmyadmin里面添加上这个字段

Answer 2

应该是你开发了什么东西导致的，建议还原一下

Answer 3

这不是乱码，你的数据库出问题了