SupeSite X-Space6.0.1聚合dz7.1后,打开空间时报错:
SupeSite info: MySQL Query Error
User: Guest
Time: 2009-11-10 9:24pm
Script: /index.php
SQL: SELECT t.tid, t.author, t.subject, t.fid, t.views, t.replies, t.dateline, t.lastpost FROM `discuz`.`[Table]mythreads` m, `discuz`.`[Table]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,10
Error: Table ‘discuz.[Table]mythreads’ doesn’t exist
Errno.: 1146
这是因为dz7.1中删除了两个表,需要添加上才可以正常使用,在phpmyadmin中执行下面的两个建表语句
CREATE TABLE IF NOT EXISTS `bbs_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 `bbs_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;
注意:执行时,要与自己的表前缀一致。
玩linux…做运维…集群..
在你生活出现失意和疲惫时能给你一点儿力量和希冀,只愿你幸福快乐。