熟悉DZ数据表的老大来帮帮我好吗？

可乐王子

我的论坛出现了下面这个错误：
"这里有一个常见情况：错误提示为：
Error: Table 'bbs.cdb_settings' doesn't exist
Errno: 1146

现在没办法管理后台了，怎么办啊，到官方问没人回答，这里有好心人吗？
官方的问题解决集合那的第14问那有这样一个方法，看偶对数据库不了解，不知道具体应该怎么做啊：http://www.discuz.net/thread-221140-1-1.html

出现这样的原因主要是因为论坛数据表没有安装完成造成的，你可以用phpmyadmin升级SQL语句重建cdb_settings表




好心人快来帮帮我吧，多谢了。

nuet

对它不了解
帮顶

可乐王子

希望有好人可以看到帮我解决啊。

金光

进入phpmyadmin，在你的数据库里点击“查询”，

然后把下面的语句粘贴到“在数据库 ****** 执行 SQL 语句：”下方的文本框中，然后点击“提交查询”：

1. 
   
2. -- phpMyAdmin SQL Dump
   
3. -- version 2.6.1
   
4. -- http://www.phpmyadmin.net
   
5. --
   
6. -- 主机: localhost
   
7. -- 生成日期: 2006 年 04 月 12 日 10:29
   
8. -- 服务器版本: 4.0.23
   
9. -- PHP 版本: 4.3.10
   
10. --
    
11. -- 数据库: `discuz3`
    
12. --
    
13. 
    
14. -- --------------------------------------------------------
    
15. 
    
16. --
    
17. -- 表的结构 `cdb_settings`
    
18. --
    
19. 
    
20. CREATE TABLE `cdb_settings` (
    
21.   `variable` varchar(32) NOT NULL default '',
    
22.   `value` text NOT NULL,
    
23.   PRIMARY KEY  (`variable`)
    
24. ) TYPE=MyISAM;
    
25. 
    
26. --
    
27. -- 导出表中的数据 `cdb_settings`
    
28. --
    
29. 
    
30. INSERT INTO `cdb_settings` VALUES ('adminipaccess', '');
    
31. INSERT INTO `cdb_settings` VALUES ('archiverstatus', '1');
    
32. INSERT INTO `cdb_settings` VALUES ('attachimgpost', '1');
    
33. INSERT INTO `cdb_settings` VALUES ('attachrefcheck', '');
    
34. INSERT INTO `cdb_settings` VALUES ('attachsave', '0');
    
35. INSERT INTO `cdb_settings` VALUES ('authkey', 'ZqgMbRwxwkd8YMB');
    
36. INSERT INTO `cdb_settings` VALUES ('avatarshowdefault', '0');
    
37. INSERT INTO `cdb_settings` VALUES ('avatarshowheight', '200');
    
38. INSERT INTO `cdb_settings` VALUES ('avatarshowlink', '1');
    
39. INSERT INTO `cdb_settings` VALUES ('avatarshowpos', '3');
    
40. INSERT INTO `cdb_settings` VALUES ('avatarshowstatus', '1');
    
41. INSERT INTO `cdb_settings` VALUES ('avatarshowwidth', '135');
    
42. INSERT INTO `cdb_settings` VALUES ('bannedmessages', '1');
    
43. INSERT INTO `cdb_settings` VALUES ('bbclosed', '');
    
44. INSERT INTO `cdb_settings` VALUES ('bbinsert', '1');
    
45. INSERT INTO `cdb_settings` VALUES ('bbname', 'Discuz! Board');
    
46. INSERT INTO `cdb_settings` VALUES ('bbrules', '');
    
47. INSERT INTO `cdb_settings` VALUES ('bbrulestxt', '');
    
48. INSERT INTO `cdb_settings` VALUES ('bdaystatus', '1');
    
49. INSERT INTO `cdb_settings` VALUES ('boardlicensed', '0');
    
50. INSERT INTO `cdb_settings` VALUES ('censoremail', '');
    
51. INSERT INTO `cdb_settings` VALUES ('censoruser', '');
    
52. INSERT INTO `cdb_settings` VALUES ('closedreason', '');
    
53. INSERT INTO `cdb_settings` VALUES ('creditsformula', 'extcredits1');
    
54. INSERT INTO `cdb_settings` VALUES ('creditsformulaexp', '');
    
55. INSERT INTO `cdb_settings` VALUES ('creditsnotify', '');
    
56. INSERT INTO `cdb_settings` VALUES ('creditspolicy', 'a:7:{s:4:"post";a:0:{}s:5:"reply";a:0:{}s:6:"digest";a:1:{i:1;i:10;}s:10:"postattach";a:0:{}s:9:"getattach";a:0:{}s:2:"pm";a:0:{}s:6:"search";a:0:{}}');
    
57. INSERT INTO `cdb_settings` VALUES ('creditstax', '0.2');
    
58. INSERT INTO `cdb_settings` VALUES ('creditstrans', '0');
    
59. INSERT INTO `cdb_settings` VALUES ('custombackup', '');
    
60. INSERT INTO `cdb_settings` VALUES ('dateformat', 'Y-n-j');
    
61. INSERT INTO `cdb_settings` VALUES ('debug', '1');
    
62. INSERT INTO `cdb_settings` VALUES ('delayviewcount', '0');
    
63. INSERT INTO `cdb_settings` VALUES ('deletereason', '');
    
64. INSERT INTO `cdb_settings` VALUES ('dotfolders', '');
    
65. INSERT INTO `cdb_settings` VALUES ('doublee', '1');
    
66. INSERT INTO `cdb_settings` VALUES ('dupkarmarate', '0');
    
67. INSERT INTO `cdb_settings` VALUES ('ec_account', '');
    
68. INSERT INTO `cdb_settings` VALUES ('ec_maxcredits', '1000');
    
69. INSERT INTO `cdb_settings` VALUES ('ec_maxcreditspermonth', '0');
    
70. INSERT INTO `cdb_settings` VALUES ('ec_mincredits', '0');
    
71. INSERT INTO `cdb_settings` VALUES ('ec_ratio', '0');
    
72. INSERT INTO `cdb_settings` VALUES ('ec_securitycode', '');
    
73. INSERT INTO `cdb_settings` VALUES ('editedby', '1');
    
74. INSERT INTO `cdb_settings` VALUES ('edittimelimit', '');
    
75. INSERT INTO `cdb_settings` VALUES ('exchangemincredits', '100');
    
76. INSERT INTO `cdb_settings` VALUES ('extcredits', 'a:2:{i:1;a:3:{s:5:"title";s:4:"威望";s:12:"showinthread";s:0:"";s:9:"available";i:1;}i:2;a:3:{s:5:"title";s:4:"金钱";s:12:"showinthread";s:0:"";s:9:"available";i:1;}}');
    
77. INSERT INTO `cdb_settings` VALUES ('fastpost', '1');
    
78. INSERT INTO `cdb_settings` VALUES ('floodctrl', '15');
    
79. INSERT INTO `cdb_settings` VALUES ('forumjump', '1');
    
80. INSERT INTO `cdb_settings` VALUES ('fullmytopics', '1');
    
81. INSERT INTO `cdb_settings` VALUES ('globalstick', '0');
    
82. INSERT INTO `cdb_settings` VALUES ('gzipcompress', '');
    
83. INSERT INTO `cdb_settings` VALUES ('hideprivate', '1');
    
84. INSERT INTO `cdb_settings` VALUES ('hottopic', '10');
    
85. INSERT INTO `cdb_settings` VALUES ('initcredits', '0,0,0,0,0,0,0,0,0');
    
86. INSERT INTO `cdb_settings` VALUES ('ipaccess', '');
    
87. INSERT INTO `cdb_settings` VALUES ('ipregctrl', '');
    
88. INSERT INTO `cdb_settings` VALUES ('jscachelife', '1800');
    
89. INSERT INTO `cdb_settings` VALUES ('jsrefdomains', '');
    
90. INSERT INTO `cdb_settings` VALUES ('jsstatus', '0');
    
91. INSERT INTO `cdb_settings` VALUES ('karmaratelimit', '0');
    
92. INSERT INTO `cdb_settings` VALUES ('loadctrl', '');
    
93. INSERT INTO `cdb_settings` VALUES ('losslessdel', '365');
    
94. INSERT INTO `cdb_settings` VALUES ('maxavatarpixel', '120');
    
95. INSERT INTO `cdb_settings` VALUES ('maxavatarsize', '20000');
    
96. INSERT INTO `cdb_settings` VALUES ('maxchargespan', '0');
    
97. INSERT INTO `cdb_settings` VALUES ('maxincperthread', '0');
    
98. INSERT INTO `cdb_settings` VALUES ('maxmodworksmonths', '3');
    
99. INSERT INTO `cdb_settings` VALUES ('maxonlines', '5000');
    
100. INSERT INTO `cdb_settings` VALUES ('maxpolloptions', '10');
     
101. INSERT INTO `cdb_settings` VALUES ('maxpostsize', '10000');
     
102. INSERT INTO `cdb_settings` VALUES ('maxsearchresults', '500');
     
103. INSERT INTO `cdb_settings` VALUES ('maxsigrows', '20');
     
104. INSERT INTO `cdb_settings` VALUES ('maxsmilies', '3');
     
105. INSERT INTO `cdb_settings` VALUES ('maxspm', '0');
     
106. INSERT INTO `cdb_settings` VALUES ('maxthreadads', '0');
     
107. INSERT INTO `cdb_settings` VALUES ('membermaxpages', '100');
     
108. INSERT INTO `cdb_settings` VALUES ('memberperpage', '25');
     
109. INSERT INTO `cdb_settings` VALUES ('memliststatus', '1');
     
110. INSERT INTO `cdb_settings` VALUES ('minpostsize', '0');
     
111. INSERT INTO `cdb_settings` VALUES ('moddisplay', 'flat');
     
112. INSERT INTO `cdb_settings` VALUES ('modratelimit', '0');
     
113. INSERT INTO `cdb_settings` VALUES ('modreasons', '广告/SPAM\r\n恶意灌水\r\n违规内容\r\n文不对题\r\n重复发帖\r\n\r\n我很赞同\r\n精品文章\r\n原创内容');
     
114. INSERT INTO `cdb_settings` VALUES ('modworkstatus', '0');
     
115. INSERT INTO `cdb_settings` VALUES ('newbiespan', '0');
     
116. INSERT INTO `cdb_settings` VALUES ('newsletter', '');
     
117. INSERT INTO `cdb_settings` VALUES ('nocacheheaders', '');
     
118. INSERT INTO `cdb_settings` VALUES ('oltimespan', '10');
     
119. INSERT INTO `cdb_settings` VALUES ('onlinerecord', '4        1144807320');
     
120. INSERT INTO `cdb_settings` VALUES ('passport_expire', '3600');
     
121. INSERT INTO `cdb_settings` VALUES ('passport_extcredits', '0');
     
122. INSERT INTO `cdb_settings` VALUES ('passport_key', '');
     
123. INSERT INTO `cdb_settings` VALUES ('passport_login_url', '');
     
124. INSERT INTO `cdb_settings` VALUES ('passport_logout_url', '');
     
125. INSERT INTO `cdb_settings` VALUES ('passport_register_url', '');
     
126. INSERT INTO `cdb_settings` VALUES ('passport_status', '');
     
127. INSERT INTO `cdb_settings` VALUES ('passport_url', '');
     
128. INSERT INTO `cdb_settings` VALUES ('postbanperiods', '');
     
129. INSERT INTO `cdb_settings` VALUES ('postmodperiods', '');
     
130. INSERT INTO `cdb_settings` VALUES ('postperpage', '10');
     
131. INSERT INTO `cdb_settings` VALUES ('pvfrequence', '60');
     
132. INSERT INTO `cdb_settings` VALUES ('qihoo_adminemail', '');
     
133. INSERT INTO `cdb_settings` VALUES ('qihoo_keywords', '');
     
134. INSERT INTO `cdb_settings` VALUES ('qihoo_maxtopics', '10');
     
135. INSERT INTO `cdb_settings` VALUES ('qihoo_relatedthreads', '5');
     
136. INSERT INTO `cdb_settings` VALUES ('qihoo_summary', '1');
     
137. INSERT INTO `cdb_settings` VALUES ('qihoo_searchbox', '0');
     
138. INSERT INTO `cdb_settings` VALUES ('qihoo_status', '0');
     
139. INSERT INTO `cdb_settings` VALUES ('qihoo_topics', '');
     
140. INSERT INTO `cdb_settings` VALUES ('qihoo_validity', '1');
     
141. INSERT INTO `cdb_settings` VALUES ('regctrl', '0');
     
142. INSERT INTO `cdb_settings` VALUES ('regfloodctrl', '0');
     
143. INSERT INTO `cdb_settings` VALUES ('regstatus', '1');
     
144. INSERT INTO `cdb_settings` VALUES ('regverify', '0');
     
145. INSERT INTO `cdb_settings` VALUES ('reportpost', '1');
     
146. INSERT INTO `cdb_settings` VALUES ('rssstatus', '1');
     
147. INSERT INTO `cdb_settings` VALUES ('rssttl', '60');
     
148. INSERT INTO `cdb_settings` VALUES ('searchbanperiods', '');
     
149. INSERT INTO `cdb_settings` VALUES ('searchctrl', '30');
     
150. INSERT INTO `cdb_settings` VALUES ('seccodestatus', '0');
     
151. INSERT INTO `cdb_settings` VALUES ('seodescription', '');
     
152. INSERT INTO `cdb_settings` VALUES ('seohead', '');
     
153. INSERT INTO `cdb_settings` VALUES ('seokeywords', '');
     
154. INSERT INTO `cdb_settings` VALUES ('seotitle', '');
     
155. INSERT INTO `cdb_settings` VALUES ('showemail', '');
     
156. INSERT INTO `cdb_settings` VALUES ('sitename', 'Comsenz Inc.');
     
157. INSERT INTO `cdb_settings` VALUES ('siteurl', 'http://www.comsenz.com/');
     
158. INSERT INTO `cdb_settings` VALUES ('smcols', '3');
     
159. INSERT INTO `cdb_settings` VALUES ('smileyinsert', '1');
     
160. INSERT INTO `cdb_settings` VALUES ('starthreshold', '2');
     
161. INSERT INTO `cdb_settings` VALUES ('statscachelife', '180');
     
162. INSERT INTO `cdb_settings` VALUES ('statstatus', '');
     
163. INSERT INTO `cdb_settings` VALUES ('styleid', '1');
     
164. INSERT INTO `cdb_settings` VALUES ('stylejump', '0');
     
165. INSERT INTO `cdb_settings` VALUES ('subforumsindex', '');
     
166. INSERT INTO `cdb_settings` VALUES ('threadmaxpages', '1000');
     
167. INSERT INTO `cdb_settings` VALUES ('timeformat', 'h:i A');
     
168. INSERT INTO `cdb_settings` VALUES ('timeoffset', '8');
     
169. INSERT INTO `cdb_settings` VALUES ('topicperpage', '20');
     
170. INSERT INTO `cdb_settings` VALUES ('transfermincredits', '1000');
     
171. INSERT INTO `cdb_settings` VALUES ('transsidstatus', '0');
     
172. INSERT INTO `cdb_settings` VALUES ('userstatusby', '1');
     
173. INSERT INTO `cdb_settings` VALUES ('visitbanperiods', '');
     
174. INSERT INTO `cdb_settings` VALUES ('visitedforums', '10');
     
175. INSERT INTO `cdb_settings` VALUES ('vtonlinestatus', '1');
     
176. INSERT INTO `cdb_settings` VALUES ('wapcharset', '2');
     
177. INSERT INTO `cdb_settings` VALUES ('wapdateformat', 'n/j');
     
178. INSERT INTO `cdb_settings` VALUES ('wapmps', '500');
     
179. INSERT INTO `cdb_settings` VALUES ('wapppp', '5');
     
180. INSERT INTO `cdb_settings` VALUES ('wapstatus', '1');
     
181. INSERT INTO `cdb_settings` VALUES ('waptpp', '10');
     
182. INSERT INTO `cdb_settings` VALUES ('watermarkstatus', '0');
     
183. INSERT INTO `cdb_settings` VALUES ('watermarktrans', '65');
     
184. INSERT INTO `cdb_settings` VALUES ('welcomemsg', '');
     
185. INSERT INTO `cdb_settings` VALUES ('welcomemsgtxt', '');
     
186. INSERT INTO `cdb_settings` VALUES ('whosonlinestatus', '1');
     
187. INSERT INTO `cdb_settings` VALUES ('rewritestatus', '0');
     
188. INSERT INTO `cdb_settings` VALUES ('watermarkquality', '80');
     
189. 
     
190. 
     

复制代码

可乐王子

多谢金光老大，马上尝试。

nuet

老大就是老大

游向最深处

太简单了