数据库出现问题，前台会员无法登录

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

昨天开始突然有会员说在前台无法登录，登录后提示数据库错误，然后自己也试了下，的确无法登录，但是后台管理可以登录。咨询了空间服务商说空间数据库没有问题，是程序的问题。关键是最近没有修改过程序，不知道到底是什么问题，请大家帮忙看看怎么解决，谢谢了。下面是前台登录错误的提示：
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT u.user_money, u.pay_points, u.user_rank, u.rank_points, IFNULL(b.type_money, 0) AS user_bonus, u.last_login, u.last_ip FROM `sqljwqch`.`ecs_users` AS u LEFT JOIN `sqljwqch`.`ecs_user_bonus` AS ub ON ub.user_id = u.user_id AND ub.used_time = 0 LEFT JOIN `sqljwqch`.`ecs_bonus_type` AS b ON b.type_id = ub.bonus_type_id AND b.use_start_date <= '2011-10-31' AND b.use_end_date >= '2011-10-31' WHERE u.user_id = '489' ) [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 u.user_money, u.pay_points, u.user_rank, u.rank_points, IFNULL(b.type_money, 0) AS user_bonus, u.last_login, u.last_ip FROM `sqljwqch`.`ecs_users` AS u LEFT JOIN `sqljwqch`.`ecs_user_bonus` AS ub ON ub.user_id = u.user_id AND ub.used_time = 0 LEFT JOIN `sqljwqch`.`ecs_bonus_type` AS b ON b.type_id = ub.bonus_type_id AND b.use_start_date <= '2011-10-31' AND b.use_end_date >= '2011-10-31' WHERE u.user_id = '489' ) [2] => Array ( [error] => MySQL server has gone away ) [3] => Array ( [errno] => 2006 ) [4] => Array ( [message] => MySQL Query Error ) [5] => Array ( [sql] => UPDATE `sqljwqch`.`ecs_sessi**` SET expiry = '1320063034', ip = '58.41.97.249', userid = '489', adminid = '0', user_name='kcb', user_rank='0', discount='1', email='kcb606@163.com', data = 'a:5:{s:7:\"from_ad\";i:0;s:7:\"referer\";s:6:\"本站\";s:10:\"login_fail\";i:0;s:12:\"captcha_word\";s:16:\"MWFiNDYyZjNlMg==\";s:9:\"flow_type\";i:0;}' WHERE sesskey = '1de10952a8519e305e5d109df634ac21' LIMIT 1 ) [6] => Array ( [error] => MySQL server has gone away ) [7] => Array ( [errno] => 2006 ) )

回答：
可以先尝试 修复一下数据表。