首页 » 工作 » 正文

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

发布者:站点默认
2012/02/24 浏览数(3,343) 分类:工作 评论(1)

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

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表

uc_pms表

<完>

点击返回顶部
  1. 留言
  2. 联系方式