huxiuchang

Table 'uc.uc_pms' doesn't exist,uc_pms不存在解决

2013-11-01 / BUG / none / 次围观 / 快抢沙发

u=520653853,3282311070&fm=21&gp=0.jpg第一次安装discuz,安装成功后跳到首页,报如下错误:
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'
查了下 ,数据库ucenter里没有uc_pms表。
经过搜索,在一篇帖子里提到的方法新建这个表:
DROP TABLE IF EXISTS uc_pms;
CREATE TABLE 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',
PRIMARY KEY(pmid),
KEY msgtoid(msgtoid,folder,dateline),
KEY msgfromid(msgfromid,folder,dateline),
KEY related (related),
KEY getnum (msgtoid,folder,delstatus)
) TYPE=MyISAM;

本博客所有文章如无特别注明均为原创。
复制或转载请以超链接形式注明转自锅巴菜,原文地址《Table 'uc.uc_pms' doesn't exist,uc_pms不存在解决
上一篇: linux route 命令 下一篇: vi/vim多行注释和取消注释

> 添加新评论

Copyright © 锅巴菜 津ICP备15001834号-1