本帖最后由 n2008 于 2011-5-22 01:38 编辑
升级到X2后,按最后提示建议删除表uc_pms,没想到进入我的品牌空间(http://vip.532700.com)马上提示出错。补救,提取表uc_pms结构,重新导入数据库。在X2后台运行SQL——
- CREATE TABLE IF NOT EXISTS `uc_pms` (
- `pmid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `msgfrom` varchar(15) NOT NULL DEFAULT '',
- `msgfromid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `msgtoid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `folder` enum('inbox','outbox') NOT NULL DEFAULT 'inbox',
- `new` tinyint(1) NOT NULL DEFAULT '0',
- `subject` varchar(75) NOT NULL DEFAULT '',
- `dateline` int(10) unsigned NOT NULL DEFAULT '0',
- `message` text NOT NULL,
- `delstatus` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `related` int(10) unsigned NOT NULL DEFAULT '0',
- `fromappid` smallint(6) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`pmid`),
- KEY `msgtoid` (`msgtoid`,`folder`,`dateline`),
- KEY `msgfromid` (`msgfromid`,`folder`,`dateline`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
复制代码
|