数据表pre_security_failedlog错误及修复

dly · 发表于 2015-12-19 12:51:30

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

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

forum.php?mod=attachment&aid=MTY3M3w5MzgxMzg2YXwxNDUwNTAwNTU0fDB8MTgzNg%3D%3D&noupdate=yes&.jpg

forum.php?mod=attachment&aid=MTY3M3w5MzgxMzg2YXwxNDUwNTAwNTU0fDB8MTgzNg%3D%3D&noupdate=yes&.jpg

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;

复制代码

数据表pre_security_failedlog错误及修复

相关帖子