求救:ecshop网店报错MySQL Query Error与Out of memory

2016-07-07 15:22 来源:www.chinab4c.com 作者:ecshop专家

系统信息
服务器操作系统: FreeBSD (61.155.152.165) Web 服务器: Apache/2.2.6 (Unix)
PHP 版本: 5.2.4 MySQL 版本: 5.0.45-log
安全模式: 否 安全模式GID: 否
Socket 支持: 是 时区设置: UTC
GD 版本: GD2 ( JPEG GIF PNG)Zlib 支持: 是
IP 库版本: 20071024文件上传的最大大小: 2M
ECShop 版本: v2.7.2 RELEASE 20100505 编码: UTF-8

空间是买的新网的UNIX全能空间,现在网站有时能打开有时打不开或者打开了网速却很慢!原本以为是新网服务器问题,但新网换服务器后问题乃没有解决,现向高手求救!
主要是报如下的错误信息:

错误代码一:

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 `db_5soffice_com`.`ecs_goods` AS g, `db_5soffice_com`.`ecs_order_info` AS o, `db_5soffice_com`.`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 ('1','5','50','117','116','51','118','52','53','7','54','108','106','107','55','111','109','110','112','114','115','113','22','59','56','57','58','27','9','23','24','10','8','28','6','29','25','2','11','13','30','33','31','14','32','66','12','68','65','62','69','63','60','70','67','64','61','3','15','119','120','16','17','34','37','35','38','49','18','72','73','74','71','123','124','125','126','4','19','39','121','122','40','41','84','81','78','75','85','82','79','76','83','80','77','42','97','98','99','20','94','91','88','95','92','89','86','96','93','90','87','43','101','102','44','103','105','104','46','48','47') OR g.goods_id IN ('57') ) 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 6 ) [2] => Array ( [error] => Out of memory (Needed 1665792 bytes) ) [3] => Array ( [errno] => 5 ) )


错误代码二:

ECSHOP info:Can't Connect MySQL Server(61.155.152.148)!


错误代码三:

MySQL server error report:[/b]Array ([0]=>Array([message] => MySQL Query Error ) [1] => Array ([sql] =>SELECT SUM(goods_number) AS number, SUM(goods_price * goods_number) AS amout FROM`db_5soffice_com`.`ecs_cart` WHERE session_id=`7fbfb1a7d8ea68226952bbc5747345f` AND rec_type = `0`)[2] =>Array ([error]=>MySQL server has gone away)[3]=>Array([errno]=>2006))

回答:
有没有人能够帮帮我的,急

http://hi.baidu.com/phps/blog/item/2a28c6fd4a9fa04cd7887de8.html
请参考上贴

又是楼上正解