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 `sqlfuqingss`.`ecs_order_goods` AS g RIGHT JOIN `sqlfuqingss`.`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 table 'O' in order clause ) [3] => Array ( [errno] => 1109 ) )

Answer 1

应该是首页模板包含的摸个lib文件有问题，逐一注释掉，可以查出是那个有问题。

追问

是不是数据库少了个字段

追答

你只有找到那段代码才好判断呀.