Question

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 `hdm0210064_db`.`dhlg_order_goods` AS g
RIGHT JOIN `hdm0210064_db`.`dhlg_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

sql语句 报错啊 你 right join dhlg_order_info as o 是小写o 你 order by 的时候 咋变成大写O了
请将 ORDER BY O.add_time 修改为 ORDER BY o.add_time 再试试