每日用户表优化出错

Discuz! Database Error(1146) Table '*******.common_member_archive' doesn't exist REPLACE INTO common_member_archive SELECT * FROM common_member WHERE uid IN ('2','4','5','6','7','8','9','10','15','16','17','18','20','21','22','23','24','25','26','27','28','30','31','32','33','34','35','36','39','41','42','43','44','45','46','47','49','50','51','52','54','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','74','75','76','78','79','82','83','85','86','87','88','89','90','92','93','94','95','96','97','98','99','100','101','103','108','110','111','112','113','116','117','118','138','140','141','157','160','161','170','178','180','182')

PHP Debug

No.	File	Line	Code
1	admin.php	57	require(%s)
2	source/admincp/admincp_misc.php	1221	discuz_cron::run(%s)
3	source/class/discuz/discuz_cron.php	42	include(%s)
4	source/include/cron/cron_member_optimize_daily.php	13	table_common_member->split(%d)
5	source/class/table/table_common_member.php	364	discuz_database::query(%s, Array, false, true)
6	source/class/discuz/discuz_database.php	136	db_driver_mysql->query(%s, false, true)
7	source/class/db/db_driver_mysql.php	151	db_driver_mysql->halt(%s, %d, %s)
8	source/class/db/db_driver_mysql.php	218	break()

DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';

等等方法都用过了，还是不行。

方法：即在站长—数据库—升级(Discuz! 数据库升级 - 请将数据库升级语句粘贴在下面:)中执行语句 ：

1. DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';

复制代码

就可以了，若没有找到执行语句的输入窗口 则修改config/config_global.php 当中的 $_config[admincp][runquery] 设置修改为 1 (为了安全执行完该语句后 确认解决了1146错误后 再将配置该回来 )  刷新后再输入执行。
为了数据安全执行该语句前建议备份数据



这个试过了？

m.king 发表于 2012-12-6 14:36
方法：即在站长—数据库—升级(Discuz! 数据库升级 - 请将数据库升级语句粘贴在下面:)中执行语句 ：就可以 ...

已经试过了，没用，问题照旧

wlm2421331 发表于 2012-12-8 21:09
已经试过了，没用，问题照旧

it works ?now

develophac 发表于 2012-12-9 01:11
it works ?now

NO!!!!!!!!