所遇问题现象,论坛有一些帖子不访问,报以下错误:
Discuz! Database Error

(145) Table "./jdhr/security_failedlog" is marked as crashed and should be repaired
SELECT count(*) FROM security_failedlog

pre_security_failedlog 是防水墙失败日志记录表
并且修复此表后过段时间还会问题重现
只能删除表之后重建表才可以
进入 phpMyAdmin 运行以下 SQL 语句即可

  1. DROP TABLE pre_security_failedlog;
  2. CREATE TABLE pre_security_failedlog (
  3.   id int(11) NOT NULL AUTO_INCREMENT,
  4.   reporttype char(20) NOT NULL,
  5.   tid int(10) unsigned NOT NULL DEFAULT '0',
  6.   pid int(10) unsigned NOT NULL DEFAULT '0',
  7.   uid int(10) unsigned NOT NULL DEFAULT '0',
  8.   failcount int(10) unsigned NOT NULL DEFAULT '0',
  9.   createtime int(10) unsigned NOT NULL DEFAULT '0',
  10.   posttime int(10) unsigned NOT NULL DEFAULT '0',
  11.   delreason char(255) NOT NULL,
  12.   scheduletime int(10) unsigned NOT NULL DEFAULT '0',
  13.   lastfailtime int(10) unsigned NOT NULL DEFAULT '0',
  14.   extra1 int(10) unsigned NOT NULL,
  15.   extra2 char(255) NOT NULL DEFAULT '0',
  16.   PRIMARY KEY (id),
  17.   KEY pid (pid),
  18.   KEY uid (uid)
  19. ) TYPE=MyISAM;