是不是缺表或者表结构太老了呀? 比一比呢，下面是cvs里面的


CREATE TABLE `blacklist` (
  `userid` varchar(12) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `manager` varchar(12) NOT NULL default '',
  `hostname` varchar(20) NOT NULL default '',
  `addtime` timestamp(14) NOT NULL,
  KEY `userid` (`userid`,`uid`)
) TYPE=MyISAM COMMENT='blog黑名单';

CREATE TABLE `comments` (
  `cid` int(10) unsigned NOT NULL auto_increment,
  `nid` int(10) unsigned default NULL,
  `uid` int(10) default NULL,
  `hostname` varchar(20) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `subject` varchar(200) NOT NULL default 'null',
  `created` timestamp(14) NOT NULL,
  `changed` timestamp(14) NOT NULL,
  `body` text,
  `emote` int(2) NOT NULL default '0',
  `htmltag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `nid` (`nid`),
  KEY `created` (`created`),
  KEY `changed` (`changed`),
  FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM COMMENT='评论表' ;

CREATE TABLE `filter` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `nid` int(10) NOT NULL default '0',
  `pid` int(10) unsigned default NULL,
  `type` int(4) NOT NULL default '0',
  `state` int(1) NOT NULL default '0',
  `source` varchar(10) NOT NULL default '',
  `hostname` varchar(20) NOT NULL default '',
  `changed` timestamp(14) NOT NULL,
  `created` timestamp(14) NOT NULL,
  `uid` int(10) default NULL,
  `username` varchar(13) NOT NULL default '',
  `comment` int(4) NOT NULL default '0',
  `commentcount` int(10) NOT NULL default '0',
  `subject` varchar(200) NOT NULL default 'null',
  `body` text,
  `access` int(4) NOT NULL default '0',
  `visitcount` int(4) NOT NULL default '0',
  `tid` int(10) NOT NULL default '0',
  `emote` int(2) NOT NULL default '0',
  `htmltag` int(1) NOT NULL default '0',
  `trackback` int(1) NOT NULL default '1',
  `trackbackcount` int(10) NOT NULL default '0',
  `recommend` int(1) NOT NULL default '0',
  `updatetime` timestamp(14) NOT NULL,
  `nodetype` int(1) NOT NULL default '0',
  `recuser` varchar(12) NOT NULL default '',
  `tbp_url` varchar(255) NOT NULL default '',
  `tbp_art` varchar(255) NOT NULL default '',
  `auto_tbp` int(1) NOT NULL default '0',
  PRIMARY KEY  (`fid`),
  KEY `pid` (`pid`),
  KEY `created` (`changed`),
  KEY `changed` (`created`),
  KEY `state` (`state`),
  FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM COMMENT='过滤器' ;

CREATE TABLE `logs` (
  `lid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `hostname` varchar(20) NOT NULL default '',
  `ACTION` varchar(100) NOT NULL default '',
  `pri_id` varchar(20) default NULL,
  `sec_id` varchar(20) default NULL,
  `COMMENT` varchar(200) default NULL,
  `logtime` timestamp(14) NOT NULL,
  PRIMARY KEY  (`lid`),
  KEY `username` (`username`,`hostname`,`ACTION`,`pri_id`,`sec_id`,`logtime`)
) TYPE=MyISAM COMMENT='日志表' ;

CREATE TABLE `members` (
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(12) NOT NULL default '',
  KEY `username` (`username`),
  KEY `uid` (`uid`)
) TYPE=MyISAM COMMENT='公有blog成员表';

CREATE TABLE `newapply` (
  `naid` int(10) NOT NULL auto_increment,
  `username` varchar(12) NOT NULL default '',
  `appname` varchar(50) NOT NULL default '',
  `appself` text NOT NULL,
  `appdirect` text NOT NULL,
  `hostname` varchar(15) NOT NULL default '',
  `apptime` timestamp(14) NOT NULL,
  `manager` varchar(12) default NULL,
  `management` int(1) unsigned NOT NULL default '1',
  UNIQUE KEY `naid_2` (`naid`),
  KEY `naid` (`naid`),
  KEY `username` (`username`),
  KEY `management` (`management`)
) TYPE=MyISAM COMMENT='新申请用户' ;

CREATE TABLE `nodes` (
  `nid` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned default NULL,
  `type` int(4) NOT NULL default '0',
  `source` varchar(10) NOT NULL default '',
  `hostname` varchar(20) NOT NULL default '',
  `changed` timestamp(14) NOT NULL,
  `created` timestamp(14) NOT NULL,
  `uid` int(10) default NULL,
  `comment` int(4) NOT NULL default '0',
  `commentcount` int(10) NOT NULL default '0',
  `subject` varchar(200) NOT NULL default 'null',
  `body` text,
  `access` int(4) NOT NULL default '0',
  `visitcount` int(4) NOT NULL default '0',
  `tid` int(10) NOT NULL default '0',
  `emote` int(2) NOT NULL default '0',
  `htmltag` int(1) NOT NULL default '0',
  `trackback` int(1) NOT NULL default '1',
  `trackbackcount` int(10) NOT NULL default '0',
  `recommend` int(1) NOT NULL default '0',
  `updatetime` timestamp(14) NOT NULL,
  `nodetype` int(1) NOT NULL default '0',
  `recuser` varchar(12) NOT NULL default '',
  `rectopic` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`nid`),
  KEY `pid` (`pid`),
  KEY `created` (`changed`),
  KEY `changed` (`created`),
  KEY `tid` (`tid`),
  KEY `nodetype` (`nodetype`),
  KEY `rectopic` (`rectopic`),
  KEY `trackbackcount` (`trackbackcount`),
  KEY `visitcount` (`visitcount`),
  KEY `commentcount` (`commentcount`),
  FULLTEXT KEY `body` (`body`),
  FULLTEXT KEY `subject` (`subject`)
) TYPE=MyISAM COMMENT='文章表' ;

CREATE TABLE `recommend` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `nid` int(10) unsigned NOT NULL default '0',
  `hostname` varchar(20) NOT NULL default '',
  `created` timestamp(14) NOT NULL,
  `uid` int(10) default NULL,
  `subject` varchar(200) NOT NULL default 'null',
  `body` text,
  `emote` int(2) NOT NULL default '0',
  `htmltag` int(1) NOT NULL default '0',
  `recuser` varchar(12) NOT NULL default '',
  `state` int(1) NOT NULL default '1',
  `topic` varchar(20) NOT NULL default '0',
  PRIMARY KEY  (`rid`),
  KEY `rid` (`rid`),
  KEY `topic` (`topic`),
  FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM COMMENT='推荐文章' ;

CREATE TABLE `topics` (
  `tid` int(10) NOT NULL auto_increment,
  `uid` int(10) NOT NULL default '0',
  `access` int(1) NOT NULL default '0',
  `topicname` varchar(100) NOT NULL default '',
  `sequen` int(2) NOT NULL default '0',
  KEY `tid` (`tid`)
) TYPE=MyISAM COMMENT='用户文集分类' ;

CREATE TABLE `trackback` (
  `tbid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `excerpt` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `blogname` varchar(50) NOT NULL default '',
  `time` timestamp(14) NOT NULL,
  `address` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`tbid`)
) TYPE=MyISAM COMMENT='引用通告' ;

CREATE TABLE `userfiles` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `type` int(1) unsigned NOT NULL default '0',
  `filename` varchar(200) NOT NULL default '',
  `filepath` varchar(255) NOT NULL default '',
  `hostname` varchar(15) NOT NULL default '',
  `filetime` timestamp(14) NOT NULL,
  `filesize` int(10) unsigned NOT NULL default '0',
  `filetype` varchar(50) NOT NULL default '',
  `access` int(1) unsigned NOT NULL default '0',
  `remark` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`fid`),
  KEY `uid` (`uid`),
  KEY `pid` (`pid`),
  KEY `type` (`type`),
  KEY `access` (`access`)
) TYPE=MyISAM COMMENT='用户文件夹' ;

CREATE TABLE `users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `corpusname` varchar(40) NOT NULL default '',
  `description` varchar(200) default NULL,
  `theme` varchar(20) default NULL,
  `nodelimit` int(8) NOT NULL default '300',
  `dirlimit` int(8) NOT NULL default '100',
  `createtime` timestamp(14) NOT NULL,
  `style` int(2) NOT NULL default '0',
  `backimage` varchar(255) default NULL,
  `visitcount` int(10) NOT NULL default '0',
  `nodescount` int(10) NOT NULL default '0',
  `logoimage` varchar(255) default NULL,
  `modifytime` timestamp(14) NOT NULL,
  `links` text NOT NULL,
  `htmleditor` int(1) NOT NULL default '0',
  `indexnodechars` int(5) NOT NULL default '600',
  `indexnodes` int(1) NOT NULL default '5',
  `useremail` varchar(200) NOT NULL default '',
  `favmode` int(1) NOT NULL default '0',
  `updatetime` timestamp(14) NOT NULL,
  `userinfor` text NOT NULL,
  `pctype` int(1) NOT NULL default '0',
  `tempsave` int(1) NOT NULL default '1',
  `defaulttopic` varchar(100) NOT NULL default '',
  `userfile` int(10) NOT NULL default '0',
  `filelimit` int(10) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`),
  KEY `corpusname` (`corpusname`,`createtime`),
  KEY `pctype` (`pctype`),
  KEY `theme` (`theme`)
) TYPE=MyISAM COMMENT='用户表' ;

CREATE TABLE `userstyle` (
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(12) NOT NULL default '',
  `hostname` varchar(15) NOT NULL default '',
  `changed` timestamp(14) NOT NULL,
  `indexxsl` text NOT NULL,
  `nodexsl` text NOT NULL,
  `css` text NOT NULL,
  `stylesheet` int(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `uid` (`uid`),
  KEY `username` (`username`)
) TYPE=MyISAM COMMENT='自定义界面';

    
【 在 wuweixin (有颜色的猫) 的大作中提到: 】
: sysconf.ini 已经修改 ,mysql已经安装完毕
: 新开了两个版面 SMTH_blog BlogApply
: 用户在申请的时候遇到这样的问题
: ...................
--
FROM 219.224.182.*