Question

急，ecshop出现以下问题

有谁知道， ecshop出现以下问题：MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id , o.user_id, o.city FROM `qdm0290492_db`.`ecs_order_goods` AS g RIGHT JOIN `qdm0290492_db`.`ecs_order_info` AS o ON o.order_id = g.order_id ORDER BY O.add_time DESC LIMIT 0,10 ) [2] => Array ( [error] => Unknown column 'O.add_time' in 'order clause' ) [3] => Array ( [errno] => 1054 ) ) 急，谢谢

Answer 1

SELECT cat_name FROM `test`.`hty_category`WHERE
cat_id =

首先你的WHERE前面应该有空格 第二你的cat_id没有值肯定会错误

追问

有没有详细的修改方法？

Answer 2

ORDER BY O.add_time

改成 ORDER BY o.add_time

小写的 o

追问

如何修改呢？

追答

ORDER BY O.add_time 改成 ORDER BY o.add_time, 小写的 o ；

SELECT g.goods_id , o.user_id, o.city FROM `qdm0290492_db`.`ecs_order_goods` AS g RIGHT JOIN `qdm0290492_db`.`ecs_order_info` AS o ON o.order_id = g.order_id ORDER BY o.add_time DESC LIMIT 0,10