感谢：

• FUDforum

现象：

1. 站点访问正常，但无法登录
2. 登录，提示是： Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /FUDforum/include/core.inc on line 188

过程：

1. 无法登录到论坛后台查看sql错误日志
2. 在sql_errors里没有查到与此相关的记录是：

   ?1016      ?1190815305?(/bbs.anqun.cn/index.php:76<br />
   /bbs.anqun.cn/index.php:176<br />
   /bbs.anqun.cn/index.php:275<br />
   /bbs.anqun.cn/index.php:947<br />
   /bbs.anqun.cn/index.php:1142<br />
   ) 1030: Got error 134 from storage engine<br />
   Query: SELECT
         s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id,
         t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt,
         u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.topics_per_page,
         u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc
      FROM fud26_ses s
         INNER JOIN fud26_users u ON u.id=(CASE WHEN s.user_id&gt;2000000000 THEN 1 ELSE s.user_id END)
         INNER JOIN fud26_themes t ON t.id=u.theme
      WHERE s.ses_id='38b75f0c8272d5cef733ac122ff61a7b'<br />
   Server Version: 4.1.22-standard-log<br />
   
   ?703       ?1190815315?(/bbs.anqun.cn/index.php:76<br />
   /bbs.anqun.cn/theme/anqunpi/login.php:286<br />
   /bbs.anqun.cn/theme/anqunpi/login.php:611<br />
   /bbs.anqun.cn/index.php:1188<br />
   ) 1062: Duplicate entry '2' for key 3<br />
   Query: UPDATE fud26_ses SET user_id=2, sys_id='0f3694db960fdc2476760054e7979590' WHERE ses_id='fed47b919efcb9dc07abfb569505acd3'<br />
   _GET: array (
     't' =&gt; 'login',
   )<br />
   _POST: array (
     'login' =&gt; 'LiuJia',
     'password' =&gt; '88888888,
     'SQ' =&gt; '0',
     'adm' =&gt; '',
   )<br />
   Server Version: 4.1.22-standard-log<br />
   [Referring Page] http://bbs.anqun.cn/index.php/l/<br />
   

3. 不能登录到后台，不能更换或重新加载模版
4. 打 users_adm.inc(v=1.24) 补丁后无效果

解决：

1. 备份好原有的文件后，重新安装FUDforum

链接

• Fatal Error: I cannot log in anymore

-- LiuJia - 01 Oct 2007