ecshop2.72现网站突然显示出错信息怎么办?

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

网站以前正常,现突然冒出以下错误:
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `shop`.`ecs_sessi**` (sesskey, expiry, ip, data) VALUES ('a5611a4a5cc07ed533dc3093f77c9339', '1354885281', '14.156.25.7', 'a:0:{}') ) [2] => Array ( [error] => The table 'ecs_sessi**' is full ) [3] => Array ( [errno] => 1114 ) )


后来我以为是空间有问题,更换空间后恢复数据,现打开一样不能正常访问显示错误信息如下:
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `shop`.`ecs_sessi**` (sesskey, expiry, ip, data) VALUES ('60d309073e9dec08f9c31686dde64473', '1355022104', '113.118.183.83', 'a:0:{}') ) [2] => Array ( [error] => The table 'ecs_sessi**' is full ) [3] => Array ( [errno] => 1114 ) )

请指教一下,谢谢!

回答:
清缓存看看

你的session表已经写慢了。

错误原因:
ecs_sessi**表已满,这是一个 memory 类型的表,需要及时清理
解决方法:
1)
重启MYSQL
2)
修改 includes/cls_session.php 文件里的
var $max_life_time = 数字;

将 数字 改的小一些

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `ywzq_ywdsn_cn`.`sdb_brand`AS b, `ywzq_ywdsn_cn`.`sdb_goods` AS g WHERE g.brand_id = b.brand_id AND is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC LIMIT 11 ) [2] => Array ( [error] => Can't create/write to file 'c:\windows\temp\#sql_5b0_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ) )

我的该怎么办呢 ?

现在我只能关闭网站呢

提示:本店盘点中,请您稍后再来...

动漫商城暂时维护,请继续关注www.ywdsn.cn

暂时将SESSION写MEMCACHE把.