Discuz数据库security_failedlog错误及修复

最新推荐文章于 2018-05-06 18:51:50 发布

天南韩立

最新推荐文章于 2018-05-06 18:51:50 发布

阅读量844

点赞数

分类专栏： MySQL PHP二次开发文章标签：数据库 discuz security 解决方案 security_failedlog

MySQL 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

PHP二次开发

4 篇文章 0 订阅

订阅专栏

解决方案:重建security_failedlog表

DROP TABLE IF EXISTS xf_security_failedlog;

CREATE TABLE xf_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) ) ENGINE=MYISAM DEFAULT CHARSET=gbk;