Home  >  Article  >  Backend Development  >  各位一个紧急有关问题。关于ECSHOP

各位一个紧急有关问题。关于ECSHOP

WBOY
WBOYOriginal
2016-06-13 13:38:48717browse

请教各位各位一个紧急问题。关于ECSHOP
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `yobuy`.`ecs_sessions` (sesskey, expiry, ip, data) VALUES ('cc5778c96739705a91fd2d87302e13f9', '1332475653', '58.246.181.206', 'a:0:{}') ) [2] => Array ( [error] => The table 'ecs_sessions' is full ) [3] => Array ( [errno] => 1114 ) )

网站首页打开就报这个错。十分不解。不知道问题出在哪里

------解决方案--------------------
网站没有及时清理session内存表造成的

修改一下
includes/cls_session.php
var $max_life_time = 3000
数值根据你的实际访问量调整吧
------解决方案--------------------
官网上说可能磁盘满了或者表达到了最大限制。参考:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full
------解决方案--------------------
http://www.baidu.com/s?wd=The+table+%27ecs_sessions%27+is+full+&rsv_bp=0&rsv_spt=3&rsv_n=2&inputT=683
http://fkblog.sinaapp.com/blog358
------解决方案--------------------
The table 'ecs_sessions' is full

问题很明显了,你可以试试看手动insert是否成功
innodb吧? mysql是存在表满的可能性的,根据mysql的设置不同,所以你换一台机器成功了

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn