Question

ecshop MySQL server error report:Array 如何解决? 谢谢!

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT COUNT(*) FROM `ecshop`.`ecs_order_info` WHERE 1 AND order_status IN ('1','5','6') AND shipping_status IN ('0','3','5') AND ( pay_status IN ('2','1') OR pay_id IN ('3') ) ) [2] => Array ( [error] => MySQL server has gone away ) [3] => Array ( [errno] => 2006 ) ) MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT COUNT(*) FROM `ecshop`.`ecs_order_info` WHERE 1 AND order_status IN ('1','5','6') AND shipping_status IN ('0','3','5') AND ( pay_status IN ('2','1') OR pay_id IN ('3') ) ) [2] => Array ( [error] => MySQL server has gone away ) [3] => Array ( [errno] => 2006 ) [4] => Array ( [message] => MySQL Query Error ) [5] => Array ( [sql] => DELETE FROM `ecshop`.`ecs_sessions` WHERE expiry < 1465226686 ) [6] => Array ( [error] => MySQL server has gone away ) [7] => Array ( [errno] => 2006 ) )

Answer 1

这个问题是数据表出现了异常，需要修复、或优化一下。
你使用phpmyadmin或其他的mysql管理软件登陆数据库geshang，然后把adon_stats表修复一下，再优化一下就可以了。

Answer 2

缺少数据表

追问

ecs_order_info ? 这表有,哪张? 谢谢

追答

有几个没走加进去，你看下

Answer 3

虽然看不懂，不过现在在自学数据库，我想过段时间就可以啦