一起遨游网

最新发现用户论坛数据跟UCenter 不一致，咋解决 下面看将提示信息的pre_common_member、pre_common_member_status这两个表的归档表删除，并以主表为基准手工 新建了两个和主表数据一致的归档表，然后自动执行计划任务的每日用户表优化就正常了，但是如此操作之后会造成UC中心的用户总数与论坛显示的会员总数不一 致的情况，这个时候我们可以尝试将存档表合并到主表中，可以执行以下sql语句

insert into pre_common_member select * from pre_common_member_archive;
insert into pre_common_member_count select * from pre_common_member_count_archive;
insert into pre_common_member_field_forum select * from 
pre_common_member_field_forum_archive;
insert into pre_common_member_field_home select * from 
pre_common_member_field_home_archive;
insert into pre_common_member_profile select * from pre_common_member_profile_archive;
insert into pre_common_member_status select * from pre_common_member_status_archive;

接着这句

TRUNCATE TABLE `pre_common_member_archive`;
TRUNCATE TABLE `pre_common_member_count_archive`;
TRUNCATE TABLE `pre_common_member_field_forum_archive`;
TRUNCATE TABLE `pre_common_member_field_home_archive`;
TRUNCATE TABLE `pre_common_member_profile_archive`;
TRUNCATE TABLE `pre_common_member_status_archive`;

去掉的好处就是别人第一时间在引擎上搜不到你是用Discuz！，假如爆发漏洞可以暂时躲一会。
在没授权下最好别删除（这是我迟迟不写这个的原因），个人站长随意吧。

1、Powered by Discuz!这个信息存在于页面路径为：根目录下template/default/common/header_common.htm（知道位置其实可以自己去找了）
2、代码修改
找到下列代码：

修改为

<title><!--{if
!empty($navtitle)}-->$navtitle  <!--{/if}--><!--{if 
empty($nobbname)}-->- $_G['setting']['bbname'] <!--{/if}--> 
</title>

遇到这样的情况解决办法如下：
方法有两种：

第一、http://你的域名/install/update.php?step=prepare 直接输入一次不行试二次！
第二、在updata.php文件中 查找代码 if(version_compare($version, '1.5.2') <= 0) {  将代码修改为：if(version_compare($version, '1.5.2') >= 0) { 就可以跳过检查了！！

DELETE FROM `pre_ucenter_pm_lists` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_0` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_1` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_2` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_3` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_4` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_5` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_6` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_7` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_8` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_9` WHERE 1 ;

以上SQL便是简单清除全部短消息的语句，进去MYSQL运行就好了。

最新那些恶意分子一直在短消息里作恶，所以只能清除短消息了，论坛也关闭普通用户短消息功能

pre_home_notification 这个表是通知消息表

如何一些不良内容或者消息过多可以进入清理