所遇問題現象,論壇有一些帖子不訪問,報以下錯誤:
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;