ss6.0.1聚合dz7.1后,打开空间时报错:
这是因为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',
- `dateline` int(10) NOT NULL default '0',`dateline`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
注意:执行时,要与自己的表前缀一致,以及字符集也要注意!
原文链接:https://www.f2er.com/javaschema/287672.html