Table 'common_member_archive'doesn't exist error

mj1919

Hello Friends
I get this error when i want upate cahce(i upgaraded X2.5ML to X3ML),


(1146) Table 'gigascie_discuz.common_member_archive' doesn't existSELECT COUNT(*) FROM common_member_archive

PHP Debug

No.	File	Line	Code
1	admin.php	57	require(%s)
2	source/admincp/admincp_tools.php	36	updatecache()
3	source/function/function_cache.php	26	call_user_func(%s)
4			build_cache_userstats()
5	source/function/cache/cache_userstats.php	16	discuz_container->count()
6	source/function/cache/cache_userstats.php	16	discuz_container->__call(%s, Array)
7	source/class/discuz/discuz_container.php	58	table_common_member->count()
8	source/class/table/table_common_member.php	172	discuz_container->count(%d)
9	source/class/table/table_common_member.php	172	discuz_container->__call(%s, Array)
10	source/class/discuz/discuz_container.php	59	table_common_member_archive->count(%d)
11	source/class/table/table_common_member_archive.php	48	discuz_database::result_first(%s, Array)
12	source/class/discuz/discuz_database.php	117	discuz_database::query(%s, Array, false, false)
13	source/class/discuz/discuz_database.php	136	db_driver_mysql->query(%s, false, false)
14	source/class/db/db_driver_mysql.php	151	db_driver_mysql->halt(%s, %d, %s)
15	source/class/db/db_driver_mysql.php	218	break()

---

when i searched net, i saw same error in many forums and also in Discuz.net, and one solution for it:
http://www.discuz.net/thread-3308414-1-1.html
http://www.verydz.com/help/thread-1067-1-1.html
http://www.discuzthai.com/thread-35788-1-1.html
http://www.discuz.net/thread-3320160-1-1.html
http://www.cnzhanzhang.com/thread-946108-1-1.html
http://www.discuz.net/thread-3068200-1-1.html

Solution is:
In phpmyadmin forum database SQL, execute the following statement:
DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';

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

Copy the Code

---

Now,
I ran that query in my database and checked manualy in pre_common_setting, there was not any skey` = 'membersplit' in tables.
But, problem not solved and error was shown, when i want update cache!
+++++++++++++++++++++++++++++++++++++++++++++

mj1919

vot

Try to discover the 'pre_common_syscache' with phpmyadmin.
Find the record with "cname:='settings'
Download the "data" field value to your local computer as binary file.
Open the downloaded file with a text editor.
Find, if 'membersplit' exists there?

mj1919

vot 2013-9-1 11:15
Try to discover the 'pre_common_syscache' with phpmyadmin.
Find the record with "cname:='settings'
D ...

Thank you, But after doing first post solution, and cleaning web browser cache , SOLVED!

+++++++++++++++++

PS:
i so confused!
error shown again!

mj1919

vot 2013-9-1 11:15
Try to discover the 'pre_common_syscache' with phpmyadmin.
Find the record with "cname:='settings'
D ...

i didn't find membersplit , in exported file.

vot

mj1919 2013-9-1 11:52
i didn't find membersplit , in exported file.

Ok, then try to export as SQL the next tables to your local computer:
pre_common_cache
pre_common_syscache
pre_common_setting

mj1919

vot 2013-9-1 12:18
Ok, then try to export as SQL the next tables to your local computer:
pre_common_cache
pre_common_ ...

two first= No
but in third row, pre_common_setting , i have ('membersplit', '1'),

vot

My opinion:
I do not like to store any cache in a database. I think it is a wrong solution.
That is why I recommend to set in your config_global.php:

1. // ---------------------------  CONFIG CACHE  --------------------------- //
   
2. $_config['cache']['type'] = 'file';
   

Copy the Code

mj1919

vot 2013-9-1 12:41
My opinion:
I do not like to store any cache in a database. I think it is a wrong solution.
That is  ...

i changed as:

1. // ---------------------------  CONFIG CACHE  --------------------------- //
   
2. $_config['cache']['type'] = 'file';
   

Copy the Code

and checked, but not solved!

---

Again, i ran this query:

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

Copy the Code

and checked update cache (config_global changed to new one), but same ERROR!!!

vot

My suggestion:
Try to execute the next SQL query:

1. CREATE TABLE 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.   PRIMARY KEY (uid),
    
25.   UNIQUE KEY username (username),
    
26.   KEY email (email),
    
27.   KEY groupid (groupid),
    
28.   KEY conisbind (conisbind)
    
29. ) TYPE=MyISAM;
    

Copy the Code