Table 'common_member_archive'doesn't exist error
Hello FriendsI 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.FileLineCode
1admin.php57require(%s)
2source/admincp/admincp_tools.php36updatecache()
3source/function/function_cache.php26call_user_func(%s)
4
build_cache_userstats()
5source/function/cache/cache_userstats.php16discuz_container->count()
6source/function/cache/cache_userstats.php16discuz_container->__call(%s, Array)
7source/class/discuz/discuz_container.php58table_common_member->count()
8source/class/table/table_common_member.php172discuz_container->count(%d)
9source/class/table/table_common_member.php172discuz_container->__call(%s, Array)
10source/class/discuz/discuz_container.php59table_common_member_archive->count(%d)
11source/class/table/table_common_member_archive.php48discuz_database::result_first(%s, Array)
12source/class/discuz/discuz_database.php117discuz_database::query(%s, Array, false, false)
13source/class/discuz/discuz_database.php136db_driver_mysql->query(%s, false, false)
14source/class/db/db_driver_mysql.php151db_driver_mysql->halt(%s, %d, %s)
15source/class/db/db_driver_mysql.php218break()
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';DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';
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!:(
+++++++++++++++++++++++++++++++++++++++++++++
:(:(:( 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?
Edited by mj1919 at 2013-9-1 11:45
static/image/common/user_online.gif vot static/image/common/clock.gif 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!:'( Edited by mj1919 at 2013-9-1 12:03
static/image/common/user_online.gif vot static/image/common/clock.gif 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.
static/image/common/user_online.gif mj1919 static/image/common/clock.gif 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
static/image/common/user_online.gif vot static/image/common/clock.gif 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'),
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:// ---------------------------CONFIG CACHE--------------------------- //
$_config['cache']['type'] = 'file';
static/image/common/user_online.gif vot static/image/common/clock.gif 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:// ---------------------------CONFIG CACHE--------------------------- //
$_config['cache']['type'] = 'file';
and checked, but not solved!:(
Again, i ran this query:DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';and checked update cache (config_global changed to new one), but same ERROR!!!:(
My suggestion:
Try to execute the next SQL query:CREATE TABLE pre_common_member_archive (
uid int(11) unsigned NOT NULL AUTO_INCREMENT,
email varchar(255) NOT NULL DEFAULT '',
username varchar(255) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '0',
emailstatus tinyint(1) NOT NULL DEFAULT '0',
avatarstatus tinyint(1) NOT NULL DEFAULT '0',
videophotostatus tinyint(1) NOT NULL DEFAULT '0',
adminid tinyint(1) NOT NULL DEFAULT '0',
groupid int(11) unsigned NOT NULL DEFAULT '0',
groupexpiry int(11) unsigned NOT NULL DEFAULT '0',
extgroupids varchar(255) NOT NULL DEFAULT '',
regdate int(11) unsigned NOT NULL DEFAULT '0',
credits int(11) NOT NULL DEFAULT '0',
notifysound tinyint(1) NOT NULL DEFAULT '0',
timeoffset varchar(255) NOT NULL DEFAULT '',
newpm int(11) unsigned NOT NULL DEFAULT '0',
newprompt int(11) unsigned NOT NULL DEFAULT '0',
accessmasks tinyint(1) NOT NULL DEFAULT '0',
allowadmincp tinyint(1) NOT NULL DEFAULT '0',
onlyacceptfriendpm tinyint(1) NOT NULL DEFAULT '0',
conisbind tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (uid),
UNIQUE KEY username (username),
KEY email (email),
KEY groupid (groupid),
KEY conisbind (conisbind)
) TYPE=MyISAM;
Pages:
[1]
2