数据库彻底完蛋？救命，。。，，，

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