Ecshop出现MySQL server error report:Array怎么解决,各位大神们。

具体报错:MySQLservererrorreport:Array([0]=>Array([message]=>MySQLQueryError)[1]=>Array([s... 具体报错:
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `sq8dart09`.`ecs_goods` AS g, `sq8dart09`.`ecs_order_info` AS o, `sq8dart09`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND o.order_status = '1' AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 10 ) [2] => Array ( [error] => Unknown column 'g.shop_price' in 'field list' ) [3] => Array ( [errno] => 1054 ) )
各位大哥大姐们!有何看法帮帮忙。
展开
 我来答
匿名用户
2012-06-22
展开全部
'g.shop_price这个字段不存在,你是不是把这个字段删了
推荐律师服务: 若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询

为你推荐:

下载百度知道APP,抢鲜体验
使用百度知道APP,立即抢鲜体验。你的手机镜头里或许有别人想知道的答案。
扫描二维码下载
×

类别

我们会通过消息、邮箱等方式尽快将举报结果通知您。

说明

0/200

提交
取消

辅 助

模 式