discuz X2.0删除用户出错，Table 'XXXXX.security_eviluser' doesn't exist

Discuz! Database Error
The database has encountered a problem. Need Help?
Error messages:

[Type] 查询语句错误
[1146] Table ‘XXXXX.security_eviluser’ doesn’t exist
[Query] UPDATE security_eviluser SET `operateresult`=’2′ WHERE uid IN (‘131’)

Program messages:

[Line: 0059]admin.php(require)
[Line: 0498]sourceadmincpadmincp_members.php(deletemember)
[Line: 0021]sourcefunctionfunction_delete.php(updateMemberOperate)
[Line: 0500]sourcefunctionfunction_sec.php(DB::update)
[Line: 0945]sourceclassclass_core.php(DB::query)

bbs.mathcai.com 已经将此出错信息详细记录, 由此给您带来的访问不便我们深感歉意

 

解决办法：

security_eviluser 这表不存在
phpmyadmin执行如下sql语句

CREATE TABLE pre_security_eviluser (
uid int(10) unsigned NOT NULL,
evilcount int(10) NOT NULL DEFAULT ‘0’,
eviltype mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
createtime int(10) unsigned NOT NULL DEFAULT ‘0’,
operateresult tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
isreported tinyint(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (uid),
KEY operateresult (operateresult,createtime)
) TYPE=MyISAM;

http://www.discuz.net/thread-2945755-2-1.html