大家帮我看看这是什么问题
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的神马限制了... |
最近更新
常用插件
- ecshop选择下单时间插件
ecshop选择下单时间插件主要是根据不同的下单配送要求,在ecshop购物车...
- ecshop二次开发售后维修卡
插件介绍: 本插件是用于专门从事电子,信息,软件等售后服务关键比...
- ecshop供应商插件免费下载
ecshop供应商插件免费下载...
- ecshop快递发货单打印商品
ecshop快递发货单打印商品信息,大家都知道ecshop快递单打印的时候,只能...
- ecshop按分类筛选销售排行
ecshop按分类筛选销售排行...
ecshop热门问答
ecshop热门资料
ecshop分行
ecshop程序出错
ecshop客流量
ecshop联系我们
会员等级
ecshop网银
ecshopiphonr
ecshop加价
ecshop行货
ecshop买包包
ecshop促销
ecshop葡萄柚
ecshop是否支持货到付款
ecmall购物车
ecshop添加
ecshop文章随意调用
ecshop新浪微博登录
ecshop菜鸟
ecshop手机充值
ecshop二级分类图标
ecshop账号
ecshop新蛋模板
ecshop1wshop
ecshop手抖
ecshop总数
ecshop扩展函数
ecshopexists
ecshop品牌图标
ecshop闹心
ecmall订单