Question

急！ecshop安装完成后出现错误，MySQL server error report:Array ( [0] => Array ( [message] =>

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

程序是完整带数据，本地测试完美（本地php版本跟虚拟空间的一样，本地测试是windows主机，虚拟空间是linux）就是上传到空间结果出现错误

Answer 1

Unknown column 'O.add_time' in 'order clause' 那些数据都是本地测试的数据吧 试试清除一下数据库数据呢 好久没做过了 也不知道对不对