MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.goods_thumb, SUM(og.goods_number) as goods_number,g.comments_number, g.et_price, g.shop_price , g.promote_price FROM `wph`.`ecs_goods` AS g, `wph`.`ecs_order_info` AS o, `wph`.`ecs_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 ('295','306','337','335','341','332','338','333','339','336','334','340','331','304','312','309','316','313','310','307','317','314','311','308','318','315','305','328','325','322','319','329','326','323','320','330','327','324','321','296','342','369','366','363','370','367','364','371','368','365','343','360','357','361','358','355','362','359','356','344','353','350','347','354','351','348','345','352','349','346','297','372','385','382','386','383','384','373','379','380','381','374','378','375','376','377','298','387','401','398','405','402','399','403','400','404','388','397','389','395','396','390','394','391','392','393','299','406','433','437','434','438','435','439','436','407','430','427','431','428','425','432','429','426','408','424','421','422','423','420','409','417','418','419','416','410','414','411','415','412','413','300','440','442','441','449','446','443','450','447','444','448','445','301','451','459','456','457','454','458','455','452','462','463','460','464','461','453','465') OR g.goods_id IN ('') ) 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.comments_number' in 'field list' ) [3] => Array ( [errno] => 1054 ) )
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货