Discuz Update cache Hint (1146) Table *.common_member_archive doesn t exist

discuz! Database Error(1146) Table ' ****.common_member_archive ' doesn ' t existreplace into common_member_archive SELECT * From Common_member WHERE uid (' 8 ', ' 9 ', ' 10 ')

PHP Debug

No.	File	Line	Code
1	forum.php	49	Discuz_application->init ()
2	source/class/discuz/discuz_application.php	70	Discuz_application->_init_cron ()
3	source/class/discuz/discuz_application.php	482	Discuz_cron::run ()
4	source/class/discuz/discuz_cron.php	42	Include (%s)
5	source/include/cron/cron_member_optimize_daily.php	13	Table_common_member->split (%d)
6	source/class/table/table_common_member.php	364	Discuz_database::query (%s, Array, False, True)
7	source/class/discuz/discuz_database.php	136	Db_driver_mysql->query (%s, false, True)
8	source/class/db/db_driver_mysql.php	151	Db_driver_mysql->halt (%s,%d,%s)
9	source/class/db/db_driver_mysql.php	218	Break ()

Solution One

Method: In Webmaster-database-Upgrade (discuz! Database upgrade-Please paste the database upgrade statement below to execute the statement:

Note Pre_ If your database prefix is something else please write well.
Copy the code, and if you don't find the input window that executes the statement, modify the $_config[admincp][runquery] setting in config/config_global.php to 1 (after confirming that the 1146 error has been resolved after the statement has been safely executed) Then configure the back to be refreshed before entering execution.
Recommend backing up data before executing the statement for data security

Back up the table first pre_common_setting

DELETE from ' pre_common_setting ' WHERE ' skey ' = ' membersplit ';

Workaround Two

Method: Log in phpMyAdmin and then find the corresponding database table. Back up each of the following tables

Pre_common_member pre_common_member_profile pre_common_member_field_forum pre_common_member_field_home pre_common_ Member_status Pre_common_member_count

And then duplicate a copy and name the following plus _archive

Finally, you can optimize the tool-schedule task-daily user table. Run up. If also reported is wrong, continue copying the datasheet name plus _archive.