数据库彻底完蛋?救命,。。,,,
2016-07-07 15:26 来源:www.chinab4c.com 作者:ecshop专家
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT goods_id, goods_name, goods_thumb, shop_price FROM `a0902193417`.`chinabazhuayu_goods` WHERE goods_id IN ('1126','3107','183','184','2911') AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 ) [2] => Array ( [error] => Unknown column 'goods_name' in 'field list' ) [3] => Array ( [errno] => 1054 ) ) 我在子目录里装了个SHOPEX。。。。。。但影响主站的速度··于是删掉了,。,, 接着主站 主页没受任何影响 但所有分页 所有商品 ~~全部遭殃,。,,,,, 点开全部提示上面的信息 后台数据库恢复提示~~ Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 17111215 bytes) in D:\freehost\s12k90\web\admin\database.php on line 631 |
回答:
在/includes/lib_goods.php 起始处加 @ini_set('memory_limit', '128M'); 测试下可以吧。 |
@ini_set('memory_limit', '128M'); 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 `a0902193417`.`chinabazhuayu_goods` AS g, `a0902193417`.`chinabazhuayu_order_info` AS o, `a0902193417`.`chinabazhuayu_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.goods_name' in 'field list' ) [3] => Array ( [errno] => 1054 ) ) |
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 17111215 bytes) in D:\freehost\s12k90\web\admin\database.php on line 631 我现在就想恢复下数据库。。。一恢复就提示这个。。。如何解决- -各位大大们。。。。 |
http://bbs.ecshop.com/thread-95341-1-1.html 21 |
最近更新
常用插件
- ecshop选择下单时间插件
ecshop选择下单时间插件主要是根据不同的下单配送要求,在ecshop购物车...
- ecshop二次开发售后维修卡
插件介绍: 本插件是用于专门从事电子,信息,软件等售后服务关键比...
- ecshop按分类筛选销售排行
ecshop按分类筛选销售排行...
- ecshop快递发货单打印商品
ecshop快递发货单打印商品信息,大家都知道ecshop快递单打印的时候,只能...
- ecshop供应商插件免费下载
ecshop供应商插件免费下载...
ecshop热门问答
ecshop热门资料
ecshop低价
ecshop短信管理
ecshop正在复制文件
ecshop担保交易
ecshop重量
ecshop不正常
ecshop竞争力
ecshop可选项目
ecshop繁体字
ecshop女人
ecshopLOGO更换不了
成果cps整合
ecshop超值
ecshopdigit
ecshop倒计时
ecshopwamp
ecshop自动更名
ecshop鼠标滑过导航栏特效
ecshop二次开发文档
ecshop最新价格
ecshop龌龊
ecshop关键
ecshop首頁
php调用java
ecshop批量修改商品筛选
ecshopgoogle
ecshop请问
ecshop新安裝
ecshopheight
ecshop红美人