大家帮我看看这是什么问题

2016-07-07 15:18 来源:www.chinab4c.com 作者:ecshop专家

http://www.zgc360.com/
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 `zgc360`.`ZGC360_goods` AS g, `zgc360`.`ZGC360_order_info` AS o, `zgc360`.`ZGC360_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('13','2','23','39','20','68','69','19','1','21','22','3','29','106','30','59','104','105','4','34','33','35','5','45','46','111','26','24','25','44','96','70','27','40','28','47','97','6','42','71','43','31','41','32','7','77','74','36','78','75','72','37','66','79','76','73','38','80','8','87','84','49','81','85','50','82','86','67','83','48','9','61','62','91','60','92','10','93','65','94','63','95','64','12','90','55','52','88','53','89','54','51','98','100','101','102','99','11','58','103','56','57','107','110','109') OR g.goods_id IN ('127','132','144','149','154','158','164','168','171','174','180','214','220','229','253','255','258','261','269','278','282','286','290','293','296','299','300','301','308','313','320','325','328','331','332','335','339','341','344','346','350','352','353','355','358','359','361','362','373','374','379','380','381','385','387','389','405','409','412','413','415','418','419','420','440','441','442','443','444','445') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') 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 ) )

回答:
没遇到过这种问题哦

这个好像是php的神马限制了...