Question

刚装好Ecshop就报错，请问在sql里怎样添加O.add_time字段？具体怎样操作？

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id , o.user_id, o.city FROM `a100c55z_hasx8831`.`ecs_order_goods` AS g RIGHT JOIN `a100c55z_hasx8831`.`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

商品表里面缺少O.add_time字段。看下模板是否做过开发，曾加入过什么插件

追问

我是moke8上面下的一个全站源码，装上后就这样了。有什么方法解决？