Database table missing error: common_member_archive

padheye

Since yesterday, I'm getting this error.Even getting while clearing the cache.

vot

Go to your hosting panel and check your database status.
You can use PhpMyAdmin for checking...

padheye

vot 2017-11-19 18:05
Go to your hosting panel and check your database status.
You can use PhpMyAdmin for checking...

Everything is giving OK status.

padheye

vot 2017-11-19 18:05
Go to your hosting panel and check your database status.
You can use PhpMyAdmin for checking...

While looking for solution, I found this link but couldn't able to understand http://bbs.verydz.com/thread-1370-1-1.html

vot

What the Dzx version? release? revision?

vot

Solution:
1) From PhpMyAdmin:
DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';

2) From PhpMyAdmin:
DELETE FROM `pre_common_cron` WHERE `filename` = 'cron_member_optimize_daily.php';

3) From file system:
Delete the file: source/include/cron/cron_member_optimize_daily.php

4) From Admin.php:
Clean the Cache

padheye

vot 2017-11-20 20:13
What the Dzx version? release? revision?

Discuz x3.0 .
Website: craxme.com

padheye

vot 2017-11-20 20:13
What the Dzx version? release? revision?

The thing is that this error appeared all of sudden. We didn't upgraded or removed anything.

vot

Try to create that table in PhpMyAdmin:
(Do not remember to change the table prefix "pre_"!)
(And set a correct charset!)

1. CREATE TABLE IF NOT EXISTS `pre_common_member_archive` (
   
2.   `uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
   
3.   `email` varchar(255) NOT NULL DEFAULT '',
   
4.   `username` varchar(255) NOT NULL DEFAULT '',
   
5.   `password` varchar(255) NOT NULL DEFAULT '',
   
6.   `status` tinyint(1) NOT NULL DEFAULT '0',
   
7.   `emailstatus` tinyint(1) NOT NULL DEFAULT '0',
   
8.   `avatarstatus` tinyint(1) NOT NULL DEFAULT '0',
   
9.   `videophotostatus` tinyint(1) NOT NULL DEFAULT '0',
   
10.   `adminid` tinyint(1) NOT NULL DEFAULT '0',
    
11.   `groupid` int(11) unsigned NOT NULL DEFAULT '0',
    
12.   `groupexpiry` int(11) unsigned NOT NULL DEFAULT '0',
    
13.   `extgroupids` varchar(255) NOT NULL DEFAULT '',
    
14.   `regdate` int(11) unsigned NOT NULL DEFAULT '0',
    
15.   `credits` int(11) NOT NULL DEFAULT '0',
    
16.   `notifysound` tinyint(1) NOT NULL DEFAULT '0',
    
17.   `timeoffset` varchar(255) NOT NULL DEFAULT '',
    
18.   `newpm` int(11) unsigned NOT NULL DEFAULT '0',
    
19.   `newprompt` int(11) unsigned NOT NULL DEFAULT '0',
    
20.   `accessmasks` tinyint(1) NOT NULL DEFAULT '0',
    
21.   `allowadmincp` tinyint(1) NOT NULL DEFAULT '0',
    
22.   `onlyacceptfriendpm` tinyint(1) NOT NULL DEFAULT '0',
    
23.   `conisbind` tinyint(1) unsigned NOT NULL DEFAULT '0',
    
24.   `freeze` tinyint(1) NOT NULL DEFAULT '0',
    
25.   PRIMARY KEY (`uid`),
    
26.   UNIQUE KEY `username` (`username`),
    
27.   KEY `email` (`email`),
    
28.   KEY `groupid` (`groupid`),
    
29.   KEY `conisbind` (`conisbind`),
    
30.   KEY `regdate` (`regdate`)
    
31. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    

Copy the Code

padheye

SOLVED.

Thank you so much.