Table 'uc.uc_pms' doesn't exist,uc_pms不存在解决
2011-07-09 15:30
1912人阅读
评论 (0)
Tags:
UCHome出现了Table 'uc.uc_pms' doesn't exist
最后找到了uc_pms表的结构,去phpmyadmin里边执行一下就好了。
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=utf8 AUTO_INCREMENT=1 ;