Discuz! info: MySQL Query Error

Discuz! info: MySQL Query Error

Time: 2006-4-26 4:53am
Script: /index.php

SQL: SELECT * FROM cdb_settings WHERE variable NOT IN ('bbrules', 'bbrulestxt', 'maxonlines', 'welcomemsg', 'welcomemsgtxt', 'newsletter', 'creditsnotify', 'custombackup')
Error: Table 'test.cdb_settings' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

帮忙 谢谢

数据表 没有创建  ！ 怎么创建！ 谢谢

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

CREATE TABLE `cdb_settings` (
  `variable` varchar(32) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`variable`)
) TYPE=MyISAM;
INSERT INTO `cdb_settings` VALUES ('adminipaccess', '');
INSERT INTO `cdb_settings` VALUES ('archiverstatus', '1');
INSERT INTO `cdb_settings` VALUES ('attachimgpost', '1');
INSERT INTO `cdb_settings` VALUES ('attachrefcheck', '');
INSERT INTO `cdb_settings` VALUES ('attachsave', '0');
INSERT INTO `cdb_settings` VALUES ('authkey', 'r49kI8Oaj1DoYke');
INSERT INTO `cdb_settings` VALUES ('avatarshowdefault', '0');
INSERT INTO `cdb_settings` VALUES ('avatarshowheight', '200');
INSERT INTO `cdb_settings` VALUES ('avatarshowlink', '1');
INSERT INTO `cdb_settings` VALUES ('avatarshowpos', '3');
INSERT INTO `cdb_settings` VALUES ('avatarshowstatus', '0');
INSERT INTO `cdb_settings` VALUES ('avatarshowwidth', '135');
INSERT INTO `cdb_settings` VALUES ('bannedmessages', '1');
INSERT INTO `cdb_settings` VALUES ('bbclosed', '');
INSERT INTO `cdb_settings` VALUES ('bbinsert', '1');
INSERT INTO `cdb_settings` VALUES ('bbname', 'Discuz! Board');
INSERT INTO `cdb_settings` VALUES ('bbrules', '');
INSERT INTO `cdb_settings` VALUES ('bbrulestxt', '');
INSERT INTO `cdb_settings` VALUES ('censoremail', '');
INSERT INTO `cdb_settings` VALUES ('censoruser', '');
INSERT INTO `cdb_settings` VALUES ('closedreason', '');
INSERT INTO `cdb_settings` VALUES ('creditsformula', 'extcredits1');
INSERT INTO `cdb_settings` VALUES ('creditsformulaexp', '');
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:{}}');
INSERT INTO `cdb_settings` VALUES ('creditstax', '0.2');
INSERT INTO `cdb_settings` VALUES ('creditstrans', '0');
INSERT INTO `cdb_settings` VALUES ('dateformat', 'Y-n-j');
INSERT INTO `cdb_settings` VALUES ('debug', '1');
INSERT INTO `cdb_settings` VALUES ('delayviewcount', '');
INSERT INTO `cdb_settings` VALUES ('deletereason', '');
INSERT INTO `cdb_settings` VALUES ('dotfolders', '');
INSERT INTO `cdb_settings` VALUES ('doublee', '1');
INSERT INTO `cdb_settings` VALUES ('dupkarmarate', '0');
INSERT INTO `cdb_settings` VALUES ('ec_account', '');
INSERT INTO `cdb_settings` VALUES ('ec_maxcredits', '1000');
INSERT INTO `cdb_settings` VALUES ('ec_maxcreditspermonth', '0');
INSERT INTO `cdb_settings` VALUES ('ec_mincredits', '0');
INSERT INTO `cdb_settings` VALUES ('ec_ratio', '0');
INSERT INTO `cdb_settings` VALUES ('ec_securitycode', '');
INSERT INTO `cdb_settings` VALUES ('editedby', '1');
INSERT INTO `cdb_settings` VALUES ('edittimelimit', '');
INSERT INTO `cdb_settings` VALUES ('exchangemincredits', '100');
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;}}');
INSERT INTO `cdb_settings` VALUES ('fastpost', '1');
INSERT INTO `cdb_settings` VALUES ('floodctrl', '15');
INSERT INTO `cdb_settings` VALUES ('forumjump', '1');
INSERT INTO `cdb_settings` VALUES ('fullmytopics', '1');
INSERT INTO `cdb_settings` VALUES ('globalstick', '0');
INSERT INTO `cdb_settings` VALUES ('gzipcompress', '');
INSERT INTO `cdb_settings` VALUES ('hideprivate', '1');
INSERT INTO `cdb_settings` VALUES ('hottopic', '10');
INSERT INTO `cdb_settings` VALUES ('initcredits', '0,0,0,0,0,0,0,0,0');
INSERT INTO `cdb_settings` VALUES ('ipaccess', '');
INSERT INTO `cdb_settings` VALUES ('ipregctrl', '');
INSERT INTO `cdb_settings` VALUES ('jscachelife', '1800');
INSERT INTO `cdb_settings` VALUES ('jsrefdomains', '');
INSERT INTO `cdb_settings` VALUES ('jsstatus', '0');
INSERT INTO `cdb_settings` VALUES ('karmaratelimit', '0');
INSERT INTO `cdb_settings` VALUES ('loadctrl', '');
INSERT INTO `cdb_settings` VALUES ('losslessdel', '365');
INSERT INTO `cdb_settings` VALUES ('maxavatarpixel', '120');
INSERT INTO `cdb_settings` VALUES ('maxavatarsize', '20000');
INSERT INTO `cdb_settings` VALUES ('maxchargespan', '0');
INSERT INTO `cdb_settings` VALUES ('maxincperthread', '0');
INSERT INTO `cdb_settings` VALUES ('maxonlines', '5000');
INSERT INTO `cdb_settings` VALUES ('maxpolloptions', '10');
INSERT INTO `cdb_settings` VALUES ('maxpostsize', '10000');
INSERT INTO `cdb_settings` VALUES ('maxsearchresults', '500');
INSERT INTO `cdb_settings` VALUES ('maxsigrows', '20');
INSERT INTO `cdb_settings` VALUES ('maxsmilies', '3');
INSERT INTO `cdb_settings` VALUES ('maxthreadads', '0');
INSERT INTO `cdb_settings` VALUES ('membermaxpages', '100');
INSERT INTO `cdb_settings` VALUES ('memberperpage', '25');
INSERT INTO `cdb_settings` VALUES ('memliststatus', '1');
INSERT INTO `cdb_settings` VALUES ('minpostsize', '0');
INSERT INTO `cdb_settings` VALUES ('moddisplay', 'flat');
INSERT INTO `cdb_settings` VALUES ('modratelimit', '0');
INSERT INTO `cdb_settings` VALUES ('modreasons', '广告/SPAM\r\n恶意灌水\r\n违规内容\r\n文不对题\r\n重复发帖\r\n\r\n我很赞同\r\n精品文章\r\n原创内容');
INSERT INTO `cdb_settings` VALUES ('newbiespan', '0');
INSERT INTO `cdb_settings` VALUES ('nocacheheaders', '');
INSERT INTO `cdb_settings` VALUES ('oltimespan', '10');
INSERT INTO `cdb_settings` VALUES ('onlinerecord', '1 1040034649');
INSERT INTO `cdb_settings` VALUES ('passport_expire', '3600');
INSERT INTO `cdb_settings` VALUES ('passport_extcredits', '0');
INSERT INTO `cdb_settings` VALUES ('passport_key', '');
INSERT INTO `cdb_settings` VALUES ('passport_login_url', '');
INSERT INTO `cdb_settings` VALUES ('passport_logout_url', '');
INSERT INTO `cdb_settings` VALUES ('passport_register_url', '');
INSERT INTO `cdb_settings` VALUES ('passport_status', '');
INSERT INTO `cdb_settings` VALUES ('passport_url', '');
INSERT INTO `cdb_settings` VALUES ('postbanperiods', '');
INSERT INTO `cdb_settings` VALUES ('postmodperiods', '');
INSERT INTO `cdb_settings` VALUES ('postperpage', '10');
INSERT INTO `cdb_settings` VALUES ('pvfrequence', '60');
INSERT INTO `cdb_settings` VALUES ('qihoostatus', '0');
INSERT INTO `cdb_settings` VALUES ('regctrl', '0');
INSERT INTO `cdb_settings` VALUES ('regstatus', '1');
INSERT INTO `cdb_settings` VALUES ('regverify', '0');
INSERT INTO `cdb_settings` VALUES ('reportpost', '1');
INSERT INTO `cdb_settings` VALUES ('rssstatus', '1');
INSERT INTO `cdb_settings` VALUES ('rssttl', '60');
INSERT INTO `cdb_settings` VALUES ('searchbanperiods', '');
INSERT INTO `cdb_settings` VALUES ('searchbox', '0');
INSERT INTO `cdb_settings` VALUES ('searchctrl', '30');
INSERT INTO `cdb_settings` VALUES ('seccodestatus', '0');
INSERT INTO `cdb_settings` VALUES ('seodescription', '');
INSERT INTO `cdb_settings` VALUES ('seohead', '');
INSERT INTO `cdb_settings` VALUES ('seokeywords', '');
INSERT INTO `cdb_settings` VALUES ('seotitle', '');
INSERT INTO `cdb_settings` VALUES ('showemail', '');
INSERT INTO `cdb_settings` VALUES ('sitename', 'Comsenz Technology Ltd');
INSERT INTO `cdb_settings` VALUES ('siteurl', 'http://www.comsenz.com/');
INSERT INTO `cdb_settings` VALUES ('smcols', '3');
INSERT INTO `cdb_settings` VALUES ('smileyinsert', '1');
INSERT INTO `cdb_settings` VALUES ('starthreshold', '2');
INSERT INTO `cdb_settings` VALUES ('statscachelife', '180');
INSERT INTO `cdb_settings` VALUES ('statstatus', '');
INSERT INTO `cdb_settings` VALUES ('styleid', '1');
INSERT INTO `cdb_settings` VALUES ('stylejump', '0');
INSERT INTO `cdb_settings` VALUES ('subforumsindex', '');
INSERT INTO `cdb_settings` VALUES ('threadmaxpages', '1000');
INSERT INTO `cdb_settings` VALUES ('timeformat', 'h:i A');
INSERT INTO `cdb_settings` VALUES ('timeoffset', '8');
INSERT INTO `cdb_settings` VALUES ('topicperpage', '20');
INSERT INTO `cdb_settings` VALUES ('transfermincredits', '1000');
INSERT INTO `cdb_settings` VALUES ('transsidstatus', '0');
INSERT INTO `cdb_settings` VALUES ('userstatusby', '1');
INSERT INTO `cdb_settings` VALUES ('visitbanperiods', '');
INSERT INTO `cdb_settings` VALUES ('visitedforums', '10');
INSERT INTO `cdb_settings` VALUES ('vtonlinestatus', '1');
INSERT INTO `cdb_settings` VALUES ('wapcharset', '2');
INSERT INTO `cdb_settings` VALUES ('wapdateformat', 'n/j');
INSERT INTO `cdb_settings` VALUES ('wapmps', '500');
INSERT INTO `cdb_settings` VALUES ('wapppp', '5');
INSERT INTO `cdb_settings` VALUES ('wapstatus', '1');
INSERT INTO `cdb_settings` VALUES ('waptpp', '10');
INSERT INTO `cdb_settings` VALUES ('watermarkstatus', '0');
INSERT INTO `cdb_settings` VALUES ('watermarktrans', '65');
INSERT INTO `cdb_settings` VALUES ('welcomemsg', '');
INSERT INTO `cdb_settings` VALUES ('welcomemsgtxt', '');
INSERT INTO `cdb_settings` VALUES ('whosonlinestatus', '1');

谢谢你 但是问题换了 为什么 帮忙再看看Discuz! info: MySQL Query Error

Time: 2006-4-26 5:29am
Script: /index.php

SQL: SELECT * FROM cdb_settings WHERE variable NOT IN ('bbrules', 'bbrulestxt', 'maxonlines', 'welcomemsg', 'welcomemsgtxt', 'newsletter', 'creditsnotify', 'custombackup')
Error: No Database Selected
Errno.: 1046

An error report has been dispatched to our administrator.

我也是同上面的问题，那为大哥帮忙解决一下呀~

請問....如果只是在MySQL中..加上一個名為cdb_setting資料庫及加上`variable` varchar(32) NOT NULL default '',`value` text NOT NULL,PRIMARY KEY...能否解決?..
或是必須依大大的方法更改~?...謝謝~我新手亦有此問題..