解决方法：discuz、uchome提示uc_pms表不存在

点击“短消息”功能时提示：

Error:Table ‘ucenter.uc_pms’ doesn’t exist

Errno:1146

SQL::SELECT count(*) FROM `ucenter`.uc_pms WHERE (related=’0′ AND msgfromid>’0′ OR msgfromid=’0′) AND msgtoid=’0′ AND folder=’inbox’ AND new=’1′

解决办法：

在数据库中建立一个uc_pms表即可，SQL如下：

CREATE TABLE IF NOT EXISTS `uc_pms` (
  `pmid` int(10) unsigned NOT NULL auto_increment,
  `msgfrom` varchar(15) character set utf8 NOT NULL default '',
  `msgfromid` mediumint(8) unsigned NOT NULL default '0',
  `msgtoid` mediumint(8) unsigned NOT NULL default '0',
  `folder` enum('inbox','outbox') character set utf8 NOT NULL default 'inbox',
  `new` tinyint(1) NOT NULL default '0',
  `subject` varchar(75) character set utf8 NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `message` text character set utf8 NOT NULL,
  `delstatus` tinyint(1) unsigned NOT NULL default '0',
  `related` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `msgtoid` (`msgtoid`,`folder`,`dateline`),
  KEY `msgfromid` (`msgfromid`,`folder`,`dateline`),
  KEY `related` (`related`),
  KEY `getnum` (`msgtoid`,`folder`,`delstatus`)
) ENGINE=MyISAM;

uc_pms表

＜完＞