分类经常出错
2016-07-07 15:46 来源:www.chinab4c.com 作者:ecshop专家
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, b.brand_name FROM `ecshop`.`ecs_goods` AS g LEFT JOIN `ecshop`.`ecs_brand` AS b ON b.brand_id = g.brand_id LEFT JOIN `ecshop`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND is_best = 1 AND (g.cat_id IN ('7','9','8') OR g.goods_id IN ('') ) ORDER BY g.sort_order, g.last_update DESC LIMIT 5 ) [2] => Array ( [error] => Out of memory (Needed 33554402 bytes) ) [3] => Array ( [errno] => 5 ) ) |
回答:
把mysql的缓存搞小一点,修改配置文件 或者把你的机器内存搞大一点 |
内存4G了 你说的mysql缓存弄小是怎么设置 请教? |
最近更新
常用插件
- ecshop批量上传图片插件
ecshop批量上传图片插件,这个功能是十分有用的一个功能。就是在ecshop产...
- ecshop打印快递发货单
ecshop打印快递发货单,这个问题是很常见的问题。在发货完成之后,有些...
- ecshop 支付弹出对话框插件
ecshop 支付弹出对话框插件,这个插件是非常强大的,首先在点ecshop支付...
- ecshop2.7.2退换货申请插件
ecshop2.7.2退换货申请插件,主要是在 ecshop 现在的基础上,对ecshop的订单处...
- ecshop购物车功能改进[插件
ecshop购物车功能改进[插件套餐]主要是我们最近开发工作和开发项目中。...
ecshop热门问答
ecshop热门资料
ecshop302
ecshop配置
ecshop调试
ecshop代理
ecshop验证邮件
ecshop提示框
ecshop上浮
ecshopmobile
ecshop酒精度
ecshop过虑
ecshop留言板
ecshop说据库
ecshopORZ
ecshop老师
ecshopUC整合
ecshop邮件队列管理
zen cart提示信息
ecshop热线
ecshop上载
ecshopEcshopEXP
ecshop用品
ecshop物件
ecshop核查
ecshopcount
ecshop会员信息
ecshop添加PHP代码
ecshop二次
ecshopstye
ecshop图片
ecmall匿名购