SupeSite6.0.1_X-Space4.0.1聚合dz7.2后,打开空间时报错:

SupeSite6.0.1_X-Space4.0.1聚合dz7.2后,打开空间时报错:SupeSite info: MySQL Query ErrorUser: GuestTime: 2009-11-10 9:24pmScript: /index.phpSQL: SELECT t.tid, t.author, t.subject, t.fid, t.views, t.replies, t.dateline, t.lastpost FROM `discuz`.`mythreads` m, `discuz`.`threads` t WHERE m.uid=’1′ AND m.tid=t.tid AND t.displayorder>=0 AND t.author!=” ORDER BY t.tid DESC LIMIT 0,10Error: Table ‘discuz.mythreads’ doesn’t existErrno.: 1146这是因为dz7.1中删除了两个表,需要添加上才可以正常使用,在phpmyadmin中执行下面的两个建表语句:CREATE TABLE IF NOT EXISTS `cdb_myposts` (`uid` mediumint(8) unsigned NOT NULL default ‘0’,`tid` mediumint(8) unsigned NOT NULL default ‘0’,`pid` int(10) unsigned NOT NULL default ‘0’,`position` smallint(6) unsigned NOT NULL default ‘0’,`dateline` int(10) unsigned NOT NULL default ‘0’,`special` tinyint(1) unsigned NOT NULL default ‘0’,PRIMARY KEY (`uid`,`tid`),KEY `tid` (`tid`,`dateline`)) ENGINE=MyISAM DEFAULT CHARSET=gbk;CREATE TABLE IF NOT EXISTS `cdb_mythreads` (`uid` mediumint(8) unsigned NOT NULL default ‘0’,`tid` mediumint(8) unsigned NOT NULL default ‘0’,`special` tinyint(1) unsigned NOT NULL default ‘0’,`dateline` int(10) NOT NULL default ‘0’,PRIMARY KEY (`uid`,`tid`),KEY `tid` (`tid`,`dateline`)) ENGINE=MyISAM DEFAULT CHARSET=gbk;注意:执行时,要与自己的表前缀一致。 我没有值得分享的感伤爱情故事,

SupeSite6.0.1_X-Space4.0.1聚合dz7.2后,打开空间时报错:

相关文章:

你感兴趣的文章:

标签云: