ECSHOP 导致数据库崩溃! 求助!

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

刚开始不知道怎么回事

发现数据库老是连接不上

经过技术查看 得到以下信息。

今天早上,突然有发现连接不上了,立马去隔壁办公室,发现有同事正在用EC的后台,立刻让其停止使用

数据库恢复。。。请问这什么问题啊

  1. 100315 15:21:38 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_sessions` SET expiry = '1268637698', ip = '123.***.116.54', userid = '0', adminid = '5', user_name='0', user_rank='0', discount='0', email='0', data = '' WHERE sesskey = '788018c649b46217f9a6f9ed4ec3e932' LIMIT 1
  2. 100315 15:22:19 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_sessions` SET expiry = '1268637739', ip = '123.***.116.54', userid = '0', adminid = '5', user_name='0', user_rank='0', discount='0', email='0', data = '' WHERE sesskey = '788018c649b46217f9a6f9ed4ec3e932' LIMIT 1
  3. 100315 15:22:37 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_sessions` SET expiry = '1268637757', ip = '123.***.116.54', userid = '0', adminid = '0', user_name='0', user_rank='0', discount='1', email='0', data = 'a:3:{s:7:\"from_ad\";i:0;s:7:\"referer\";s:4:\"本站\";s:10:\"login_fail \";i:0;}' WHERE sesskey = '445275a69e3d73af4e88e3320532793e' LIMIT 1
  4. 100315 15:22:43 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_goods` SET keywords = '' WHERE goods_id = '297' LIMIT 1
  5. 100315 15:22:43 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_sessions` SET expiry = '1268637763', ip = '123.***.116.54', userid = '0', adminid = '5', user_name='0', user_rank='0', discount='0', email='0', data = '' WHERE sesskey = '788018c649b46217f9a6f9ed4ec3e932' LIMIT 1
  6. 100315 15:22:47 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_sessions` SET expiry = '1268637767', ip = '123.***.116.54', userid = '0', adminid = '5', user_name='0', user_rank='0', discount='0', email='0', data = '' WHERE sesskey = '788018c649b46217f9a6f9ed4ec3e932' LIMIT 1
  7. 100315 15:23:10 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `sqlnet`.`ecs_sessions` SET expiry = '1268637790', ip = '123.***.116.54', userid = '0', adminid = '5', user_name='0', user_rank='0', discount='0', email='0', data = '' WHERE sesskey = '788018c649b46217f9a6f9ed4ec3e932' LIMIT 1
复制代码

回答:
相当专业

请问?

没人管吗?

自己顶自己顶自己顶自己顶

自己顶自己顶自己顶自己顶自己顶自己顶自己顶自己顶自己顶

自己顶自己顶自己顶自己顶自己顶自己顶自己顶自己顶自己顶

参考一下这两篇帖子
http://storysky.blog.51cto.com/628458/259280
http://topic.csdn.net/u/20090820/10/36087406-f5bc-4d9b-9a45-7d8a95442634.html

谢谢!!!!!!!!!!!

使用ecshop后台不会导致数据库崩溃的吧,是不是你的数据库链接不稳定

数据库连接超时 也会出现你这样的情况的
肯定不是崩溃
可以用其他工具恢复到本地坎是否有这样的问题

路过.......