所遇问题现象，论坛有一些帖子不访问，报以下错误：
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语句即可- DROP TABLE pre_security_failedlog;
- CREATE TABLE pre_security_failedlog (
- id int(11) NOT NULL AUTO_INCREMENT,
- reporttype char(20) NOT NULL,
- tid int(10) unsigned NOT NULL DEFAULT '0',
- pid int(10) unsigned NOT NULL DEFAULT '0',
- uid int(10) unsigned NOT NULL DEFAULT '0',
- failcount int(10) unsigned NOT NULL DEFAULT '0',
- createtime int(10) unsigned NOT NULL DEFAULT '0',
- posttime int(10) unsigned NOT NULL DEFAULT '0',
- delreason char(255) NOT NULL,
- scheduletime int(10) unsigned NOT NULL DEFAULT '0',
- lastfailtime int(10) unsigned NOT NULL DEFAULT '0',
- extra1 int(10) unsigned NOT NULL,
- extra2 char(255) NOT NULL DEFAULT '0',
- PRIMARY KEY (id),
- KEY pid (pid),
- KEY uid (uid)
- ) TYPE=MyISAM;
|
41859
0
提升卡
置顶卡
沉默卡
变色卡
千斤顶
